SAP ABAP Table CRMD_MKTPLTP_PCG (DB table for MKTPL TPM Product Category Assignments)

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_MKTPLTP_PCG	Table Relationship Diagram
Short Description	DB table for MKTPL TPM Product Category Assignments

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
4	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
5	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
6	.INCLUDE	☐				0	0	Generic include for Mkting PCAT Assign DB tables
7	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
8	.INCLUDE	☐				0	0	Sub-Generic include for Mkting PCAT Assign DB tables
9	SELECT_FLAG	☐	CRM_MKTSS_PCAT_SELECT_FLAG	XFELD	CHAR	1	0	Flag indicating if PCat is to be excluded from planning
10	SEL_CATEG_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
11	EFFECTIVE_FROM	☐	CRM_MKTPL_START_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional Start Date Range
12	EFFECTIVE_TO	☐	CRM_MKTPL_END_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional End Date Range
13	.INCLUDE	☐				0	0	Quick Entry fields persisted in product dimensions DB tables
14	LIST_PRICE	☐	CRM_MKTPL_LIST_PRICE	CRM_MKTPL_LIST_PRICE	DEC	20	2	List Price
15	RETAIL_PRICE	☐	CRM_MKTPL_RETAIL_PRICE	CRM_MKTPL_RETAIL_PRICE	DEC	20	2	Retail Price
16	PROD_DIM_VOLUME	☐	CRM_MKTPL_PROD_DIM_VOLUME	CRM_MKTPL_PROD_DIM_VOLUME	DEC	22	0	Volume field
17	.INCLUDE	☐				0	0	CRM: Account Plan Extension Include - Product Category
18	ACCPL_PRCAT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
19	.INCLUDE	☐				0	0	Extension Include - Product Category
20	MKTPL_PRCAT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
21	.INCLUDE	☐				0	0	Extension Include - Product Dimension ext. for quick entry
22	MKTPL_QE_PRODDIM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
23	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
24	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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