SAP ABAP View M_MVANB (Generated View for Matchcode ID MVAN B)
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_MVANB  
Short Description Generated View for Matchcode ID MVAN B    
Root table VIMI33   Offers for a rental unit (-> VIMIMV) 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIMI33 VIMI33
2 VIMI01  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VIMI01 MANDT JL EQ 0 0
2 VIMI33 MANDT JR EQ AND 0 0
3 VIMI01 BUKRS JL EQ 0 0
4 VIMI33 BUKRS JR EQ AND 0 0
5 VIMI01 SWENR JL EQ 0 0
6 VIMI33 SWENR JR EQ AND 0 0
7 VIMI01 SMENR JL EQ 0 0
8 VIMI33 SMENR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VIMI33 MANDT   MANDT Client
2 BUKRS VIMI33 BUKRS   BUKRS Company Code
3 SMVANG VIMI33 SMVANG   VVSMVANG Lease-out - Offer
4 SWENR VIMI33 SWENR   SWENR Business Entity Number
5 SMENR VIMI33 SMENR   SMENR Number of Rental Unit
6 DMIBEG VIMI33 DMIBEG   DMIBE Rental start date
7 DMIEND VIMI33 DMIEND   DMIEN Rental end date
8 SMVART VIMI33 SMVART   SMVART External Real Estate contract type
9 SMVANART VIMI33 SMVANART   SMVAR Lease-Out Adjustment Type
10 SGRNR VIMI01 SGRNR   SGRNR Land Number for BE
11 SGENR VIMI01 SGENR   SGENR Building Number
12 SNUNR VIMI01 SNUNR   SNUNR Rental unit external usage type
13 XMETXT VIMI01 XMETXT   VVXMETXT2 Text for rental unit
                 
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