SAP ABAP View CRMV_ADDR_STREET (Search for Streets in Regional Structure)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MD-BP-DAT (Application Component) CRM Specific Business Partner Data
     CRM_ADDRESS_IL (Package) genIL: Address
Basic Data
View Type D Database View 
Database View CRMV_ADDR_STREET  
Short Description Search for Streets in Regional Structure    
Root table ADRSTREET   Streets 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 ADRSTREET ADRSTREET
2 ADRCITY  
3 ADRSTREETT  
4 ADRCITYT  
5 ADRSTRPCD  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 ADRCITY CLIENT JL EQ 0 0
2 ADRSTREET CLIENT JR EQ AND 0 0
3 ADRCITY COUNTRY JL EQ 0 0
4 ADRSTREET COUNTRY JR EQ AND 0 0
5 ADRCITY CITY_CODE JL EQ 0 0
6 ADRSTREET CITY_CODE JR EQ AND 0 0
7 ADRSTREET CLIENT JL EQ 0 0
8 ADRSTREETT CLIENT JR EQ AND 0 0
9 ADRSTREET COUNTRY JL EQ 0 0
10 ADRSTREETT COUNTRY JR EQ AND 0 0
11 ADRSTREET STRT_CODE JL EQ 0 0
12 ADRSTREETT STRT_CODE JR EQ AND 0 0
13 ADRCITY CLIENT JL EQ 0 0
14 ADRCITYT CLIENT JR EQ AND 0 0
15 ADRCITY COUNTRY JL EQ 0 0
16 ADRCITYT COUNTRY JR EQ AND 0 0
17 ADRCITY CITY_CODE JL EQ 0 0
18 ADRCITYT CITY_CODE JR EQ AND 0 0
19 ADRSTREET CLIENT JL EQ 0 0
20 ADRSTRPCD CLIENT JR EQ AND 0 0
21 ADRSTREET COUNTRY JL EQ 0 0
22 ADRSTRPCD COUNTRY JR EQ AND 0 0
23 ADRSTREET STRT_CODE JL EQ 0 0
24 ADRSTRPCD STRT_CODE JR EQ AND 0 0
25 ADRSTREETT LANGU JL EQ 0 0
26 ADRCITYT LANGU JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT ADRSTREET CLIENT   MANDT Client
2 LANGU ADRCITYT LANGU   LANGU Language Key
3 COUNTRY ADRSTREET COUNTRY   LAND1 Country Key
4 STRT_CODE ADRSTREET STRT_CODE   STRT_CODE Street Number for City/Street File
5 CITY_CODE ADRSTREET CITY_CODE   CITY_CODE City Code for City/Street File
6 STRTYPEAB ADRSTREET STRTYPEAB   STRTYPEAB Street type abbreviation
7 MC_STREET ADRSTREETT MC_STREET   AD_MC_STRT Street name in upper case for search help
8 STREET ADRSTREETT STREET   AD_STREET Street
9 REGION ADRCITY REGION   REGIO Region (State, Province, County)
10 CITY_NAME ADRCITYT CITY_NAME   AD_CITY1 City
11 MC_CITY ADRCITYT MC_CITY   AD_MC_CITY City name in upper case for search help
12 CITY_EXT ADRCITYT CITY_EXT   CITY_EXT City name extension
13 HOUSENUM_H ADRSTRPCD HOUSENUM_H   HOUSENUM_H House number - upper limit of an interval
14 HSN_SUPP_H ADRSTRPCD HSN_SUPP_H   HSN_SUPP_H House number supplement - upper limit of an interval
15 HOUSENUM_L ADRSTRPCD HOUSENUM_L   HOUSENUM_L Haouse number - lower limit of an interval
16 HSN_SUPP_L ADRSTRPCD HSN_SUPP_L   HSN_SUPP_L House number supplement - lower limit of an interval
17 POST_CODE ADRSTRPCD POST_CODE   POST_CODE Postal Code
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20131122 
SAP Release Created in 510