SAP Table ADRCITYPRT
Postal districts
ADRCITYPRT (Postal districts) 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 ADRCITYPRT to other SAP tables.
ADRCITYPRT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
| CITY_CODE | City Code for City/Street File | CITY_CODE | ADRCITY | CHAR | 12 | 0 | ||
| CITYP_CODE | District code for city and street file | CITYP_CODE | CHAR | 8 | 0 | |||
| POST_CODE | Postal Code | POST_CODE | ADRPSTCODE | CHAR | 10 | 0 | ||
| CITY_PART | District | AD_CITY2 | CHAR | 40 | 0 | |||
| COMMU_CODE | Municipality key | COMMU_CODE | CHAR | 15 | 0 | |||
ADRCITYPRT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRCITYPRT | CITY_CODE | ADRCITYPRT | CLIENT | ADRCITY | Postal cities | CLIENT |
| ADRCITYPRT | CITY_CODE | ADRCITYPRT | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRCITYPRT | CITY_CODE | ADRCITYPRT | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADRCITYPRT | CLIENT | ADRCITYPRT | CLIENT | T000 | Clients | MANDT |
| ADRCITYPRT | COUNTRY | ADRCITYPRT | CLIENT | T005 | Countries | MANDT |
| ADRCITYPRT | COUNTRY | ADRCITYPRT | COUNTRY | T005 | Countries | LAND1 |
| ADRCITYPRT | POST_CODE | ADRCITYPRT | CLIENT | ADRPSTCODE | Postal codes | CLIENT |
| ADRCITYPRT | POST_CODE | ADRCITYPRT | COUNTRY | ADRPSTCODE | Postal codes | COUNTRY |
| ADRCITYPRT | POST_CODE | ADRCITYPRT | POST_CODE | ADRPSTCODE | Postal codes | POST_CODE |
