SAP ABAP View M_MBWAA (Generierter View für Matchcode ID MBWA -A)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate
Basic Data
View Type D Database View 
Database View M_MBWAA  
Short Description Generierter View für Matchcode ID MBWA -A    
Root table VIMI11   Applications - Real Estate Management 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIMI11 VIMI11
2 SANS1  
3 BP030  
4 BP000  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SANS1 MANDT JL EQ 0 7 SBWNR
2 BP030 MANDT JR EQ AND 0 7 SBWNR
3 SANS1 ADRNR JL EQ 0 7 SBWNR
4 BP030 ADRNR JR EQ AND 0 7 SBWNR
5 BP000 MANDT JL EQ 0 7 SBWNR
6 BP030 MANDT JR EQ AND 0 7 SBWNR
7 BP000 PARTNR JL EQ 0 7 SBWNR
8 BP030 PARTNR JR EQ AND 0 7 SBWNR
9 BP000 MANDT JL EQ 0 7 SBWNR
10 VIMI11 MANDT JR EQ AND 0 7 SBWNR
11 BP000 PARTNR JL EQ 0 7 SBWNR
12 VIMI11 VADRNR JR EQ AND 0 7 SBWNR
13 VIMI11 SBWNR NE '0000000' 0 7 SBWNR
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VIMI11 MANDT   MANDT Client
2 SBWNR VIMI11 SBWNR   SBWNR Application number
3 SBWTYP VIMI11 SBWTYP   SBWTYP Applicant category
4 NAME1 BP000 NAME1   BP_NAME1 Name 1 (surname for persons, otherwise company name)
5 NAME2 BP000 NAME2   BP_NAME2 Name 2 (Continuation of NAME 1)
6 MC_NAME1 BP000 MC_NAME1   BP_MC_NAM1 Field NAME1 in Upper Case
7 MC_NAME2 BP000 MC_NAME2   BP_MC_NAM2 Field NAME2 in Upper Case
8 BIRTH_DATE BP000 BIRTH_DATE   BP_BIRTHD Date of Birth of Business Partner
9 SBONI VIMI11 SBONI   SBONI Credit standing application
                 
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  20130529 
SAP Release Created in