SAP ABAP View VCRMMKT2 (Marketing Planning: BW Data Source for Project Attributes)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MKT-MPL (Application Component) Marketing Planner
     CRM_MKTPL (Package) CRM Marketing Planning - User Interfaces
Basic Data
View Type D Database View 
Database View VCRMMKT2  
Short Description Marketing Planning: BW Data Source for Project Attributes    
Root table CGPL_PROJECT   Project Planning: Attribute Table for Project Headers 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CGPL_PROJECT CGPL_PROJECT
2 CRM_MKTPL_ATTR  
3 CRMC_MKTPL_CTYPE  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CGPL_PROJECT CLIENT JL EQ 0 0
2 CRM_MKTPL_ATTR CLIENT JR EQ AND 0 0
3 CGPL_PROJECT GUID JL EQ 0 0
4 CRM_MKTPL_ATTR GUID JR EQ AND 0 0
5 CRMC_MKTPL_CTYPE MANDT JL EQ 0 0
6 CRM_MKTPL_ATTR CLIENT JR EQ AND 0 0
7 CRMC_MKTPL_CTYPE CAMP_TYPE JL EQ 0 0
8 CRM_MKTPL_ATTR CAMP_TYPE JR EQ AND 0 0
9 CGPL_PROJECT OBJECT_TYPE EQ 'MPL' OR 0 0
10 CGPL_PROJECT OBJECT_TYPE EQ 'CPG' OR 0 0
11 CGPL_PROJECT OBJECT_TYPE EQ 'TPM' OR 0 0
12 CGPL_PROJECT OBJECT_TYPE EQ 'DLM' OR 0 0
13 CGPL_PROJECT OBJECT_TYPE EQ 'AGR' AND 0 0
14 CRM_MKTPL_ATTR TEMPLATE EQ ' ' AND 0 0
15 CRMC_MKTPL_CTYPE LOY_FLAG EQ ' ' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT CGPL_PROJECT CLIENT   MANDT Client
2 EXTERNAL_ID CGPL_PROJECT EXTERNAL_ID   CGPL_EXTID Project Planning: External Indentifier of an Element
3 PRIORITY CGPL_PROJECT PRIORITY   CGPL_PRIORITY Priority
4 COMPLETION CGPL_PROJECT COMPLETION   CGPL_COMPLETION Percentage of Completion
5 MILESTONE CGPL_PROJECT MILESTONE   CGPL_MILESTONE Milestone indicator
6 CREATED_ON CGPL_PROJECT CREATED_ON   CGPL_CREATED_ON Date on Which the Object was Created
7 CHANGED_ON CGPL_PROJECT CHANGED_ON   CGPL_CHANGED_ON Date on Which Object Was Last Changed
8 CAMP_TYPE CRM_MKTPL_ATTR CAMP_TYPE   CRM_MKTPL_CAMPTYPE Type
9 CHANNEL CRM_MKTPL_ATTR CHANNEL   CRM_MKTPL_CHANNEL ID of Communication Medium
                 
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  20130604 
SAP Release Created in 30A