SAP ABAP Table CRMS_MKTPL_IB_TPM (Attributes of Node TPM (IBOM MKTPL))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM (Application Component) Trade Promotion Management
     ⤷ CRM_MKTPL_IB_TPM (Package) CRM Marketing: iBom for Trade Promotion and Deal

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_TPM	Table Relationship Diagram
Short Description	Attributes of Node TPM (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 Basic Data
2	GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
3	EXTERNAL_ID	☐	CRM_MKTPL_TRADEID	CGPL_EXTID	CHAR	24	0	Trade Promotion
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	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective
7	TACTICS	☐	CRM_MKTPL_TACTICS	CRM_MKTPL_TACTICS	CHAR	4	0	Tactic
8	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
9	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
10	PLANNING_TYPE	☐	CGPL_PL_TYPE	CGPL_PLANNING_TYPE	CHAR	1	0	Planning Type
11	SHORTCUT	☐	CRMT_MKTPL_CAMPAIGN_SHORTCUT	CHAR4	CHAR	4	0	Campaign Code
12	AUTH_GROUP	☐	CRM_MKTPL_AUTH_GROUP	CRM_MKTPL_AUTH_GROUP	CHAR	4	0	Authorization Group
13	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
14	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
15	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
16	ACTION_PROFILE	☐	CRM_MKTPL_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	ID of Action Profile	*
17	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	TCURC
18	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
19	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
20	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
21	PARENT_GUID	☐	CRM_MKTPL_IB_MKTPROJECT_GUID		RAW	16	0	Marketing Project
22	NO_R3_INT	☐	CRM_MKTPL_NO_R3_INT	CHAR1	CHAR	1	0	Marketing Planning: Object Not Integrated into ERP PS
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	ADI_FLAG	☐	CRM_MKTPL_ADI	CRM_MKTPL_ADI	CHAR	1	0	Abnormal Demand Indicator
27	REF_TYPE	☐	CRM_MKTPL_REF_TYPE	CRM_MKTPL_REF_TYPE_DOM	CHAR	4	0	Usage Type
28	REF_TYPE_TEXT	☐	CRM_MKTPL_REF_TYPE_TEXT	TEXT40	CHAR	40	0	Usage Type Description
29	ENROLLMENT_REQ	☐	CRM_MKTPL_ENR_ENROLLMENT_REQ	XFELD	CHAR	1	0	Indicator, that enrollment is required
30	SURVEYID	☐	CRM_SVY_DB_SID	CHAR32	CHAR	32	0	CRM Surveys: Survey ID
31	SURVEYVERSION	☐	CRM_SVY_DB_SVERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Version
32	TEMPLATE	☐	CRM_MKTPL_TEMPLATE	CRM_BOOLEAN	CHAR	1	0	Template Indicator
33	VALIDATION_PROF	☐	CRM_CLA_VS_VAL_PROFILE_ID	CRM_CLA_VS_VAL_PROFILE_ID	CHAR	30	0	ID of Validation Sheet Profile
34	PPG_STATUS	☐	CRMT_PPG_STATUS	CRM_PPG_STATUS	CHAR	1	0	PPG Status
35	RATES_ORIGIN	☐	CRM_MKTGS_RATES_ORIGIN	CRM_MKTGS_RATES_ORIGIN	CHAR	1	0	Rates Origin
36	.INCLUDE	☐				0	0	Attributes of Node Trade (IBOM MKTPL) - Include
37	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
38	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
39	TARGETGRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
40	TGRP_OWNER_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
41	CUSTOMER_ID	☐	CRM_MKTPL_CUSTOMER_ID	CHAR20	CHAR	20	0	Planning Account ID
42	CUSTOMER_DESC	☐	CRM_MKTGS_IB_PLANCUST		CHAR	72	0	Planning Customer Description
43	TARGETGRP_DESC	☐	CRMT_MKTTG_TG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of a Target Group
44	TGRP_OWNER_DESC	☐	BU_NODE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of a Hierarchy Node
45	CUSTOMER_TYPE	☐	CRM_MKTPL_PLCUST_TYPE	CRM_MKTPL_PLCUST_TYPE	CHAR	2	0	Type of Account (BP, Hierarchy Node, Target Group)
46	CAMPAIGN_ASSIGNED	☐	CRM_MKTPL_ASSIGNED_CPG	CGPL_PROJECT_GUID	RAW	16	0	Campaign Assigned to TPM
47	DEAL_GUID	☐	CRMT_MKTPL_DLM_TEMPL	CGPL_PROJECT_GUID	RAW	16	0	Deal Template
48	PROD_PL_BASIS	☐	CRM_MKTSS_PL_BASIS	CRM_MKTSS_PL_BASIS	NUMC	3	0	Product Planning Basis
49	PROD_PL_BASIS_TEXT	☐	CRM_MKTSS_PL_BASIS_TEXT	CRM_MKTSS_PL_BASIS_TEXT	CHAR	40	0	Description of Product Planning Basis
50	NO_UPLIFT_IND	☐	CRM_MKTPL_NO_UPLIFT_IND	CRM_BOOLEAN	CHAR	1	0	TPM Significant Uplift Indicator
51	INDIRECT_IND	☐	CRM_MKTPL_INDIRECT_IND	CRM_BOOLEAN	CHAR	1	0	Indirect Indicator
52	DEAL_ID	☐	CRM_MKTPL_DEALID	CGPL_EXTID	CHAR	24	0	Deal
53	.INCLUDE	☐				0	0	Include for Channel Data
54	CHANNEL	☐	CRM_MKTPL_CHANNEL	CRM_MKTPL_CHANNEL	CHAR	4	0	ID of Communication Medium
55	MAIL_FORM	☐	CRMT_MKTPL_MAIL_FORM	TDSFNAME	CHAR	30	0	Form for Sending a Letter	*
56	MAIL_FORM_GUID	☐	CRMT_PML_GUID	SYSUUID	RAW	16	0	Personalized Mails: GUID for Mail Form
57	SMARTFORM	☐	CRMT_MKTPL_EMAIL_FORM	TDSFNAME	CHAR	30	0	Form for E-Mail	*
58	SMARTFORM_GUID	☐	CRMT_PML_GUID	SYSUUID	RAW	16	0	Personalized Mails: GUID for Mail Form
59	FAX_FORM	☐	CRMT_MKTPL_FAX_FORM	TDSFNAME	CHAR	30	0	Form for Fax	*
60	FAX_FORM_GUID	☐	CRMT_PML_GUID	SYSUUID	RAW	16	0	Personalized Mails: GUID for Mail Form
61	SMS_FORM	☐	CRMT_MKTPL_SMS_FORM	TDSFNAME	CHAR	30	0	Form for SMS/Pager Services	*
62	SMS_FORM_GUID	☐	CRMT_PML_GUID	SYSUUID	RAW	16	0	Personalized Mails: GUID for Mail Form
63	FILE_EXPORT_FORM	☐	CRMT_IM_EXPORT_FORM	TDSFNAME	CHAR	30	0	File Export Form	*
64	FILE_EXPORT_FORM_GUID	☐	CRMT_PML_GUID	SYSUUID	RAW	16	0	Personalized Mails: GUID for Mail Form
65	ADRESS_ID	☐	CRMT_IM_E_ID	CHAR12	CHAR	12	0	Identification for an E-mail Address
66	SEND_PARTNER	☐	CRM_IM_SEND_PARTNER	BU_PARTNER	CHAR	10	0	Business partner for Sender Address Determination	*
67	SCRIPT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
68	SPICE_SCRIPT	☐	CRM_IC_SCRNAME	CRM_IC_XMLNAME	CHAR	32	0	Name of Interaction Center (IC) WebClient Script
69	PRINT_ID	☐	CRMT_IM_PRINT_ID	CHAR12	CHAR	12	0	Profile for Print Parameters
70	EXECUTION_LANG	☐	CRM_MKTPL_EXECUTION_LANGUAGE	SPRAS	LANG	1	0	Execution Language in High-Volume Scenario	*
71	BP_CORR_LANG_IND	☐	CRM_MKTPL_DETERMINE_CORR_LANG	XFELD	CHAR	1	0	Indicator: Determine BP Correspondence Language
72	CHECK_CONSENT	☐	CRM_MKTPL_CHECK_MKT_PERMISSION	XFELD	CHAR	1	0	Check Consent (Marketing Permission)
73	.INCLUDE	☐				0	0	Include for Channel Data (external)
74	CHANNELTX	☐	CRM_MKTPL_CHANNELTX	TEXT40	CHAR	40	0	Description of Communication Medium
75	ADRESS_NAME	☐	CRMT_IM_E_ADDRESS	SO_STRI241	CHAR	241	0	Marketing: E-mail Address
76	ADRESS_TEXT	☐	CRMT_IM_E_TEXT	CHAR40	CHAR	40	0	Text for E-Mail Address
77	SEND_PARTNER_TEXT	☐	BU_DESCRIP_LONG	CHAR80	CHAR	80	0	Description of a Business Partner
78	SCRIPT_TREEID	☐	CRMT_TREEID	CRM_TREEID	NUMC	8	0	Name of Interaction Center (IC) WinClient Script
79	.INCLUDE	☐				0	0	Generic include for OrgData
80	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
81	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
82	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
83	.INCLUDE	☐				0	0	Generic include for Constraints
84	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
85	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
86	.INCLUDE	☐				0	0	Generic include for Basic Data (external)
87	CAMP_TYPETX	☐	CRM_MKTPL_CAMPTYPETX	TEXT40	CHAR	40	0	Description of Type
88	OBJECTIVETX	☐	CRM_MKTPL_OBJECTIVETX	TEXT40	CHAR	40	0	Objective(s) Description
89	TACTICSTX	☐	CRM_MKTPL_TACTICSTX	TEXT40	CHAR	40	0	Tactic Description
90	CAMP_PRIOTX	☐	CRM_MKTPL_CAMPPRIOTX	TEXT40	CHAR	40	0	Description of Priority
91	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	BUT000
92	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
93	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
94	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
95	CURRENCY_TEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
96	FACTORY_CAL_TEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text
97	PSP_CREATION	☐	CRMT_MKTPL_R3_INT	CHAR1	CHAR	1	0	Marketing Planning: Object Replicated in ERP
98	EXCL_IND_DESC	☐	CRM_MKTPL_EXCL_IND_DESC	CRM_BOOLEAN	CHAR	1	0	Marketing Planner: Exclusive Indicator for Mult. Promotions
99	ACTIVE	☐	CRMT_MKTPL_ACTIVE	XFELD	CHAR	1	0	Active Marketing Project
100	PLANGROUP_DESC	☐	CGPL_SEM_PLGRPT	TEXT40	CHAR	40	0	Description of Planning Profile Group
101	BPAT_TYPE_TEXT	☐	CRM_MKTPL_DEF_BPAT_TYPETX	CRM_MKTPL_DEF_BPAT_TYPETX	CHAR	25	0	Type of Buying Pattern (Text)
102	SURVEY_DESC_SHORT	☐	CRM_MKTPL_SURVEY_DESC_SHORT	TEXT45	CHAR	45	0	CRM Questionnaires: Short Description
103	.INCLUDE	☐				0	0	Generic include for OrgData (external)
104	SALES_ORG_DESC	☐	CRMT_SALES_ORG_DESC	CRMT_SALES_ORG_DESC	CHAR	40	0	Sales Organization Description
105	CHANNEL_DESC	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
106	DIVISION_DESC	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
107	.INCLUDE	☐				0	0	Generic include for Constraints (external)
108	CONSTRAINT_TYPETX	☐	CGPL_CONSTRAINTTX	TEXT40	CHAR	40	0	Description of Type of Scheduling Constraint
109	CONSTRAINTDATE	☐	CRM_MKTPL_CONSTRAINTDATE	DATUM	DATS	8	0	Constraint Date (Date)
110	CONSTRAINTTIME	☐	CRM_MKTPL_CONSTRAINTTIME	TIME	TIMS	6	0	Constraint Date (Time)
111	.INCLUDE	☐				0	0
112	.INCLUDE	☐				0	0
113	.INCLUDE	☐				0	0	CGPL Dates structure for inclusion
114	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
115	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
116	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
117	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
118	HIERARCHY_SORT	☐	CRM_MKTPL_HIERARCHY_SORT_SEQ		NUMC	3	0	Hierarchy Sort Sequence
119	.INCLUDE	☐				0	0	Extension Include - Trade Promotion Header
120	MKTPL_HEADER_TPM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
121	.INCLUDE	☐				0	0	Extension Include - Date Range Assignment
122	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_TPM	CAMP_TYPE	CRMC_MKTPL_CTYPE	CAMP_TYPE
2	CRMS_MKTPL_IB_TPM	CURRENCY	TCURC	WAERS
3	CRMS_MKTPL_IB_TPM	RESPONSIBLE_NAME	BUT000	PARTNER

History

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