SAP Table OIFSMCADDR

Link Table Between OIFSPBL and ADRC for Matchcode

OIFSMCADDR (Link Table Between OIFSPBL and ADRC for Matchcode) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIFSMCADDR to other SAP tables.

OIFSMCADDR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR OIFSPBL CHAR 10 0
ADDRNUM Address No. in ADRC OIF_ADNUM ADRC CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
NATION Version ID for International Addresses AD_NATION ADRC CHAR 1 0

OIFSMCADDR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIFSMCADDR ADDRNUM OIFSMCADDR DATE_FROM ADRC Addresses (Business Address Services) DATE_FROM
OIFSMCADDR ADDRNUM OIFSMCADDR NATION ADRC Addresses (Business Address Services) NATION
OIFSMCADDR ADDRNUM OIFSMCADDR MANDT ADRC Addresses (Business Address Services) CLIENT
OIFSMCADDR ADDRNUM OIFSMCADDR ADDRNUM ADRC Addresses (Business Address Services) ADDRNUMBER
OIFSMCADDR MANDT OIFSMCADDR MANDT T000 Clients MANDT
OIFSMCADDR NATION OIFSMCADDR NATION ADRC Addresses (Business Address Services) NATION
OIFSMCADDR NATION OIFSMCADDR MANDT ADRC Addresses (Business Address Services) CLIENT
OIFSMCADDR NATION OIFSMCADDR ADDRNUM ADRC Addresses (Business Address Services) ADDRNUMBER
OIFSMCADDR NATION OIFSMCADDR DATE_FROM ADRC Addresses (Business Address Services) DATE_FROM
OIFSMCADDR PBLNR OIFSMCADDR MANDT OIFSPBL Physical Location - Master Data MANDT
OIFSMCADDR PBLNR OIFSMCADDR PBLNR OIFSPBL Physical Location - Master Data PBLNR