SAP ADRCITY Postal cities Table
Overview
ADRCITY is a standard SAP S/4HANA table that stores Postal cities data. There are total 14 fields in the ADRCITY table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADRCITY belongs to Address Management/Business Address (BC-SRV-ADR) module and is located in the package SAP Technology - Business Services: Regional Structure (SZRS).
In addition, following links provide an overview of foreign key relationships, if any, that link ADRCITY to other SAP tables and standard CDS views available based on ADRCITY table in S/4HANA 2020.
Techincal Settings of ADRCITY
Below are technical details of the table ADRCITY
- Buffering switched on
- Single entries of table were buffered
- Storage type is Column Store
List of ADRCITY Fields
The following table gives you an overview of the fields available in ADRCITY
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| 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 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADRCITY
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ADRCITY | CLIENT | 1: CN | T000 |
| ADRCITY | COUNTRY | 1: CN | T005 |
| ADRCITY | REGION | : | T005S |