SAP ABAP View M_MRAEB (Generated view for matchcode ID MRAE -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_MRAEB  
Short Description Generated view for matchcode ID MRAE -B    
Root table VIMIMV   Lease-Out 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIMIMV VIMIMV
2 ONR00  
3 JEST  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 ONR00 MANDT JL EQ 0 1 INACT
2 VIMIMV MANDT JR EQ AND 0 1 INACT
3 ONR00 OBJNR JL EQ 0 1 INACT
4 VIMIMV SNKS JR EQ AND 0 1 INACT
5 ONR00 MANDT JL EQ 0 1 INACT
6 JEST MANDT JR EQ AND 0 1 INACT
7 ONR00 OBJNR JL EQ 0 1 INACT
8 JEST OBJNR JR EQ AND 0 1 INACT
9 VIMIMV E_SMIVE NE ' ' AND 0 13 E_SMIVE
10 JEST STAT EQ 'I0119' AND 0 5 STAT
11 JEST INACT EQ ' ' 0 1 INACT
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VIMIMV MANDT   MANDT Client
2 BUKRS VIMIMV BUKRS   BUKRS Company Code
3 E_SMIVE VIMIMV E_SMIVE   VVESMIVE Contract No. of Collective Lease-Outs
4 SMIVE VIMIMV SMIVE   SMIVE Lease-Out Number
5 SWENR VIMIMV SWENR   SWENR Business Entity Number
6 SMENR VIMIMV SMENR   SMENR Number of Rental Unit
7 DMIBEG VIMIMV DMIBEG   DMIBE Rental start date
8 DMIEND VIMIMV DMIEND   DMIEN Rental end date
9 SMVART VIMIMV SMVART   SMVART External Real Estate contract type
10 SMVANART VIMIMV SMVANART   SMVAR Lease-Out Adjustment Type
11 DKUEZU VIMIMV DKUEZU   DKUZU Contract Notice Per
                 
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  20110901 
SAP Release Created in