SAP ABAP View VVIOB09 (View of rental units dependent on property/building)
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 VVIOB09  
Short Description View of rental units dependent on property/building    
Root table VIMI01   Rental unit - Master data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIMI01 VIMI01
2 VIOB09  
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 VIOB09 MANDT JR EQ AND 0 0
3 VIMI01 BUKRS JL EQ 0 0
4 VIOB09 BUKRS JR EQ AND 0 0
5 VIMI01 SWENR JL EQ 0 0
6 VIOB09 SWENR JR EQ AND 0 0
7 VIMI01 SMENR JL EQ 0 0
8 VIOB09 SMENR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VIMI01 MANDT   MANDT Client
2 BUKRS VIMI01 BUKRS   BUKRS Company Code
3 SWENR VIMI01 SWENR   SWENR Business Entity Number
4 SMENR VIMI01 SMENR   SMENR Number of Rental Unit
5 SFLART VIOB09 SFLART   SFLARTOLD Area type (obsolete)
6 SGENR VIMI01 SGENR   SGENR Building Number
7 SGRNR VIMI01 SGRNR   SGRNR Land Number for BE
8 FQMFLART VIOB09 FQMFLART   FQMFLART Area of area type
                 
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