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 | Possible values |
|---|---|---|---|---|---|---|
|
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 | MANDT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| OIFSMCADDR | ADDRNUM | OIFSMCADDR | ADDRNUM |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| OIFSMCADDR | ADDRNUM | OIFSMCADDR | DATE_FROM |
ADRC
Addresses (Business Address Services)
|
DATE_FROM |
| OIFSMCADDR | ADDRNUM | OIFSMCADDR | NATION |
ADRC
Addresses (Business Address Services)
|
NATION |
| OIFSMCADDR | MANDT | OIFSMCADDR | MANDT |
T000
Clients
|
MANDT |
| OIFSMCADDR | NATION | OIFSMCADDR | DATE_FROM |
ADRC
Addresses (Business Address Services)
|
DATE_FROM |
| 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 | PBLNR | OIFSMCADDR | MANDT |
OIFSPBL
Physical Location - Master Data
|
MANDT |
| OIFSMCADDR | PBLNR | OIFSMCADDR | PBLNR |
OIFSPBL
Physical Location - Master Data
|
PBLNR |