SAP ABAP Table CRMS_MKTPL_IB_QE_TSP_PD_ATTR (IBOM Attributes for QE of Spend Values, TSP lead, Prod. Dim.)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_IB_GEN (Package) CRM Marketing: Generic objects for iBom for MKTPL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_QE_TSP_PD_ATTR	Table Relationship Diagram
Short Description	IBOM Attributes for QE of Spend Values, TSP lead, Prod. Dim.

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	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
2	PROD_DIM_GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
3	PROD_DIM_ID	☐	CRM_MKTGS_PROD_DIM_ID		CHAR	40	0	Product Dimension Id
4	PROD_DIM_TXT	☐	CRM_MKTGS_PROD_DIM_TXT		CHAR	80	0	Product Dimension Description
5	PROD_DIM_TYPE_TXT	☐	CRM_MKTGS_PROD_DIM_TYPE_TXT		CHAR	60	0	Product Dimension Type Description
6	ID	☐	CRM_MKTPL_QE_ID	CRM_MKTPL_QE_ID	CHAR	40	0	ID in trade spend-based Spend Value Overview
7	DESCRIPTION	☐	CRM_MKTPL_QE_DESCRIPTION	CRM_MKTPL_QE_DESCRIPTION	CHAR	200	0	Description in trade spend-based Spend Value Overview
8	START_DATE_DATS	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
9	END_DATE_DATS	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
10	SPEND_VALUE_IO	☐	CRM_MKTPL_SPEND_VALUE_IO	CRM_MKTPL_RATE_IO	CHAR	30	0	Char. field to display the spend value or a space or a '*'
11	OI_CAP_IO	☐	CRM_MKTPL_OI_CAP_IO	CRM_MKTPL_RATE_IO	CHAR	30	0	Character field to display the off-invoice cap or a '*'
12	TAKE_RATE_IO	☐	CRM_MKTPL_TAKE_RATE_IO	CRM_MKTPL_RATE_IO	CHAR	30	0	Character field to display the take rate or a '*'
13	EXCEPTION_EXISTS	☐	CRM_MKTGS_EXCEPTION_EXISTS	XFELD	CHAR	1	0	Flag indicating Trade Spend Exceptions Exists
14	CURRENCY_IO	☐	CRM_MKTPL_CURRENCY_IO	CRM_MKTPL_CURRENCY_IO	CHAR	5	0	Character field to display a currency or a '%'
15	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
16	CAP_UNIT	☐	CRM_MKTPL_CAP_UNIT	CRM_MKTPL_CAP_UNIT	CHAR	5	0	Character field to display a currency or a unit of measure
17	SELECT_FLAG	☐	CRM_MKTGS_PROD_DESEL	XFELD	CHAR	1	0	Product Deselect Indicator
18	LIST_PRICE	☐	CRM_MKTPL_LIST_PRICE	CRM_MKTPL_LIST_PRICE	DEC	20	2	List Price
19	RETAIL_PRICE	☐	CRM_MKTPL_RETAIL_PRICE	CRM_MKTPL_RETAIL_PRICE	DEC	20	2	Retail Price
20	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
21	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20110908
SAP Release Created in	701