SAP ABAP Table CRMD_MKTPL_PROD (Assignment of Product in Marketing Planning)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_ASSIGN_PRODUCTS (Package) Marketing Specific Product Dimensions Assignments

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_MKTPL_PROD	Table Relationship Diagram
Short Description	Assignment of Product in Marketing Planning

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	☑	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
3	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts	CGPL_PROJECT
4	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts	CGPL_TASK
5	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product	COMM_PRODUCT
6	.INCLUDE	☐				0	0	CRM Marketing Planning: Include Structure Appl. Product
7	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
8	CATEGORY2_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
9	PRODUCT_GROUP	☐	CRM_MKTPL_PROD_GROUP		CHAR	3	0	Product Group
10	ADD_PRODUCT	☐	CRM_MKTPL_FREE_PROD_GUID	SYSUUID	RAW	16	0	Free Product GUID
11	EXCL_INCL_IND	☐	CRM_MKTPL_PROD_INCL	XFELD	CHAR	1	0	Free Product Inclusion Checkbox
12	SELECT_FLAG	☐	CRM_MKTPL_PROD_SEL	FLAG	CHAR	1	0	Product Exclusion Checkbox
13	QUANTITY	☐	CRM_MKTPL_PROD_QUANTITY	MENG13	QUAN	13	3	Product Quantity
14	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
15	ADD_PRODUCT_UOM	☐	CRM_MKTPL_FREE_PROD_UOM	MEINS	UNIT	3	0	Unit of Measure for the Free Product	*
16	SEL_CATEGORY_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
17	SEL_CATEGORY2_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
18	SEL_PRODUCT_GRP	☐	CRM_MKTPL_PROD_GROUP		CHAR	3	0	Product Group
19	PROMO_PCAT_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
20	PROMO_PGRP_ID	☐	CRM_MKTPL_PROD_GROUP		CHAR	3	0	Product Group
21	.INCLUDE	☐				0	0	Quick Entry fields persisted in product dimensions DB tables
22	LIST_PRICE	☐	CRM_MKTPL_LIST_PRICE	CRM_MKTPL_LIST_PRICE	DEC	20	2	List Price
23	RETAIL_PRICE	☐	CRM_MKTPL_RETAIL_PRICE	CRM_MKTPL_RETAIL_PRICE	DEC	20	2	Retail Price
24	PROD_DIM_VOLUME	☐	CRM_MKTPL_PROD_DIM_VOLUME	CRM_MKTPL_PROD_DIM_VOLUME	DEC	22	0	Volume field
25	EFFECTIVE_FROM	☐	CRM_MKTPL_START_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional Start Date Range
26	EFFECTIVE_TO	☐	CRM_MKTPL_END_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional End Date Range
27	PRODUCT_PRICE	☐	CRM_MKTPL_PROD_PRICE	CRM_MKTPL_PROD_PRICE	DEC	15	2	Suggested Retail Price
28	PARTNER_PRICE	☐	CRM_MKTPL_PARTNER_PRICE	CRM_MKTPL_PARTNER_PRICE	DEC	15	2	Partner Retail Price
29	.INCLUDE	☐				0	0	Extension Include - Product
30	MKTPL_PRD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
31	.INCLUDE	☐				0	0	Extension Include - Product Dimension ext. for quick entry
32	MKTPL_QE_PRODDIM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
33	.INCLUDE	☐				0	0	CRM: Account Plan Extension Include - Product
34	ACCPL_PRD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
35	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
36	MKTPL_QE_TSPEND	☐	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	CRMD_MKTPL_PROD	PRODUCT_GUID	COMM_PRODUCT	CLIENT
2	CRMD_MKTPL_PROD	PROJECT_GUID	CGPL_PROJECT	GUID
3	CRMD_MKTPL_PROD	TASK_GUID	CGPL_TASK	GUID

History

Last changed by/on	SAP	20131122
SAP Release Created in	12A