SAP ABAP Table CRMS_MKTPL_DLM_PCAT (Data Structure for MKTPL DLM 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	INTTAB	Structure
Structure	CRMS_MKTPL_DLM_PCAT	Table Relationship Diagram
Short Description	Data Structure for MKTPL DLM Product Category Assignments

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	Data Structure for MKTPL TPM Product Category Assignments
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	Generic include for Mkting PCAT Assign data structures
7	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
8	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
9	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
10	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
11	SELECT_FLAG	☐	CRM_MKTSS_PCAT_SELECT_FLAG	XFELD	CHAR	1	0	Flag indicating if PCat is to be excluded from planning
12	SEL_CATEG_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
13	EXCEPTION_EXISTS	☐	CRM_MKTGS_EXCEPTION_EXISTS	XFELD	CHAR	1	0	Flag indicating Trade Spend Exceptions Exists
14	RATES_ORIGIN	☐	CRM_MKTGS_RATES_ORIGIN	CRM_MKTGS_RATES_ORIGIN	CHAR	1	0	Rates Origin
15	.INCLUDE	☐				0	0	Display Pallet enhancement (ignore when TP Type <> Pallet)
16	QUANTITY	☐	COMT_IL_MINQUAN	MENG13	QUAN	13	3	Component Quantity
17	UNIT_QTY	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
18	EFFECTIVE_FROM_DATS	☐	CRM_MKTPL_EFF_FROM	DATE	DATS	8	0	Product Dimension Effective-From Date
19	EFFECTIVE_TO_DATS	☐	CRM_MKTPL_EFF_TO	DATE	DATS	8	0	Product Dimension Effective To date
20	EFFECTIVE_FROM	☐	CRM_MKTPL_START_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional Start Date Range
21	EFFECTIVE_TO	☐	CRM_MKTPL_END_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional End Date Range
22	.INCLUDE	☐				0	0	Fund Association
23	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
24	FUND_DESC	☐	CRM_FM_FND_FUND_TYPE_DESC	TEXT40	CHAR	40	0	Fund Type Description
25	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
26	LIST_PRICE	☐	CRM_MKTPL_LIST_PRICE	CRM_MKTPL_LIST_PRICE	DEC	20	2	List Price
27	RETAIL_PRICE	☐	CRM_MKTPL_RETAIL_PRICE	CRM_MKTPL_RETAIL_PRICE	DEC	20	2	Retail Price
28	PROD_DIM_VOLUME	☐	CRM_MKTPL_PROD_DIM_VOLUME	CRM_MKTPL_PROD_DIM_VOLUME	DEC	22	0	Volume field
29	.INCLUDE	☐				0	0	Extension Include - Product Category
30	MKTPL_PRCAT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
31	.INCLUDE	☐				0	0	Extension Include - Product Dimension ext. for quick entry
32	MKTPL_QE_PRODDIM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
33	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
34	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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