SAP table reference
ADRCITY
Postal citiesExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table ADRCITY.
SAP table ADRCITY has 3 primary key fields: CLIENT,COUNTRY,CITY_CODE.
/ Fields
ADRCITY fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key COUNTRY | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| Key CITY_CODE | City Code for City/Street File | CHAR | 12 | 0 | CITY_CODE | ||
| COUNTY_CODE | County code for county | CHAR | 8 | 0 | AD_CNTYNUM | ||
| TOWNSHIP_CODE | Township code for Township | CHAR | 8 | 0 | AD_TWSHPNUM | ||
| COMMU_CODE | Municipality key | CHAR | 15 | 0 | COMMU_CODE | ||
| FLAG_STRTS | Flag: Street directory exists | CHAR | 1 | 0 | FLAG_STRTS | ||
| REGION | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| TIME_ZONE | Address time zone | CHAR | 6 | 0 | * | AD_TZONE | |
| TAXJURCODE | Tax Jurisdiction | CHAR | 15 | 0 | AD_TXJCD | ||
| TRANSPZONE | Transportation zone to or from which the goods are delivered | CHAR | 10 | 0 | * | LZONE | |
| DEF_LANGU | Default language for city | LANG | 1 | 0 | * | DEF_LANGU | |
| REGIOGROUP | Regional structure grouping | CHAR | 8 | 0 | * | REGIOGROUP | |
| CITY_CD_PS | Coding of different postal city for City/Street file | CHAR | 12 | 0 | CITY_CD_PS |