OIFSMCADDR

Link Table Between OIFSPBL and ADRC for Matchcode

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table OIFSMCADDR.

SAP table OIFSMCADDR has 3 primary key fields: MANDT,PBLNR,ADDRNUM.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

OIFSMCADDR fields.

5 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key PBLNR Business location identifier (IS-Oil MRN)CHAR100 OIFSPBL OIF_PBLNR
Key ADDRNUM Address No. in ADRCCHAR100 ADRC OIF_ADNUM
DATE_FROM Valid-from date - in current Release only 00010101 possibleDATS80 AD_DATE_FR
NATION Version ID for International AddressesCHAR10 ADRC AD_NATION

OIFSMCADDR relationships.

6 relationships
TableFieldCheck tableDescriptionCheck field
OIFSMCADDRADDRNUMADRCAddresses (Business Address Services)DATE_FROM
OIFSMCADDRADDRNUMADRCAddresses (Business Address Services)NATION
OIFSMCADDRMANDTT000ClientsMANDT
OIFSMCADDRNATIONADRCAddresses (Business Address Services)DATE_FROM
OIFSMCADDRNATIONADRCAddresses (Business Address Services)NATION
OIFSMCADDRPBLNROIFSPBLPhysical Location - Master DataPBLNR