SAP ABAP View V_MCWETP (Matchcode Business Entity for Functional Location)
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 V_MCWETP  
Short Description Matchcode Business Entity for Functional Location    
Root table VIOB39   Relationship between Real Estate objects and SAP-PM 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIOB39 VIOB39
2 IFLOT  
3 VIOB01  
4 IFLOTX  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 IFLOT MANDT JL EQ 0 0
2 VIOB39 MANDT JR EQ AND 0 0
3 IFLOT TPLNR JL EQ 0 0
4 VIOB39 TPLNR JR EQ AND 0 0
5 VIOB01 MANDT JL EQ 0 0
6 VIOB39 MANDT JR EQ AND 0 0
7 VIOB01 BUKRS JL EQ 0 0
8 VIOB39 BUKRS JR EQ AND 0 0
9 VIOB01 SWENR JL EQ 0 0
10 VIOB39 SWENR JR EQ AND 0 0
11 IFLOT MANDT JL EQ 0 0
12 IFLOTX MANDT JR EQ AND 0 0
13 IFLOT TPLNR JL EQ 0 0
14 IFLOTX TPLNR JR EQ AND 0 0
15 VIOB39 INTRENO LK 'IW%' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VIOB39 MANDT   MANDT Client
2 SPRAS IFLOTX SPRAS   SPRAS Language Key
3 INTRENO VIOB39 INTRENO   VVINTRENO Internal Real Estate Master Data Code
4 TPLNR VIOB39 TPLNR   TPLNR Functional Location
5 PLTXT IFLOTX PLTXT   PLTXT Description of functional location
6 BUKRS VIOB39 BUKRS   BUKRS Company Code
7 SWENR VIOB39 SWENR   SWENR Business Entity Number
8 XWETEXT VIOB01 XWETEXT   XWETEXT Business entity identification
9 OBJNR VIOB01 J_OBJNR   J_OBJNR Object number
                 
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