SAP ABAP Table CRMV_ISU_STREET (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | CRMV_ISU_STREET | 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 | MC_STREET | AD_MC_STRT | CHAR25 | CHAR | 25 | 0 | Street name in upper case for search help | ||
7 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
8 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
9 | CITY_NAME | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
10 | MC_CITY | AD_MC_CITY | CHAR25 | CHAR | 25 | 0 | City name in upper case for search help | ||
11 | CITY_EXT | CITY_EXT | TEXT30 | CHAR | 30 | 0 | City name extension | ||
12 | HOUSENUM_H | HOUSENUM_H | NUMC10 | NUMC | 10 | 0 | House number - upper limit of an interval | ||
13 | HSN_SUPP_H | HSN_SUPP_H | TEXT4 | CHAR | 4 | 0 | House number supplement - upper limit of an interval | ||
14 | HOUSENUM_L | HOUSENUM_L | NUMC10 | NUMC | 10 | 0 | Haouse number - lower limit of an interval | ||
15 | HSN_SUPP_L | HSN_SUPP_L | TEXT4 | CHAR | 4 | 0 | House number supplement - lower limit of an interval | ||
16 | POST_CODE | POST_CODE | POST_CODE | CHAR | 10 | 0 | Postal Code | ADRPSTCODE | |
17 | STRTYPEAB | STRTYPEAB | STRTYPEAB | CHAR | 2 | 0 | Street type abbreviation | ADRSTRTYPE | |
18 | STRTYPE | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMV_ISU_STREET | CITY_CODE | ADRCITY | CITY_CODE | REF | 1 | CN |
2 | CRMV_ISU_STREET | CLIENT | T000 | MANDT | KEY | 1 | CN |
3 | CRMV_ISU_STREET | COUNTRY | T005 | LAND1 | KEY | 1 | CN |
4 | CRMV_ISU_STREET | LANGU | T002 | SPRAS | KEY | 1 | CN |
5 | CRMV_ISU_STREET | POST_CODE | ADRPSTCODE | POST_CODE | REF | C | CN |
6 | CRMV_ISU_STREET | REGION | T005S | BLAND | REF | ||
7 | CRMV_ISU_STREET | STRTYPEAB | ADRSTRTYPE | STRTYPEAB | REF | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |