SAP ABAP Table CRMT_MKTPL_CAMPAIGN_DATA (Marketing Planning Attributes for External Communication)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL (Package) CRM Marketing Planning - User Interfaces

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MKTPL_CAMPAIGN_DATA	Table Relationship Diagram
Short Description	Marketing Planning Attributes for External Communication

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
3	EXTERNAL_ID	☐	CRMT_MKTPL_EXTID	CGPL_EXTID	CHAR	24	0	Marketing Project
4	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
5	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
6	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
7	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
8	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
9	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
10	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
11	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
12	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
13	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
14	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
15	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
16	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
17	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
18	CREATED_IN_BW	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
19	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
21	UPDATED_IN_BW	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
22	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
23	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
24	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
25	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
26	TOTAL_FLOAT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
27	DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
28	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
29	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
30	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
31	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
32	APPLICATION	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
33	FORECAST_START	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
34	FORECAST_FINISH	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
35	CAMP_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	CRMC_MKTPL_CTYPE
36	CHANNEL	☐	CRM_MKTPL_CHANNEL	CRM_MKTPL_CHANNEL	CHAR	4	0	ID of Communication Medium	CRMC_MKTPL_CHAN
37	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
38	SMARTFORM	☐	CRMT_MKTPL_EMAIL_FORM	TDSFNAME	CHAR	30	0	Form for E-Mail	*
39	MAIL_FORM	☐	CRMT_MKTPL_MAIL_FORM	TDSFNAME	CHAR	30	0	Form for Sending a Letter	*
40	FAX_FORM	☐	CRMT_MKTPL_FAX_FORM	TDSFNAME	CHAR	30	0	Form for Fax	*
41	SMS_FORM	☐	CRMT_MKTPL_SMS_FORM	TDSFNAME	CHAR	30	0	Form for SMS/Pager Services	*
42	ADRESS_ID	☐	CRMT_IM_E_ID	CHAR12	CHAR	12	0	Identification for an E-mail Address	CRMC_IM_ADRESS
43	SCRIPT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
44	TACTICS	☐	CRM_MKTPL_TACTICS	CRM_MKTPL_TACTICS	CHAR	4	0	Tactic	CRMC_MKTPL_TACTS
45	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective	CRMC_MKTPL_OBJTV
46	TEXT1	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
47	ACTUALSTART_DATE	☐	CGPL_ACTUALSTARTDATE	DATUM	DATS	8	0	Actual Start Date
48	ACTUALSTART_TIME	☐	CGPL_ACTUALSTARTTIME	TIME	TIMS	6	0	Actual start (time)
49	ACTUALFINISH_DATE	☐	CGPL_ACTUALFINISHDATE	DATUM	DATS	8	0	Actual Finish (Date)
50	ACTUALFINISH_TIME	☐	CGPL_ACTUALFINISHTIME	TIME	TIMS	6	0	Actual Finish (Time)
51	PLANSTART_DATE	☐	CGPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
52	PLANSTART_TIME	☐	CGPL_PLANSTARTTIME	TIME	TIMS	6	0	Planned Start (Time)
53	PLANFINISH_DATE	☐	CGPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
54	PLANFINISH_TIME	☐	CGPL_PLANFINISHTIME	TIME	TIMS	6	0	Planned Finish (Time)
55	CONSTRAINTS_DATE	☐	CGPL_CONSTRAINTDATE	DATUM	DATS	8	0	Constraint Date (Date)
56	CONSTRAINTS_TIME	☐	CGPL_CONSTRAINTTIME	TIME	TIMS	6	0	Constraint Date (Time)
57	UP	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
58	DOWN	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
59	LEFT_NODE	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
60	RIGHT_NODE	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
61	NODE_LEVEL	☐	CGPL_LEVEL	INT1	INT1	3	0	CGPL Planning Level of Activity

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_MKTPL_CAMPAIGN_DATA	ADRESS_ID	CRMC_IM_ADRESS	E_ID
2	CRMT_MKTPL_CAMPAIGN_DATA	CAMP_TYPE	CRMC_MKTPL_CTYPE	CAMP_TYPE	KEY
3	CRMT_MKTPL_CAMPAIGN_DATA	CHANNEL	CRMC_MKTPL_CHAN	CHANNEL	KEY
4	CRMT_MKTPL_CAMPAIGN_DATA	OBJECTIVE	CRMC_MKTPL_OBJTV	OBJECTIVE
5	CRMT_MKTPL_CAMPAIGN_DATA	PRIORITY	CGPL_PRIO	PRIORITY	KEY
6	CRMT_MKTPL_CAMPAIGN_DATA	TACTICS	CRMC_MKTPL_TACTS	TACTICS

History

Last changed by/on	SAP	20130604
SAP Release Created in	20B