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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_IB_TPT	CURRENCY	TCURC	WAERS

History

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