SAP ABAP Table CRMS_MKTPL_IB_TPM_PRODUCT (Product Attributes of Node TPM (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_TPM_PRODUCT	Table Relationship Diagram
Short Description	Product Attributes of Node TPM (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	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
2	.INCLUDE	☐				0	0	Structure for Generic Product Assignment
3	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
4	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
5	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
6	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
7	PRODUCT_CAT	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
8	PRODUCT_CAT_TEXT	☐	CRM_MKTGS_PROD_CAT1_TEXT	TEXT80	CHAR	80	0	Category Description 1
9	SEL_CATEGORY_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
10	CATEGORY2_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
11	CATEGORY2_ID	☐	CRM_MKTGS_PROD_CATEGORY2_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID 2
12	CATEGORY2_TEXT	☐	CRM_MKTGS_PROD_CAT2_TEXT	TEXT80	CHAR	80	0	Category Description 2
13	SEL_CATEGORY2_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
14	PRODUCT_GROUP	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
15	PRODUCT_GROUP_DESC	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
16	SEL_PRODUCT_GRP	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
17	QUANTITY	☐	CRM_MKTPL_PROD_QUANTITY	MENG13	QUAN	13	3	Product Quantity
18	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	T006
19	SELECT_FLAG	☐	CRM_MKTGS_PROD_DESEL	XFELD	CHAR	1	0	Product Deselect Indicator
20	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
21	XNOSEARCH	☐	COMT_PRODUCT_XNOSEARCH	COM_BOOLEAN	CHAR	1	0	Product Is Not Relevant for Search Help
22	VALID_FROM	☐	CRM_MKTPL_VALID_FROM	DATE	DATS	8	0	Valid From
23	VALID_TO	☐	CRM_MKTPL_VALID_TO	DATE	DATS	8	0	Valid To
24	PRODUCT_TYPE_DESCR	☐	COMT_PR_TYPE_DESC	TEXT40	CHAR	40	0	Product Type Description
25	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
26	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
27	.INCLUDE	☐				0	0	Structure for Product assignment - free goods
28	ADD_PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
29	ADD_PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
30	ADD_PRODUCT_DESC	☐	CRM_MKTPL_FREE_PROD_DESC	TEXT40	CHAR	40	0	Free Product Description
31	ADD_PRODUCT_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
32	EXCL_INCL_IND	☐	CRM_MKTPL_PROD_INCL	XFELD	CHAR	1	0	Free Product Inclusion Checkbox
33	EXCEPTION_EXISTS	☐	CRM_MKTGS_EXCEPTION_EXISTS	XFELD	CHAR	1	0	Flag indicating Trade Spend Exceptions Exists
34	RATES_ORIGIN	☐	CRM_MKTGS_RATES_ORIGIN	CRM_MKTGS_RATES_ORIGIN	CHAR	1	0	Rates Origin
35	EFFECTIVE_FROM_DATS	☐	CRM_MKTPL_EFF_FROM	DATE	DATS	8	0	Product Dimension Effective-From Date
36	EFFECTIVE_TO_DATS	☐	CRM_MKTPL_EFF_TO	DATE	DATS	8	0	Product Dimension Effective To date
37	.INCLUDE	☐				0	0	Fund Association
38	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
39	FUND_DESC	☐	CRM_FM_FND_FUND_TYPE_DESC	TEXT40	CHAR	40	0	Fund Type Description
40	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
41	PROMO_PCAT_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
42	PROMO_PCAT_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
43	PROMO_PGRP_ID	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
44	ADDITIONAL_PROD_FLAG	☐	CRM_MKTPL_ADDITIONAL_PROD_FLAG	XFELD	CHAR	1	0	Flag indicating if product is additional
45	.INCLUDE	☐				0	0	Extension Include - Product
46	MKTPL_PRD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
47	.INCLUDE	☐				0	0	Extension Include - Product Dimension ext. for quick entry
48	MKTPL_QE_PRODDIM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
49	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
50	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
51	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_IB_TPM_PRODUCT	SALES_UOM	T006	MSEHI

History

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