SAP ABAP Table CRMS_MKTPL_KPI_PRODUCT (KPI: Product assignment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-ST-KFP (Application Component) Key Figure Planning
     ⤷ CRM_MKTPL_KPI_INTEGRATION (Package) CRM Marketing Planner: KPI Integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_KPI_PRODUCT	Table Relationship Diagram
Short Description	KPI: Product assignment

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	Assignment of Product Marketing Planning + Attributes
2	.INCLUDE	☐				0	0	Assignment of Product in Marketing Planning
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
5	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts	CGPL_PROJECT
6	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts	CGPL_TASK
7	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product	COMM_PRODUCT
8	.INCLUDE	☐				0	0	CRM Marketing Planning: Include Structure Appl. Product
9	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
10	CATEGORY2_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
11	PRODUCT_GROUP	☐	CRM_MKTPL_PROD_GROUP		CHAR	3	0	Product Group
12	ADD_PRODUCT	☐	CRM_MKTPL_FREE_PROD_GUID	SYSUUID	RAW	16	0	Free Product GUID
13	EXCL_INCL_IND	☐	CRM_MKTPL_PROD_INCL	XFELD	CHAR	1	0	Free Product Inclusion Checkbox
14	SELECT_FLAG	☐	CRM_MKTPL_PROD_SEL	FLAG	CHAR	1	0	Product Exclusion Checkbox
15	QUANTITY	☐	CRM_MKTPL_PROD_QUANTITY	MENG13	QUAN	13	3	Product Quantity
16	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
17	ADD_PRODUCT_UOM	☐	CRM_MKTPL_FREE_PROD_UOM	MEINS	UNIT	3	0	Unit of Measure for the Free Product	*
18	SEL_CATEGORY_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
19	SEL_CATEGORY2_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
20	SEL_PRODUCT_GRP	☐	CRM_MKTPL_PROD_GROUP		CHAR	3	0	Product Group
21	PROMO_PCAT_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
22	PROMO_PGRP_ID	☐	CRM_MKTPL_PROD_GROUP		CHAR	3	0	Product Group
23	.INCLUDE	☐				0	0	Quick Entry fields persisted in product dimensions DB tables
24	LIST_PRICE	☐	CRM_MKTPL_LIST_PRICE	CRM_MKTPL_LIST_PRICE	DEC	20	2	List Price
25	RETAIL_PRICE	☐	CRM_MKTPL_RETAIL_PRICE	CRM_MKTPL_RETAIL_PRICE	DEC	20	2	Retail Price
26	PROD_DIM_VOLUME	☐	CRM_MKTPL_PROD_DIM_VOLUME	CRM_MKTPL_PROD_DIM_VOLUME	DEC	22	0	Volume field
27	EFFECTIVE_FROM	☐	CRM_MKTPL_START_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional Start Date Range
28	EFFECTIVE_TO	☐	CRM_MKTPL_END_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional End Date Range
29	PRODUCT_PRICE	☐	CRM_MKTPL_PROD_PRICE	CRM_MKTPL_PROD_PRICE	DEC	15	2	Suggested Retail Price
30	PARTNER_PRICE	☐	CRM_MKTPL_PARTNER_PRICE	CRM_MKTPL_PARTNER_PRICE	DEC	15	2	Partner Retail Price
31	.INCLUDE	☐				0	0	Extension Include - Product
32	MKTPL_PRD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
33	.INCLUDE	☐				0	0	Extension Include - Product Dimension ext. for quick entry
34	MKTPL_QE_PRODDIM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
35	.INCLUDE	☐				0	0	CRM: Account Plan Extension Include - Product
36	ACCPL_PRD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
37	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
38	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
39	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
40	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
41	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
42	PRODUCT_CAT	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
43	PRODUCT_CAT_TEXT	☐	CRM_MKTPL_PROD_CAT1_TEXT	TEXT80	CHAR	80	0	Category Description 1
44	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
45	VALID_FROM	☐	COMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Valid From (Time Stamp)
46	VALID_TO	☐	COMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Valid To (Time Stamp)
47	XNOSEARCH	☐	COMT_PRODUCT_XNOSEARCH	COM_BOOLEAN	CHAR	1	0	Product Is Not Relevant for Search Help
48	CATEGORY2_ID	☐	CRM_MKTPL_PROD_CATEGORY2_ID	COM_CATEGORY_ID	CHAR	20	0	Category 2 ID
49	CATEGORY2_TEXT	☐	CRM_MKTPL_PROD_CAT2_TEXT	TEXT80	CHAR	80	0	Category Description 2
50	PRODUCT_GROUP_DESC	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
51	ADD_PRODUCT_ID	☐	CRM_MKTPL_FREE_PROD_ID	COM_PRODUCT_ID	CHAR	40	0	Free Product ID
52	ADD_PRODUCT_DESC	☐	CRM_MKTPL_FREE_PROD_DESC	TEXT40	CHAR	40	0	Free Product Description
53	NOT_CHANGEABLE	☐	CRM_MKTPL_PROD_NOT_CHANGEABLE		CHAR	1	0	Change Product Assignment Checkbox
54	PROMO_PCAT_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
55	.INCLUDE	☐				0	0	Product assignment - structure with products groups
56	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
57	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
58	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
59	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
60	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
61	REFERENCE	☐	CL_CRM_MKTPL_PROD_ASSIGNMENT		REF	0	0
62	BASE_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
63	COND_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
64	FREE_BASE_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
65	FREE_SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
66	UOM_FACTOR	☐	FLOAT	FLTP	FLTP	16	16	Field of type FLTP
67	PRODUCT_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
68	CATEGORY2_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
69	CATEGORY3_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
70	ADD_PRODUCT_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
71	ADD_QUANTITY	☐	CRM_KPI_Y_VALUE	CRM_KPI_VALUE	DEC	20	4	CRM KPI Planning - Key Figure Value
72	LISTED_PRICE	☐	CRM_KPI_Y_VALUE	CRM_KPI_VALUE	DEC	20	4	CRM KPI Planning - Key Figure Value
73	FREE_GOODS_PRICE	☐	CRM_KPI_Y_VALUE	CRM_KPI_VALUE	DEC	20	4	CRM KPI Planning - Key Figure Value
74	FREE_UOM_FACTOR	☐	FLOAT	FLTP	FLTP	16	16	Field of type FLTP
75	START_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
76	END_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_KPI_PRODUCT	PRODUCT_GUID	COMM_PRODUCT	CLIENT
2	CRMS_MKTPL_KPI_PRODUCT	PROJECT_GUID	CGPL_PROJECT	GUID
3	CRMS_MKTPL_KPI_PRODUCT	TASK_GUID	CGPL_TASK	GUID

History

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