SAP ABAP Table V_ADRSTRT (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | V_ADRSTRT | 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 | STRT_CODE | STRT_CODE | STRT_CODE | CHAR | 12 | 0 | Street Number for City/Street File | ||
5 | CITY_CODE | CITY_CODE | CITY_CODE | CHAR | 12 | 0 | City Code for City/Street File | ADRCITY | |
6 | CITYP_CODE | CITYP_CODE | CITYP_CODE | CHAR | 8 | 0 | District code for city and street file | ||
7 | STRTYPEAB | STRTYPEAB | STRTYPEAB | CHAR | 2 | 0 | Street type abbreviation | ADRSTRTYPE | |
8 | COMMU_CODE | COMMU_CODE | COMMU_CODE | CHAR | 15 | 0 | Municipality key | ||
9 | REGIOGROUP | REGIOGROUP | REGIOGROUP | CHAR | 8 | 0 | Regional structure grouping | ADRREGGRP | |
10 | TAXJURCODE | AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
11 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
12 | MC_STREET | AD_MC_STRT | CHAR25 | CHAR | 25 | 0 | Street name in upper case for search help | ||
13 | STREET_SHR | STREET_SHR | TEXT22 | CHAR | 22 | 0 | Long abbreviation of street name (22 chars) | ||
14 | STREET_S15 | STREET_S15 | TEXT15 | CHAR | 15 | 0 | Short abbreviation of street name (15 chars) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | V_ADRSTRT | CITY_CODE | ADRCITY | CITY_CODE | REF | 1 | CN |
2 | V_ADRSTRT | CLIENT | T000 | MANDT | KEY | 1 | CN |
3 | V_ADRSTRT | COUNTRY | T005 | LAND1 | KEY | 1 | CN |
4 | V_ADRSTRT | LANGU | T002 | SPRAS | KEY | 1 | CN |
5 | V_ADRSTRT | REGIOGROUP | ADRREGGRP | REGIOGROUP | REF | 1 | CN |
6 | V_ADRSTRT | STRTYPEAB | ADRSTRTYPE | STRTYPEAB | REF | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |