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