SAP Table ADRCITY (Postal cities)
SAP table ADRCITY has 3 primary key fields being CLIENT,COUNTRY,CITY_CODE.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| COUNTRY | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| 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 |
ADRCITY foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ADRCITY | CLIENT | T000 | Clients | MANDT |
| 1 ADRCITY | COUNTRY | T005 | Countries | MANDT |
| 1 ADRCITY | COUNTRY | T005 | Countries | LAND1 |
| 0 ADRCITY | REGION | T005S | Taxes: Region (Province) Key | LAND1 |