SAP ABAP Table U_30023 (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | U_30023 | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | LANGU | LANGU | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
3 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
4 | CITY_CODE | CITY_CODE | CITY_CODE | CHAR | 12 | 0 | City Code for City/Street File | ||
5 | CITY_NAME | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
6 | MC_CITY | AD_MC_CITY | CHAR25 | CHAR | 25 | 0 | City name in upper case for search help | ||
7 | CITY_SHORT | CITY_SHORT | TEXT24 | CHAR | 24 | 0 | Long abbreviation of the city name (24 chars) | ||
8 | CITY_SH10 | CITY_SH10 | TEXT10 | CHAR | 10 | 0 | Short abbreviation of the city name (10 chars) | ||
9 | CITY_EXT | CITY_EXT | TEXT30 | CHAR | 30 | 0 | City name extension | ||
10 | COMMU_CODE | COMMU_CODE | COMMU_CODE | CHAR | 15 | 0 | Municipality key | ||
11 | FLAG_STRTS | FLAG_STRTS | RS_XFIELD | CHAR | 1 | 0 | Flag: Street directory exists | ||
12 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
13 | TIME_ZONE | AD_TZONE | TZNZONE | CHAR | 6 | 0 | Address time zone | ||
14 | TAXJURCODE | AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
15 | TRANSPZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | ||
16 | DEF_LANGU | DEF_LANGU | SPRAS | LANG | 1 | 0 | Default language for city | ||
17 | REGIOGROUP | REGIOGROUP | REGIOGROUP | CHAR | 8 | 0 | Regional structure grouping |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | U_30023 | CLIENT | T000 | MANDT | KEY | 1 | CN |
2 | U_30023 | COUNTRY | T005 | LAND1 | KEY | 1 | CN |
3 | U_30023 | LANGU | T002 | SPRAS | KEY | 1 | CN |
4 | U_30023 | REGION | T005S | BLAND | REF |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |