SAP ABAP Table CRMS_MKTPL_IB_TPM_INC_BD (Generic include for Basic Data)

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_INC_BD	Table Relationship Diagram
Short Description	Generic include for Basic Data

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	GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
2	EXTERNAL_ID	☐	CRM_MKTPL_TRADEID	CGPL_EXTID	CHAR	24	0	Trade Promotion
3	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
4	CAMP_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	CRMC_MKTPL_CTYPE
5	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective
6	TACTICS	☐	CRM_MKTPL_TACTICS	CRM_MKTPL_TACTICS	CHAR	4	0	Tactic
7	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
8	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
9	PLANNING_TYPE	☐	CGPL_PL_TYPE	CGPL_PLANNING_TYPE	CHAR	1	0	Planning Type
10	SHORTCUT	☐	CRMT_MKTPL_CAMPAIGN_SHORTCUT	CHAR4	CHAR	4	0	Campaign Code
11	AUTH_GROUP	☐	CRM_MKTPL_AUTH_GROUP	CRM_MKTPL_AUTH_GROUP	CHAR	4	0	Authorization Group
12	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
13	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
14	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
15	ACTION_PROFILE	☐	CRM_MKTPL_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	ID of Action Profile	*
16	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	TCURC
17	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
18	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
19	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
20	PARENT_GUID	☐	CRM_MKTPL_IB_MKTPROJECT_GUID		RAW	16	0	Marketing Project
21	NO_R3_INT	☐	CRM_MKTPL_NO_R3_INT	CHAR1	CHAR	1	0	Marketing Planning: Object Not Integrated into ERP PS
22	EXCL_IND	☐	CRM_MKTPL_EXCL_IND	CRM_MKTPL_EXCL_IND	CHAR	1	0	Indicator: Marketing Project Is Exclusive
23	INACTIVE	☐	CRMT_MKTPL_INACTIVE	CHAR1	CHAR	1	0	Inactive Marketing Project
24	BPAT_TYPE	☐	CRM_MKTPL_DEF_BPAT_TYPE	CRM_MKTPL_DEF_BPAT_TYPE	CHAR	3	0	Type of Buying Pattern
25	ADI_FLAG	☐	CRM_MKTPL_ADI	CRM_MKTPL_ADI	CHAR	1	0	Abnormal Demand Indicator
26	REF_TYPE	☐	CRM_MKTPL_REF_TYPE	CRM_MKTPL_REF_TYPE_DOM	CHAR	4	0	Usage Type
27	REF_TYPE_TEXT	☐	CRM_MKTPL_REF_TYPE_TEXT	TEXT40	CHAR	40	0	Usage Type Description
28	ENROLLMENT_REQ	☐	CRM_MKTPL_ENR_ENROLLMENT_REQ	XFELD	CHAR	1	0	Indicator, that enrollment is required
29	SURVEYID	☐	CRM_SVY_DB_SID	CHAR32	CHAR	32	0	CRM Surveys: Survey ID
30	SURVEYVERSION	☐	CRM_SVY_DB_SVERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Version
31	TEMPLATE	☐	CRM_MKTPL_TEMPLATE	CRM_BOOLEAN	CHAR	1	0	Template Indicator
32	VALIDATION_PROF	☐	CRM_CLA_VS_VAL_PROFILE_ID	CRM_CLA_VS_VAL_PROFILE_ID	CHAR	30	0	ID of Validation Sheet Profile
33	PPG_STATUS	☐	CRMT_PPG_STATUS	CRM_PPG_STATUS	CHAR	1	0	PPG Status
34	RATES_ORIGIN	☐	CRM_MKTGS_RATES_ORIGIN	CRM_MKTGS_RATES_ORIGIN	CHAR	1	0	Rates Origin

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_IB_TPM_INC_BD	CAMP_TYPE	CRMC_MKTPL_CTYPE	CAMP_TYPE
2	CRMS_MKTPL_IB_TPM_INC_BD	CURRENCY	TCURC	WAERS

History

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