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