SAP Table ADRPCDCITY
Postal code/city: Assignment table
ADRPCDCITY (Postal code/city: Assignment table) 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 ADRPCDCITY to other SAP tables.
ADRPCDCITY table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
| POST_CODE | Postal Code | POST_CODE | ADRPSTCODE | CHAR | 10 | 0 | ||
| CITY_CODE | City Code for City/Street File | CITY_CODE | ADRCITY | CHAR | 12 | 0 | ||
ADRPCDCITY foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRPCDCITY | CITY_CODE | ADRPCDCITY | CLIENT | ADRCITY | Postal cities | CLIENT |
| ADRPCDCITY | CITY_CODE | ADRPCDCITY | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRPCDCITY | CITY_CODE | ADRPCDCITY | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADRPCDCITY | CLIENT | ADRPCDCITY | CLIENT | T000 | Clients | MANDT |
| ADRPCDCITY | COUNTRY | ADRPCDCITY | COUNTRY | T005 | Countries | LAND1 |
| ADRPCDCITY | COUNTRY | ADRPCDCITY | CLIENT | T005 | Countries | MANDT |
| ADRPCDCITY | POST_CODE | ADRPCDCITY | CLIENT | ADRPSTCODE | Postal codes | CLIENT |
| ADRPCDCITY | POST_CODE | ADRPCDCITY | COUNTRY | ADRPSTCODE | Postal codes | COUNTRY |
| ADRPCDCITY | POST_CODE | ADRPCDCITY | POST_CODE | ADRPSTCODE | Postal codes | POST_CODE |
