SAP Table ADRCITY
Postal cities
ADRCITY (Postal cities) 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 ADRCITY to other SAP tables.
ADRCITY 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 | CHAR | 12 | 0 | |||||||
| COMMU_CODE | Municipality key | COMMU_CODE | CHAR | 15 | 0 | |||||||
| FLAG_STRTS | Flag: Street directory exists | FLAG_STRTS | CHAR | 1 | 0 |
Possible values
|
||||||
| REGION | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||
| TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | 0 | |||||||
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | 0 | |||||||
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | 0 | |||||||
| DEF_LANGU | Default language for city | DEF_LANGU | LANG | 1 | 0 | |||||||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | 0 | |||||||
| CITY_CD_PS | Coding of different postal city for City/Street file | CITY_CD_PS | CHAR | 12 | 0 | |||||||
| COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | 0 | |||||||
| TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | 0 | |||||||
ADRCITY foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRCITY | CLIENT | ADRCITY | CLIENT | T000 | Clients | MANDT |
| ADRCITY | COUNTRY | ADRCITY | CLIENT | T005 | Countries | MANDT |
| ADRCITY | COUNTRY | ADRCITY | COUNTRY | T005 | Countries | LAND1 |
| ADRCITY | REGION | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| ADRCITY | REGION | * | T005S | Taxes: Region (Province) Key | LAND1 | |
| ADRCITY | REGION | ADRCITY | REGION | T005S | Taxes: Region (Province) Key | BLAND |
