SAP ABAP View M_BETRB (Generated view for matchcode ID BETR-B)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       WFIL (Package) IS-R: Store master
Basic Data
View Type D Database View 
Database View M_BETRB  
Short Description Generated view for matchcode ID BETR-B    
Root table T001W   Plants/Branches 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 T001W T001W
2 ADRC  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 T001W MANDT JL EQ 0 0
2 ADRC CLIENT JR EQ AND 0 0
3 T001W ADRNR JL EQ 0 0
4 ADRC ADDRNUMBER JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT T001W MANDT   MANDT Client
2 VKORG T001W VKORG   VKOIV Sales organization for intercompany billing
3 VTWEG T001W VTWEG   VTWIV Distribution channel for intercompany billing
4 SPART T001W SPART   SPAIV Division for intercompany billing
5 SORT1 ADRC SORT1   AD_SORT1 Search Term 1
6 SORT2 ADRC SORT2   AD_SORT2 Search Term 2
7 POST_CODE1 ADRC POST_CODE1   AD_PSTCD1 City postal code
8 NAME2 ADRC NAME2   AD_NAME2 Name 2
9 NAME1 ADRC NAME1   AD_NAME1 Name 1
10 MC_NAME1 ADRC MC_NAME1   AD_MC_NAME Name (field NAME1) in upper case for matchcode
11 WERKS T001W WERKS   WERKS_D Plant
                 
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  20140121 
SAP Release Created in