OIFSMCADDR
Link Table Between OIFSPBL and ADRC for MatchcodeExplore 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.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key PBLNR | Business location identifier (IS-Oil MRN) | CHAR | 10 | 0 | OIFSPBL | OIF_PBLNR | |
| Key ADDRNUM | Address No. in ADRC | CHAR | 10 | 0 | ADRC | OIF_ADNUM | |
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | DATS | 8 | 0 | AD_DATE_FR | ||
| NATION | Version ID for International Addresses | CHAR | 1 | 0 | ADRC | AD_NATION |
OIFSMCADDR relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| OIFSMCADDR | ADDRNUM | ADRC | Addresses (Business Address Services) | DATE_FROM |
| OIFSMCADDR | ADDRNUM | ADRC | Addresses (Business Address Services) | NATION |
| OIFSMCADDR | MANDT | T000 | Clients | MANDT |
| OIFSMCADDR | NATION | ADRC | Addresses (Business Address Services) | DATE_FROM |
| OIFSMCADDR | NATION | ADRC | Addresses (Business Address Services) | NATION |
| OIFSMCADDR | PBLNR | OIFSPBL | Physical Location - Master Data | PBLNR |