SAP ABAP Table CRM_MKT_MKTPLAN_HIER_STRUCTURE (Hierarchy Level of a Marketing Project with Attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-SEG (Application Component) Segmentation
     ⤷ CRM_MKT_MINIAPPS (Package) CRM Marketing: MiniApp Development

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_MKT_MKTPLAN_HIER_STRUCTURE	Table Relationship Diagram
Short Description	Hierarchy Level of a Marketing Project with Attributes

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	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
5	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
6	UP	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
7	DOWN	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
8	LEFT_NODE	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
9	RIGHT_NODE	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
10	NODE_LEVEL	☐	CGPL_LEVEL	INT1	INT1	3	0	CGPL Planning Level of Activity
11	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
12	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
13	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
14	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
15	CREATED_IN_BW	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
16	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
17	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
18	UPDATED_IN_BW	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
19	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
20	.INCLUDE	☐				0	0	CRM Marketing Planning - External Format of Attributes
21	CAMP_TYPETX	☐	CRM_MKTPL_CAMPTYPETX	TEXT40	CHAR	40	0	Description of Type
22	CHANNELTX	☐	CRM_MKTPL_CHANNELTX	TEXT40	CHAR	40	0	Description of Communication Medium
23	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
24	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
25	ADRESS_NAME	☐	CRMT_IM_E_ADDRESS	SO_STRI241	CHAR	241	0	Marketing: E-mail Address
26	ADRESS_TEXT	☐	CRMT_IM_E_TEXT	CHAR40	CHAR	40	0	Text for E-Mail Address
27	PLANSTARTDATE	☐	CRM_MKTPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
28	PLANFINISHDATE	☐	CRM_MKTPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
29	ACTUALSTARTDATE	☐	CRM_MKTPL_ACTUALSTARTDATE	DATUM	DATS	8	0	Actual Start Date
30	ACTUALFINISHDATE	☐	CRM_MKTPL_ACTUALFINISHDATE	DATUM	DATS	8	0	Actual Finish (Date)
31	PLANSTARTTIME	☐	CRM_MKTPL_PLANSTARTTIME	TIME	TIMS	6	0	Planned Start (Time)
32	PLANFINISHTIME	☐	CRM_MKTPL_PLANFINISHTIME	TIME	TIMS	6	0	Planned Finish (Time)
33	ACTUALSTARTTIME	☐	CRM_MKTPL_ACTUALSTARTTIME	TIME	TIMS	6	0	Actual Start (Time)
34	ACTUALFINISHTIME	☐	CRM_MKTPL_ACTUALFINISHTIME	TIME	TIMS	6	0	Actual Finish (time)
35	CONSTRAINTDATE	☐	CRM_MKTPL_CONSTRAINTDATE	DATUM	DATS	8	0	Constraint Date (Date)
36	CONSTRAINTTIME	☐	CRM_MKTPL_CONSTRAINTTIME	TIME	TIMS	6	0	Constraint Date (Time)
37	SCRIPT_TREEID	☐	CRMT_TREEID	CRM_TREEID	NUMC	8	0	Name of Interaction Center (IC) WinClient Script
38	SEND_PARTNER_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
39	TACTICSTX	☐	CRM_MKTPL_TACTICSTX	TEXT40	CHAR	40	0	Tactic Description
40	OBJECTIVETX	☐	CRM_MKTPL_OBJECTIVETX	TEXT40	CHAR	40	0	Objective(s) Description
41	CAMP_PRIOTX	☐	CRM_MKTPL_CAMPPRIOTX	TEXT40	CHAR	40	0	Description of Priority
42	CONSTRAINT_TYPETX	☐	CGPL_CONSTRAINTTX	TEXT40	CHAR	40	0	Description of Type of Scheduling Constraint
43	PLANSTART_IO	☐	CRM_MKTPL_PLANSTART_IO	TZTF_IO_FIELD	CHAR	26	0	Planned Start Date
44	PLANFINISH_IO	☐	CRM_MKTPL_PLANFINISH_IO	TZTF_IO_FIELD	CHAR	26	0	Planned End Date
45	ACTUALSTART_IO	☐	CRM_MKTPL_ACTUALSTART_IO	TZTF_IO_FIELD	CHAR	26	0	Actual Start Date
46	ACTUALFINISH_IO	☐	CRM_MKTPL_ACTUALFINISH_IO	TZTF_IO_FIELD	CHAR	26	0	Actual Finish Date
47	CONSTRAINT_IO	☐	CRM_MKTPL_CONSTRAINT_IO	TZTF_IO_FIELD	CHAR	26	0	Constraint Date
48	FACTORY_CAL_TEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text
49	ACTION_PROFILE_TEXT	☐	PPFDCNTXTT	TEXT60	CHAR	60	0	PPF: Description of Action Profile
50	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
51	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
52	CURRENCY_TEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
53	PSP_CREATION	☐	CRMT_MKTPL_R3_INT	CHAR1	CHAR	1	0	Marketing Planning: Object Replicated in ERP
54	MKT_ORG_DESC	☐	CRM_MKTPL_MORG_DESC	CRM_MKTPL_MORG_DESC	CHAR	40	0	Marketing Organization Description
55	EXCL_IND_DESC	☐	CRM_MKTPL_EXCL_IND_DESC	CRM_BOOLEAN	CHAR	1	0	Marketing Planner: Exclusive Indicator for Mult. Promotions
56	ACTIVE	☐	CRMT_MKTPL_ACTIVE	XFELD	CHAR	1	0	Active Marketing Project
57	HAS_PROCESSMODEL	☐	CRMT_MKTPL_HAS_PROCESSMODEL		CHAR	1	0	Campaign Has Process Model
58	PROD_PL_BASIS_TEXT	☐	CRM_MKTSS_PL_BASIS_TEXT	CRM_MKTSS_PL_BASIS_TEXT	CHAR	40	0	Description of Product Planning Basis
59	PLANGROUP_DESC	☐	CGPL_SEM_PLGRPT	TEXT40	CHAR	40	0	Description of Planning Profile Group
60	AUTH_GROUP_TEXT	☐	CRM_MKTPL_AUTH_GROUPTX	TEXT40	CHAR	40	0	Description of Authorization Group
61	HIERARCHY_SORT	☐	CRM_MKTPL_HIERARCHY_SORT_SEQ		NUMC	3	0	Hierarchy Sort Sequence
62	HV_ACTIVE	☐	CRM_MKTPL_HV_ACTIVE	CRM_MKTPL_HV_ACTIVE	CHAR	1	0	High-Volume Execution

History

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