SAP ABAP Table CRMS_MKTPL_IB_DLM (Attributes of Node Deal (IBOM MKTPL))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_IB_DLM (Package) CRM Marketing: IBOM for Deal

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_DLM	Table Relationship Diagram
Short Description	Attributes of Node Deal (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	Generic include for Deal Basic Data
2	GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
3	EXTERNAL_ID	☐	CRM_MKTPL_DEALID	CGPL_EXTID	CHAR	24	0	Deal
4	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
5	CAMP_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	CRMC_MKTPL_CTYPE
6	CHANNEL	☐	CRM_MKTPL_CHANNEL	CRM_MKTPL_CHANNEL	CHAR	4	0	ID of Communication Medium
7	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective
8	TACTICS	☐	CRM_MKTPL_TACTICS	CRM_MKTPL_TACTICS	CHAR	4	0	Tactic
9	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
10	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
11	PLANNING_TYPE	☐	CGPL_PL_TYPE	CGPL_PLANNING_TYPE	CHAR	1	0	Planning Type
12	SHORTCUT	☐	CRMT_MKTPL_CAMPAIGN_SHORTCUT	CHAR4	CHAR	4	0	Campaign Code
13	AUTH_GROUP	☐	CRM_MKTPL_AUTH_GROUP	CRM_MKTPL_AUTH_GROUP	CHAR	4	0	Authorization Group
14	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
15	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
16	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
17	ACTION_PROFILE	☐	CRM_MKTPL_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	ID of Action Profile	*
18	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	TCURC
19	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
20	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
21	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
22	PARENT_GUID	☐	CRM_MKTPL_IB_MKTPROJECT_GUID		RAW	16	0	Marketing Project
23	EXCL_IND	☐	CRM_MKTPL_EXCL_IND	CRM_MKTPL_EXCL_IND	CHAR	1	0	Indicator: Marketing Project Is Exclusive
24	INACTIVE	☐	CRMT_MKTPL_INACTIVE	CHAR1	CHAR	1	0	Inactive Marketing Project
25	BPAT_TYPE	☐	CRM_MKTPL_DEF_BPAT_TYPE	CRM_MKTPL_DEF_BPAT_TYPE	CHAR	3	0	Type of Buying Pattern
26	RATES_ORIGIN	☐	CRM_MKTGS_RATES_ORIGIN	CRM_MKTGS_RATES_ORIGIN	CHAR	1	0	Rates Origin
27	.INCLUDE	☐				0	0	Attributes of Node Deal (IBOM MKTPL) - Include
28	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
29	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
30	TARGETGRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
31	CUSTOMER_ID	☐	CRM_MKTPL_CUSTOMER_ID	CHAR20	CHAR	20	0	Planning Account ID
32	CUSTOMER_DESC	☐	CRM_MKTGS_IB_PLANCUST		CHAR	72	0	Planning Customer Description
33	CUSTOMER_TYPE	☐	CRM_MKTPL_DLM_PLCUST_TYPE	CRM_MKTPL_DLM_PLCUST_TYPE	CHAR	2	0	Type of Planning Customer for Deals (BP, Hierarchy Node)
34	PROD_PL_BASIS	☐	CRM_MKTSS_PL_BASIS	CRM_MKTSS_PL_BASIS	NUMC	3	0	Product Planning Basis
35	PROD_PL_BASIS_TEXT	☐	CRM_MKTSS_PL_BASIS_TEXT	CRM_MKTSS_PL_BASIS_TEXT	CHAR	40	0	Description of Product Planning Basis
36	.INCLUDE	☐				0	0	Generic include for OrgData
37	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
38	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
39	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
40	.INCLUDE	☐				0	0	Generic include for Constraints
41	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
42	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
43	.INCLUDE	☐				0	0	Generic include for Deal Basic Data (external)
44	CAMP_TYPETX	☐	CRM_MKTPL_CAMPTYPETX	TEXT40	CHAR	40	0	Description of Type
45	OBJECTIVETX	☐	CRM_MKTPL_OBJECTIVETX	TEXT40	CHAR	40	0	Objective(s) Description
46	TACTICSTX	☐	CRM_MKTPL_TACTICSTX	TEXT40	CHAR	40	0	Tactic Description
47	CAMP_PRIOTX	☐	CRM_MKTPL_CAMPPRIOTX	TEXT40	CHAR	40	0	Description of Priority
48	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	BUT000
49	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
50	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
51	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
52	CURRENCY_TEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
53	FACTORY_CAL_TEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text
54	PSP_CREATION	☐	CRMT_MKTPL_R3_INT	CHAR1	CHAR	1	0	Marketing Planning: Object Replicated in ERP
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	PLANGROUP_DESC	☐	CGPL_SEM_PLGRPT	TEXT40	CHAR	40	0	Description of Planning Profile Group
58	BPAT_TYPE_TEXT	☐	CRM_MKTPL_DEF_BPAT_TYPETX	CRM_MKTPL_DEF_BPAT_TYPETX	CHAR	25	0	Type of Buying Pattern (Text)
59	.INCLUDE	☐				0	0	Generic include for OrgData (external)
60	SALES_ORG_DESC	☐	CRMT_SALES_ORG_DESC	CRMT_SALES_ORG_DESC	CHAR	40	0	Sales Organization Description
61	CHANNEL_DESC	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
62	DIVISION_DESC	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
63	.INCLUDE	☐				0	0	Generic include for Constraints (external)
64	CONSTRAINT_TYPETX	☐	CGPL_CONSTRAINTTX	TEXT40	CHAR	40	0	Description of Type of Scheduling Constraint
65	CONSTRAINTDATE	☐	CRM_MKTPL_CONSTRAINTDATE	DATUM	DATS	8	0	Constraint Date (Date)
66	CONSTRAINTTIME	☐	CRM_MKTPL_CONSTRAINTTIME	TIME	TIMS	6	0	Constraint Date (Time)
67	.INCLUDE	☐				0	0
68	.INCLUDE	☐				0	0
69	.INCLUDE	☐				0	0	CGPL Dates structure for inclusion
70	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
71	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
72	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
73	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
74	HIERARCHY_SORT	☐	CRM_MKTPL_HIERARCHY_SORT_SEQ		NUMC	3	0	Hierarchy Sort Sequence
75	.INCLUDE	☐				0	0	Extension Include - Deal Header
76	MKTPL_HEADER_DLM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
77	.INCLUDE	☐				0	0	Extension Include - Date Range Assignment
78	MKTPL_DATERANGE	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_IB_DLM	CAMP_TYPE	CRMC_MKTPL_CTYPE	CAMP_TYPE
2	CRMS_MKTPL_IB_DLM	CURRENCY	TCURC	WAERS
3	CRMS_MKTPL_IB_DLM	RESPONSIBLE_NAME	BUT000	PARTNER

History

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