SAP ABAP Table ADRCITY (Postal cities)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
⤷ SZRS (Package) SAP Technology - Business Services: Regional Structure
⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
⤷ SZRS (Package) SAP Technology - Business Services: Regional Structure
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | ADRCITY | Table Relationship Diagram |
Short Description | Postal cities |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
3 | CITY_CODE | CITY_CODE | CITY_CODE | CHAR | 12 | 0 | City Code for City/Street File | ||
4 | .INCLUDE | 0 | 0 | Data part of the table ADRCITY | |||||
5 | COMMU_CODE | COMMU_CODE | COMMU_CODE | CHAR | 15 | 0 | Municipality key | ||
6 | FLAG_STRTS | FLAG_STRTS | RS_XFIELD | CHAR | 1 | 0 | Flag: Street directory exists | ||
7 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
8 | TIME_ZONE | AD_TZONE | TZNZONE | CHAR | 6 | 0 | Address time zone | * | |
9 | TAXJURCODE | AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
10 | TRANSPZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | * | |
11 | DEF_LANGU | DEF_LANGU | SPRAS | LANG | 1 | 0 | Default language for city | * | |
12 | REGIOGROUP | REGIOGROUP | REGIOGROUP | CHAR | 8 | 0 | Regional structure grouping | * | |
13 | CITY_CD_PS | CITY_CD_PS | CITY_CODE | CHAR | 12 | 0 | Coding of different postal city for City/Street file | * | |
14 | .INCLUDE | 0 | 0 | IS-U Application Data: City | |||||
15 | .INCLUDE | 0 | 0 | ||||||
16 | .INCLUDE | 0 | 0 | ||||||
17 | COUNTY_CODE | AD_CNTYNUM | CNTY_CODE | CHAR | 8 | 0 | County code for county | * | |
18 | TOWNSHIP_CODE | AD_TWSHPNUM | TWSHP_CODE | CHAR | 8 | 0 | Township code for Township | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ADRCITY | CLIENT | T000 | MANDT | KEY | 1 | CN |
2 | ADRCITY | COUNTRY | T005 | LAND1 | KEY | 1 | CN |
3 | ADRCITY | REGION | T005S | BLAND | REF |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |