SAP ABAP View VMCANBP (View for Matchcode Selection LO Offers via Partner)
Hierarchy
SAP_FIN (Software Component) SAP_FIN
   RE-RT (Application Component) Rental
     RERC (Package) RE: Lease-Out
Basic Data
View Type D Database View 
Database View VMCANBP  
Short Description View for Matchcode Selection LO Offers via Partner    
Root table VIMI33   Offers for a rental unit (-> VIMIMV) 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIMI33 VIMI33
2 VZGPO  
3 BP000  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VIMI33 MANDT JL EQ 0 0
2 VZGPO MANDT JR EQ AND 0 0
3 VIMI33 INTRENO JL EQ 0 0
4 VZGPO SOBJEKT JR EQ AND 0 0
5 VIMI33 MANDT JL EQ 0 0
6 BP000 MANDT JR EQ AND 0 0
7 BP000 MANDT JL EQ 0 0
8 VZGPO MANDT JR EQ AND 0 0
9 BP000 PARTNR JL EQ 0 0
10 VZGPO PARTNR JR EQ AND 0 0
11 VZGPO SNUMOBJ EQ 'VI' AND 0 0
12 VZGPO APPL EQ '0034' 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 PARTNR BP000 PARTNR   BP_PARTNR_OLD Business Partner Number
7 NAME1 BP000 NAME1   BP_NAME1 Name 1 (surname for persons, otherwise company name)
8 NAME2 BP000 NAME2   BP_NAME2 Name 2 (Continuation of NAME 1)
9 MC_NAME1 BP000 MC_NAME1   BP_MC_NAM1 Field NAME1 in Upper Case
10 MC_NAME2 BP000 MC_NAME2   BP_MC_NAM2 Field NAME2 in Upper Case
11 BIRTH_DATE BP000 BIRTH_DATE   BP_BIRTHD Date of Birth of Business Partner
12 INTRENO VIMI33 INTRENO   VVINTRENO Internal Real Estate Master Data Code
13 DMIBEG VIMI33 DMIBEG   DMIBE Rental start date
14 SMVART VIMI33 SMVART   SMVART External Real Estate contract 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