SAP Table
ADRCITYPRT Postal districts
SAP table ADRCITYPRT has 4 primary key fields being CLIENT,COUNTRY,CITY_CODE,CITYP_CODE.
/ Fields
ADRCITYPRT columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyCLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyCOUNTRY | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| KeyCITY_CODE | City Code for City/Street File | CHAR | 12 | 0 | ADRCITY | CITY_CODE | |
| KeyCITYP_CODE | District code for city and street file | CHAR | 8 | 0 | CITYP_CODE | ||
| POST_CODE | Postal Code | CHAR | 10 | 0 | ADRPSTCODE | POST_CODE | |
| CITY_PART | District | CHAR | 40 | 0 | AD_CITY2 | ||
| COMMU_CODE | Municipality key | CHAR | 15 | 0 | COMMU_CODE |
/ Relationships
ADRCITYPRT foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| ADRCITYPRT | CITY_CODE | ADRCITY | Postal cities | COUNTRY |
| ADRCITYPRT | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADRCITYPRT | CLIENT | T000 | Clients | MANDT |
| ADRCITYPRT | COUNTRY | T005 | Countries | MANDT |
| ADRCITYPRT | COUNTRY | T005 | Countries | LAND1 |
| ADRCITYPRT | POST_CODE | ADRPSTCODE | Postal codes | COUNTRY |
| ADRCITYPRT | POST_CODE | ADRPSTCODE | Postal codes | POST_CODE |