SAP ABAP Table CRMT_MKT_EXT_PLAN (CRM MKT: Plan Structure for a CRM Plan)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-SEG-ITP (Application Component) Interface Third Party
     ⤷ CRM_MKT_EXTERNAL_APIS (Package) CRM Marketing: Interface to Ext.Campaign Managment Tools

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MKT_EXT_PLAN	Table Relationship Diagram
Short Description	CRM MKT: Plan Structure for a CRM Plan

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

History

Last changed by/on	SAP	20130604
SAP Release Created in	12A