SAP ABAP Table CRMS_MKTPPG_PPG_PRODLVL (Structure of Product assignment specific to AGR)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM-PPG (Application Component) Promotion Guidelines
     ⤷ CRM_MKTPPG_ASSIGN_PPG (Package) CRM Marketing: Assignments for PPG

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPPG_PPG_PRODLVL	Table Relationship Diagram
Short Description	Structure of Product assignment specific to AGR

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	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
4	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
5	.INCLUDE	☐				0	0	Structure for Generic Product Assignment
6	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
7	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
8	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
9	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
10	PRODUCT_CAT	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
11	PRODUCT_CAT_TEXT	☐	CRM_MKTGS_PROD_CAT1_TEXT	TEXT80	CHAR	80	0	Category Description 1
12	SEL_CATEGORY_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
13	CATEGORY2_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
14	CATEGORY2_ID	☐	CRM_MKTGS_PROD_CATEGORY2_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID 2
15	CATEGORY2_TEXT	☐	CRM_MKTGS_PROD_CAT2_TEXT	TEXT80	CHAR	80	0	Category Description 2
16	SEL_CATEGORY2_G	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
17	PRODUCT_GROUP	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
18	PRODUCT_GROUP_DESC	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
19	SEL_PRODUCT_GRP	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
20	QUANTITY	☐	CRM_MKTPL_PROD_QUANTITY	MENG13	QUAN	13	3	Product Quantity
21	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	T006
22	SELECT_FLAG	☐	CRM_MKTGS_PROD_DESEL	XFELD	CHAR	1	0	Product Deselect Indicator
23	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
24	XNOSEARCH	☐	COMT_PRODUCT_XNOSEARCH	COM_BOOLEAN	CHAR	1	0	Product Is Not Relevant for Search Help
25	VALID_FROM	☐	CRM_MKTPL_VALID_FROM	DATE	DATS	8	0	Valid From
26	VALID_TO	☐	CRM_MKTPL_VALID_TO	DATE	DATS	8	0	Valid To
27	PRODUCT_TYPE_DESCR	☐	COMT_PR_TYPE_DESC	TEXT40	CHAR	40	0	Product Type Description
28	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
29	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
30	GDL_PRICE_LVL_ID	☐	CRM_MKTPPG_GDL_PRICE_LVL_ID	CRM_MKTPPG_PRICELVL	CHAR	15	0	Guideline Pricing Level ID
31	GDL_PRICE_LVL_DESC	☐	CRM_MKTPPG_GDL_PARAM_DESC	CRM_MKTPPG_PARM_DESC	CHAR	40	0	Guideline Parameter Description
32	.INCLUDE	☐				0	0	Extension Include - Product
33	MKTPPG_PRODLVL	☐	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	CRMS_MKTPPG_PPG_PRODLVL	SALES_UOM	T006	MSEHI

History

Last changed by/on	SAP	20130604
SAP Release Created in	600