SAP ABAP Table CRMS_MKTPL_DLM_PROD (Structure of Product assignment specific to DLM.)

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	INTTAB	Structure
Structure	CRMS_MKTPL_DLM_PROD	Table Relationship Diagram
Short Description	Structure of Product assignment specific to DLM.

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	Structure of Product assignment specific to TPM
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
4	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
5	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
6	.INCLUDE	☐				0	0	Structure for Generic Product Assignment
7	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
8	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
9	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
10	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
11	PRODUCT_CAT	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
12	PRODUCT_CAT_TEXT	☐	CRM_MKTGS_PROD_CAT1_TEXT	TEXT80	CHAR	80	0	Category Description 1
13	SEL_CATEGORY_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
14	CATEGORY2_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
15	CATEGORY2_ID	☐	CRM_MKTGS_PROD_CATEGORY2_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID 2
16	CATEGORY2_TEXT	☐	CRM_MKTGS_PROD_CAT2_TEXT	TEXT80	CHAR	80	0	Category Description 2
17	SEL_CATEGORY2_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
18	PRODUCT_GROUP	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
19	PRODUCT_GROUP_DESC	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
20	SEL_PRODUCT_GRP	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
21	QUANTITY	☐	CRM_MKTPL_PROD_QUANTITY	MENG13	QUAN	13	3	Product Quantity
22	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	T006
23	SELECT_FLAG	☐	CRM_MKTGS_PROD_DESEL	XFELD	CHAR	1	0	Product Deselect Indicator
24	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
25	XNOSEARCH	☐	COMT_PRODUCT_XNOSEARCH	COM_BOOLEAN	CHAR	1	0	Product Is Not Relevant for Search Help
26	VALID_FROM	☐	CRM_MKTPL_VALID_FROM	DATE	DATS	8	0	Valid From
27	VALID_TO	☐	CRM_MKTPL_VALID_TO	DATE	DATS	8	0	Valid To
28	PRODUCT_TYPE_DESCR	☐	COMT_PR_TYPE_DESC	TEXT40	CHAR	40	0	Product Type Description
29	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
30	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
31	.INCLUDE	☐				0	0	Structure for Product assignment - free goods
32	ADD_PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
33	ADD_PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
34	ADD_PRODUCT_DESC	☐	CRM_MKTPL_FREE_PROD_DESC	TEXT40	CHAR	40	0	Free Product Description
35	ADD_PRODUCT_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
36	EXCL_INCL_IND	☐	CRM_MKTPL_PROD_INCL	XFELD	CHAR	1	0	Free Product Inclusion Checkbox
37	EXCEPTION_EXISTS	☐	CRM_MKTGS_EXCEPTION_EXISTS	XFELD	CHAR	1	0	Flag indicating Trade Spend Exceptions Exists
38	RATES_ORIGIN	☐	CRM_MKTGS_RATES_ORIGIN	CRM_MKTGS_RATES_ORIGIN	CHAR	1	0	Rates Origin
39	EFFECTIVE_FROM_DATS	☐	CRM_MKTPL_EFF_FROM	DATE	DATS	8	0	Product Dimension Effective-From Date
40	EFFECTIVE_TO_DATS	☐	CRM_MKTPL_EFF_TO	DATE	DATS	8	0	Product Dimension Effective To date
41	EFFECTIVE_FROM	☐	CRM_MKTPL_START_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional Start Date Range
42	EFFECTIVE_TO	☐	CRM_MKTPL_END_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional End Date Range
43	.INCLUDE	☐				0	0	Fund Association
44	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
45	FUND_DESC	☐	CRM_FM_FND_FUND_TYPE_DESC	TEXT40	CHAR	40	0	Fund Type Description
46	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
47	PROMO_PCAT_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
48	PROMO_PCAT_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
49	PROMO_PGRP_ID	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
50	ADDITIONAL_PROD_FLAG	☐	CRM_MKTPL_ADDITIONAL_PROD_FLAG	XFELD	CHAR	1	0	Flag indicating if product is additional
51	LIST_PRICE	☐	CRM_MKTPL_LIST_PRICE	CRM_MKTPL_LIST_PRICE	DEC	20	2	List Price
52	RETAIL_PRICE	☐	CRM_MKTPL_RETAIL_PRICE	CRM_MKTPL_RETAIL_PRICE	DEC	20	2	Retail Price
53	PROD_DIM_VOLUME	☐	CRM_MKTPL_PROD_DIM_VOLUME	CRM_MKTPL_PROD_DIM_VOLUME	DEC	22	0	Volume field
54	.INCLUDE	☐				0	0	Extension Include - Product
55	MKTPL_PRD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
56	.INCLUDE	☐				0	0	Extension Include - Product Dimension ext. for quick entry
57	MKTPL_QE_PRODDIM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
58	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
59	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
60	.INCLUDE	☐				0	0	CRM: Account Plan Extension Include - Product
61	ACCPL_PRD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
62	IS_STRUCTURED_PRODUCT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_DLM_PROD	SALES_UOM	T006	MSEHI

History

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