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 | Possible values |
|---|---|---|---|---|---|---|
|
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 |