SAP ABAP Table CRMS_MKTPL_IB_QUERY_RS_CPG_CCM (Query Result Attributes of Node Campaign (IBOM MKTPL))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MKT-MPL (Application Component) Marketing Planner
     CRM_MKTPL_IB_CPG (Package) CRM Marketing: iBom for Campaign
Basic Data
Table Category INTTAB    Structure 
Structure CRMS_MKTPL_IB_QUERY_RS_CPG_CCM   Table Relationship Diagram
Short Description Query Result Attributes of Node Campaign (IBOM MKTPL)    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   Include for Basic Data  
2 GUID CRM_MKTPL_IB_CPG_GUID   RAW 16   0   Campaign  
3 EXTERNAL_ID CRM_MKTPL_CAMPAIGNID CGPL_EXTID CHAR 24   0   Campaign  
4 CAMP_TYPE CRM_MKTPL_CAMPTYPE CRM_MKTPL_CAMPTYPE CHAR 4   0   Type *
5 OBJECTIVE CRM_MKTPL_OBJECTIVE CRM_MKTPL_OBJECTIVE CHAR 4   0   Objective  
6 TACTICS CRM_MKTPL_TACTICS CRM_MKTPL_TACTICS CHAR 4   0   Tactic  
7 PRIORITY CRM_MKTPL_IB_PRIORITY NUMC3 NUMC 3   0   Priority String Element (iBom MKTPL)  
8 SHORTCUT CRMT_MKTPL_CAMPAIGN_SHORTCUT CHAR4 CHAR 4   0   Campaign Code  
9 RESPONSIBLE BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
10 TERR_PATH_GUID CRMT_TERRITORY_PATH_GUID SYSUUID RAW 16   0   Territory Path GUID  
11 TERR_PATH_ID CRMT_TERRITORY_PATH_ID CRM_TERRITORY_PATH_ID CHAR 30   0   Territory Hierarchy ID  
12 ACTION_PROFILE CRM_MKTPL_ACTION_PROFILE PPFDCNTXT CHAR 30   0   ID of Action Profile *
13 CURRENCY CRM_MKTPL_CUKY WAERS CUKY 5   0   MKTPL: Currency Object *
14 CALENDAR_ID WFCID WFCID CHAR 2   0   Factory Calendar *
15 COMPLETION CGPL_COMPLETION CGPL_COMPLETION NUMC 3   0   Percentage of Completion  
16 STSMA J_STSMA J_STSMA CHAR 8   0   Status Profile *
17 SURVEYID CRM_SVY_DB_SID CHAR32 CHAR 32   0   CRM Surveys: Survey ID  
18 SURVEYVERSION CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version  
19 PARENT_GUID CRM_MKTPL_IB_MKTPROJECT_GUID   RAW 16   0   Marketing Project  
20 BWIDENTIFIER CGPL_BWIDENTIFIER CGPL_BWIDENTIFIER NUMC 8   0   Project Planning - BW Identification  
21 NO_R3_INT CRM_MKTPL_NO_R3_INT CHAR1 CHAR 1   0   Marketing Planning: Object Not Integrated into ERP PS  
22 EXCL_IND CRM_MKTPL_IB_EXCL_IND CRM_BOOLEAN CHAR 1   0   Exclusive (boolean)  
23 INACTIVE CRMT_MKTPL_INACTIVE CHAR1 CHAR 1   0   Inactive Marketing Project  
24 ADI_FLAG CRM_MKTPL_ADI CRM_MKTPL_ADI CHAR 1   0   Abnormal Demand Indicator  
25 ENROLLMENT_REQ CRM_MKTPL_ENR_ENROLLMENT_REQ XFELD CHAR 1   0   Indicator, that enrollment is required  
26 REF_TYPE CRM_MKTPL_REF_TYPE CRM_MKTPL_REF_TYPE_DOM CHAR 4   0   Usage Type  
27 TEMPLATE CRM_MKTPL_TEMPLATE CRM_BOOLEAN CHAR 1   0   Template Indicator  
28 .INCLUDE       0   0   Include for Dates and Time  
29 PLANSTART CGPL_PLANSTART BCOS_TSTMP DEC 15   0   Planned start date  
30 PLANFINISH CGPL_PLANFINISH BCOS_TSTMP DEC 15   0   Planned Finish Date  
31 ACTUALSTART CGPL_ACTUALSTART BCOS_TSTMP DEC 15   0   Actual Start Date  
32 ACTUALFINISH CGPL_ACTUALFINISH BCOS_TSTMP DEC 15   0   Actual Finish Date  
33 .INCLUDE       0   0   Include for Basic Data (external)  
34 CAMP_TYPETX CRM_MKTPL_CAMPTYPETX TEXT40 CHAR 40   0   Description of Type  
35 OBJECTIVETX CRM_MKTPL_OBJECTIVETX TEXT40 CHAR 40   0   Objective(s) Description  
36 TACTICSTX CRM_MKTPL_TACTICSTX TEXT40 CHAR 40   0   Tactic Description  
37 CAMP_PRIOTX CRM_MKTPL_CAMPPRIOTX TEXT40 CHAR 40   0   Description of Priority  
38 RESPONSIBLE_NAME CRM_MKTPL_RESPONSIBLE BU_PARTNER CHAR 10   0   Employee Responsible for Marketing Project *
39 RESPONSIBLE_TEXT BU_DESCRIP BU_TEXT50 CHAR 50   0   Short name of business partner  
40 TERR_DESCRIPTION CRMT_TERRITORY_DESCRIPTION TEXT40 CHAR 40   0   Territory Description  
41 TERR_ID CRMT_TERRITORY_ID CRM_TERRITORY_ID CHAR 30   0   Territory ID  
42 CURRENCY_TEXT LTEXT TEXT40 CHAR 40   0   Long Text  
43 FACTORY_CAL_TEXT FKTEXT TEXT60 CHAR 60   0   Object Text  
44 ACTION_PROFILE_TEXT PPFDCNTXTT TEXT60 CHAR 60   0   PPF: Description of Action Profile  
45 PSP_CREATION CRMT_MKTPL_IB_R3_INT CRM_BOOLEAN CHAR 1   0   Transfer to ERP (boolean)  
46 EXCL_IND_DESC CRM_MKTPL_EXCL_IND_DESC CRM_BOOLEAN CHAR 1   0   Marketing Planner: Exclusive Indicator for Mult. Promotions  
47 ACTIVE CRMT_MKTPL_ACTIVE XFELD CHAR 1   0   Active Marketing Project  
48 STSMA_TEXT TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
49 SURVEY_DESC_SHORT CRM_MKTPL_SURVEY_DESC_SHORT TEXT45 CHAR 45   0   CRM Questionnaires: Short Description  
50 REF_TYPE_TEXT CRM_MKTPL_REF_TYPE_TEXT TEXT40 CHAR 40   0   Usage Type Description  
51 HV_ACTIVE CRM_MKTPL_HV_ACTIVE CRM_MKTPL_HV_ACTIVE CHAR 1   0   High-Volume Execution  
52 .INCLUDE       0   0   Include for Dates and Time (external)  
53 PLANSTARTDATE CRM_MKTPL_PLANSTARTDATE DATUM DATS 8   0   Planned Start Date  
54 PLANSTARTTIME CRM_MKTPL_PLANSTARTTIME TIME TIMS 6   0   Planned Start (Time)  
55 PLANFINISHDATE CRM_MKTPL_PLANFINISHDATE DATUM DATS 8   0   Planned Finish Date  
56 PLANFINISHTIME CRM_MKTPL_PLANFINISHTIME TIME TIMS 6   0   Planned Finish (Time)  
57 ACTUALSTARTDATE CRM_MKTPL_ACTUALSTARTDATE DATUM DATS 8   0   Actual Start Date  
58 ACTUALSTARTTIME CRM_MKTPL_ACTUALSTARTTIME TIME TIMS 6   0   Actual Start (Time)  
59 ACTUALFINISHDATE CRM_MKTPL_ACTUALFINISHDATE DATUM DATS 8   0   Actual Finish (Date)  
60 ACTUALFINISHTIME CRM_MKTPL_ACTUALFINISHTIME TIME TIMS 6   0   Actual Finish (time)  
61 .INCLUDE       0   0   Include for Change History  
62 CREATED_BY CGPL_CREATED_BY USNAM CHAR 12   0   Name of Person Who Created Object  
63 CREATED_BY_DESC CRM_MKTPL_IB_CREATED_BY_DESC CHAR65 CHAR 65   0   Description of Person Who Created Object  
64 CREATED_ON CGPL_CREATED_ON DATUM DATS 8   0   Date on Which the Object was Created  
65 CHANGED_BY CGPL_CHANGED_BY USNAM CHAR 12   0   Name of Person Who Changed Object  
66 CHANGED_BY_DESC CRM_MKTPL_IB_CHANGED_BY_DESC CHAR65 CHAR 65   0   Description of Person Who Changed Object  
67 CHANGED_ON CGPL_CHANGED_ON DATUM DATS 8   0   Date on Which Object Was Last Changed  
68 .INCLUDE       0   0    
69 .INCLUDE       0   0    
70 .INCLUDE       0   0    
71 .INCLUDE       0   0   Include for Administrative Data  
72 COLLABORATIVE_CAMPAIGN_GUID CRM_MKTGS_GUID   RAW 16   0   MKTGS OL: Generic Marketing Guid  
73 COLLABORATIVE_CAMPAIGN_ID CRM_MKTGS_EXTERNAL_ID CGPL_EXTID CHAR 24   0   MKTGS OL: Generic Marketing External ID  
74 COLLABORATIVE_CAMPAIGN_TEXT CRM_MKTGS_SHORTTEXT TEXT40 CHAR 40   0   MKTGS: Short text  
75 CHANNEL_PARTNER_GUID BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
76 CHANNEL_PARTNER_ID BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
77 CHANNEL_PARTNER_TEXT BU_DESCRIP BU_TEXT50 CHAR 50   0   Short name of business partner  
78 RESP_AT_CHANNEL_PARTNER_GUID BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
79 RESP_AT_CHANNEL_PARTNER_ID BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
80 RESP_AT_CHANNEL_PARTNER_TEXT BU_DESCRIP BU_TEXT50 CHAR 50   0   Short name of business partner  
81 TEXT1 CRM_MKTPL_IB_CPG_TEXT TEXT40 CHAR 40   0   Campaign Description  
82 OBJECT_TYPE CGPL_OBJECT_TYPE CHAR3 CHAR 3   0   Object Type in Project Planning  
83 STATUS_TEXT CRM_MKTPL_IB_STATUS_TEXT TEXT40 CHAR 40   0   Status of Scope Item (Concatenated)  
84 PARENT_EXT_ID CGPL_EXTID CGPL_EXTID CHAR 24   0   Project Planning: External Indentifier of an Element  
85 USE_FIX_TZ_UTC CRM_MKTPL_USE_FIX_TIMEZONE CRM_BOOLEAN CHAR 1   0   MKTPL: Use Fix Timezone UTC for Timestamp - Date/Time Conv.  
86 .INCLUDE       0   0   Extension Include - Campaign Query Result Structure  
87 MKTPL_RESULT_CPG DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
History
Last changed by/on SAP  20130604 
SAP Release Created in 701