SAP Table ADRCITYD
Screen fields: City
ADRCITYD (Screen fields: City) 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 ADRCITYD to other SAP tables.
Source: ADRCITYD (Screen fields: City)
ADRCITYD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LANGU | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||
| COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||
| CITY_CODE | City Code for City/Street File | CITY_CODE | ADRCITY | 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 | TTZZ | CHAR | 6 | 0 | ||||||
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | 0 | |||||||
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 | 0 | ||||||
| DEF_LANGU | Default language for city | DEF_LANGU | T002 | LANG | 1 | 0 | ||||||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | ADRREGGRP | CHAR | 8 | 0 | ||||||
| CITY_CD_PS | Coding of different postal city for City/Street file | CITY_CD_PS | ADRCITY | CHAR | 12 | 0 | ||||||
| CITY_NAME | City | AD_CITY1 | CHAR | 40 | 0 | |||||||
| MC_CITY | City name in upper case for search help | AD_MC_CITY | CHAR | 25 | 0 | |||||||
| CITY_SHORT | Long abbreviation of the city name (24 chars) | CITY_SHORT | CHAR | 24 | 0 | |||||||
| CITY_SH10 | Short abbreviation of the city name (10 chars) | CITY_SH10 | CHAR | 10 | 0 | |||||||
| CITY_EXT | City name extension | CITY_EXT | CHAR | 30 | 0 | |||||||
| V_CITYCODE | City Code for City/Street File | CITY_CODE | ADRCITY | CHAR | 12 | 0 | ||||||
| NRNR | Number range number | NRNR | CHAR | 2 | 0 | |||||||
| REGIONNAME | Description | BEZEI20 | CHAR | 20 | 0 | |||||||
| TZONE_NAME | Description | BEZEI20 | CHAR | 20 | 0 | |||||||
| SPTXT | Name of Language | SPTXT | CHAR | 16 | 0 | |||||||
| LANDX | Country Name | LANDX | CHAR | 15 | 0 | |||||||
| DEF_SPTXT | Name of Language | SPTXT | CHAR | 16 | 0 | |||||||
| REGGRPNAME | Text Field | TEXT50 | CHAR | 50 | 0 | |||||||
| CITY_NM_PS | Name of different postal city for city/street file | CITY_NM_PS | CHAR | 40 | 0 | |||||||
| COUNTY_CODE | County code for county | AD_CNTYNUM | ADRCOUNTY | CHAR | 8 | 0 | ||||||
| COUNTY | County | AD_COUNTY | CHAR | 40 | 0 | |||||||
| TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | ADRTOWNSHIP | CHAR | 8 | 0 | ||||||
| TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | 0 | |||||||
ADRCITYD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRCITYD | CITY_CD_PS | ADRCITYD | CITY_CD_PS | ADRCITY | Postal cities | CITY_CODE |
| ADRCITYD | CITY_CD_PS | ADRCITYD | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRCITYD | CITY_CD_PS | SY | MANDT | ADRCITY | Postal cities | CLIENT |
| ADRCITYD | CITY_CODE | ADRCITYD | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADRCITYD | CITY_CODE | ADRCITYD | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRCITYD | CITY_CODE | SY | MANDT | ADRCITY | Postal cities | CLIENT |
| ADRCITYD | COUNTRY | ADRCITYD | COUNTRY | T005 | Countries | LAND1 |
| ADRCITYD | COUNTRY | SY | MANDT | T005 | Countries | MANDT |
| ADRCITYD | COUNTY_CODE | SYST | MANDT | ADRCOUNTY | County codes | CLIENT |
| ADRCITYD | COUNTY_CODE | ADRCITYD | COUNTRY | ADRCOUNTY | County codes | COUNTRY |
| ADRCITYD | COUNTY_CODE | ADRCITYD | REGION | ADRCOUNTY | County codes | REGION |
| ADRCITYD | COUNTY_CODE | ADRCITYD | COUNTY_CODE | ADRCOUNTY | County codes | COUNTY_CODE |
| ADRCITYD | DEF_LANGU | ADRCITYD | DEF_LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADRCITYD | LANGU | ADRCITYD | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADRCITYD | REGIOGROUP | ADRCITYD | REGIOGROUP | ADRREGGRP | Regional structure grouping | REGIOGROUP |
| ADRCITYD | REGIOGROUP | SY | MANDT | ADRREGGRP | Regional structure grouping | CLIENT |
| ADRCITYD | REGION | ADRCITYD | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| ADRCITYD | REGION | ADRCITYD | REGION | T005S | Taxes: Region (Province) Key | BLAND |
| ADRCITYD | REGION | SY | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| ADRCITYD | TIME_ZONE | SY | MANDT | TTZZ | Time zones | CLIENT |
| ADRCITYD | TIME_ZONE | ADRCITYD | TIME_ZONE | TTZZ | Time zones | TZONE |
| ADRCITYD | TOWNSHIP_CODE | SYST | MANDT | ADRTOWNSHIP | Township codes | CLIENT |
| ADRCITYD | TOWNSHIP_CODE | ADRCITYD | COUNTRY | ADRTOWNSHIP | Township codes | COUNTRY |
| ADRCITYD | TOWNSHIP_CODE | ADRCITYD | REGION | ADRTOWNSHIP | Township codes | REGION |
| ADRCITYD | TOWNSHIP_CODE | ADRCITYD | COUNTY_CODE | ADRTOWNSHIP | Township codes | COUNTY_CODE |
| ADRCITYD | TOWNSHIP_CODE | ADRCITYD | TOWNSHIP_CODE | ADRTOWNSHIP | Township codes | TOWNSHIP_CODE |
| ADRCITYD | TRANSPZONE | ADRCITYD | TRANSPZONE | TZONE | Customers: Regional zones | ZONE1 |
| ADRCITYD | TRANSPZONE | ADRCITYD | COUNTRY | TZONE | Customers: Regional zones | LAND1 |
| ADRCITYD | TRANSPZONE | SY | MANDT | TZONE | Customers: Regional zones | MANDT |
| ADRCITYD | V_CITYCODE | ADRCITYD | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRCITYD | V_CITYCODE | ADRCITYD | V_CITYCODE | ADRCITY | Postal cities | CITY_CODE |
| ADRCITYD | V_CITYCODE | SYST | MANDT | ADRCITY | Postal cities | CLIENT |
