SAP ABAP Table CRMS_MKTPL_IB_QUERY_RESULT_MPL (Attributes of Node Marketing Plan (IBOM MKTPL))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_IB_MPL (Package) CRM Marketing: iBom for Marketing Plan

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_QUERY_RESULT_MPL	Table Relationship Diagram
Short Description	Attributes of Node Marketing Plan (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 MPL (IBOM MKTPL)
2	GUID	☐	CRM_MKTPL_IB_MPL_GUID		RAW	16	0	Marketing Plan
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	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	*
6	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
7	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
8	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
9	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
10	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
11	PARENT_GUID	☐	CRM_MKTPL_IB_MKTPROJECT_GUID		RAW	16	0	Marketing Project
12	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
13	NO_R3_INT	☐	CRM_MKTPL_NO_R3_INT	CHAR1	CHAR	1	0	Marketing Planning: Object Not Integrated into ERP PS
14	INACTIVE	☐	CRMT_MKTPL_INACTIVE	CHAR1	CHAR	1	0	Inactive Marketing Project
15	.INCLUDE	☐				0	0	Include for project level specific attributes of MPL (IBOM)
16	AUTH_GROUP	☐	CRM_MKTPL_AUTH_GROUP	CRM_MKTPL_AUTH_GROUP	CHAR	4	0	Authorization Group
17	.INCLUDE	☐				0	0	Include for Dates and Time of MPL (IBOM MKTPL)
18	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
19	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
20	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
21	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
22	.INCLUDE	☐				0	0	Include for OrgData of MPL (IBOM MKTPL)
23	MKT_ORG	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
24	.INCLUDE	☐				0	0	Include for Basic Data MPL (external) - (IBOM MKTPL)
25	CAMP_TYPETX	☐	CRM_MKTPL_CAMPTYPETX	TEXT40	CHAR	40	0	Description of Type
26	CAMP_PRIOTX	☐	CRM_MKTPL_CAMPPRIOTX	TEXT40	CHAR	40	0	Description of Priority
27	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
28	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
29	CURRENCY_TEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
30	FACTORY_CAL_TEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text
31	PSP_CREATION	☐	CRMT_MKTPL_IB_R3_INT	CRM_BOOLEAN	CHAR	1	0	Transfer to ERP (boolean)
32	ACTIVE	☐	CRMT_MKTPL_ACTIVE	XFELD	CHAR	1	0	Active Marketing Project
33	STSMA_TEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
34	.INCLUDE	☐				0	0	Include for Dates and Time MPL (external) - (IBOM MKTPL)
35	PLANSTARTDATE	☐	CRM_MKTPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
36	PLANSTARTTIME	☐	CRM_MKTPL_PLANSTARTTIME	TIME	TIMS	6	0	Planned Start (Time)
37	PLANFINISHDATE	☐	CRM_MKTPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
38	PLANFINISHTIME	☐	CRM_MKTPL_PLANFINISHTIME	TIME	TIMS	6	0	Planned Finish (Time)
39	ACTUALSTARTDATE	☐	CRM_MKTPL_ACTUALSTARTDATE	DATUM	DATS	8	0	Actual Start Date
40	ACTUALSTARTTIME	☐	CRM_MKTPL_ACTUALSTARTTIME	TIME	TIMS	6	0	Actual Start (Time)
41	ACTUALFINISHDATE	☐	CRM_MKTPL_ACTUALFINISHDATE	DATUM	DATS	8	0	Actual Finish (Date)
42	ACTUALFINISHTIME	☐	CRM_MKTPL_ACTUALFINISHTIME	TIME	TIMS	6	0	Actual Finish (time)
43	.INCLUDE	☐				0	0	Include for OrgData of MPL (external) - (IBOM MKTPL)
44	MKT_ORG_DESC	☐	CRM_MKTPL_MORG_DESC	CRM_MKTPL_MORG_DESC	CHAR	40	0	Marketing Organization Description
45	.INCLUDE	☐				0	0	Include for Change History MPL (IBOM MKTPL)
46	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
47	CREATED_BY_DESC	☐	CRM_MKTPL_IB_CREATED_BY_DESC	CHAR65	CHAR	65	0	Description of Person Who Created Object
48	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
49	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
50	CHANGED_BY_DESC	☐	CRM_MKTPL_IB_CHANGED_BY_DESC	CHAR65	CHAR	65	0	Description of Person Who Changed Object
51	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
52	.INCLUDE	☐				0	0
53	.INCLUDE	☐				0	0	Extension Include - Marketing Plan Query Result Structure
54	MKTPL_RESULT_MPL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
55	TEXT1	☐	CRM_MKTPL_IB_MPL_TEXT	TEXT40	CHAR	40	0	Marketing Plan Description
56	TIMEZONE_CREATED	☐	CRM_MKTPL_TIMEZONE_CREATED	TZNZONE	CHAR	6	0	Time Zone of User Who Created the Marketing Project	*
57	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
58	STATUS_TEXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
59	PARENT_EXT_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
60	.INCLUDE	☐				0	0	Include for Project Specific Attribute (external)
61	PLANGROUP_TEXT	☐	CGPL_SEM_PLGRPT	TEXT40	CHAR	40	0	Description of Planning Profile Group
62	AUTH_GROUP_TEXT	☐	CRM_MKTPL_AUTH_GROUPTX	TEXT40	CHAR	40	0	Description of Authorization Group
63	USE_FIX_TZ_UTC	☐	CRM_MKTPL_USE_FIX_TIMEZONE	CRM_BOOLEAN	CHAR	1	0	MKTPL: Use Fix Timezone UTC for Timestamp - Date/Time Conv.

History

Last changed by/on	SAP	20130604
SAP Release Created in	510