The ADRCITY table in SAP ERP or S/4HANA stores Postal cities data. There are total 14 fields in ADRCITY table. The Postal cities table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ADRCITY table. It is in SAP Technology – Business Services: Regional Structure (SZRS) ABAP package and is part of the Address Management/Business Address (BC-SRV-ADR) module.
SAP ADRCITY Table Fields
Following is the list of fields that are available in SAP ADRCITY table. The primary key fields of the table are CLIENT (Client), COUNTRY (Country/Region Key), CITY_CODE (City Code for City/Street File).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| COUNTRY | Country/Region Key | LAND1 | T005 | CHAR (3) |
| CITY_CODE | City Code for City/Street File | CITY_CODE | CHAR (12) | |
| COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR (8) | |
| TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR (8) | |
| COMMU_CODE | Municipality key | COMMU_CODE | CHAR (15) | |
| FLAG_STRTS | Flag: Street directory exists | FLAG_STRTS | CHAR (1) | |
| REGION | Region (State, Province, County) | REGIO | T005S | CHAR (3) |
| TIME_ZONE | Address time zone | AD_TZONE | * | CHAR (6) |
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR (15) | |
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | * | CHAR (10) |
| DEF_LANGU | Default language for city | DEF_LANGU | * | LANG (1) |
| REGIOGROUP | Regional structure grouping | REGIOGROUP | * | CHAR (8) |
| CITY_CD_PS | Coding of different postal city for City/Street file | CITY_CD_PS | CHAR (12) |
