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 |
