SAP ABAP Table CRMS_MKTPL_QE_TSP_PD_ATTR (Attributes for QE of Spend Values, TSP lead, Prod. Dimension)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_ASSIGN_QE_TSP_LEAD (Package) Assignment for Quick Entry of Spend Values, Trade Spend lead

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_QE_TSP_PD_ATTR	Table Relationship Diagram
Short Description	Attributes for QE of Spend Values, TSP lead, Prod. Dimension

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	☐	CRM_MKTPL_PRODUCT_TYPE	CRM_MKTPL_PRODUCT_TYPE	CHAR	2	0	Product Level for Generating Conditions
6	PROD_DIM_TYPE_TXT	☐	CRM_MKTGS_PROD_DIM_TYPE_TXT		CHAR	60	0	Product Dimension Type Description
7	.INCLUDE	☐				0	0	Common attr. for Quick Entry of Spend Values, TSP lead
8	ID	☐	CRM_MKTPL_QE_ID	CRM_MKTPL_QE_ID	CHAR	40	0	ID in trade spend-based Spend Value Overview
9	DESCRIPTION	☐	CRM_MKTPL_QE_DESCRIPTION	CRM_MKTPL_QE_DESCRIPTION	CHAR	200	0	Description in trade spend-based Spend Value Overview
10	START_DATE_DATS	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
11	END_DATE_DATS	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
12	SPEND_VALUE	☐	CRM_MKTGS_SPEND_VALUE	CRM_MKTGS_SPEND_VALUE	CURR	20	2	Spend Value
13	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 '*'
14	OI_CAP	☐	CRM_MKTGS_OI_CAP	CRM_MKTGS_OI_CAP	CURR	20	2	Off Invoice Cap
15	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 '*'
16	CAP_TYPE	☐	CND_CAP_TYPE	CND_CAP_TYPE	CHAR	4	0	Type of Cross-Order Cap
17	TAKE_RATE	☐	CRM_MKTGS_TAKE_RATE	CRM_MKTGS_TAKE_RATE	NUMC	3	0	Take Rate
18	TAKE_RATE_IO	☐	CRM_MKTPL_TAKE_RATE_IO	CRM_MKTPL_RATE_IO	CHAR	30	0	Character field to display the take rate or a '*'
19	EXCEPTION_EXISTS	☐	CRM_MKTGS_EXCEPTION_EXISTS	XFELD	CHAR	1	0	Flag indicating Trade Spend Exceptions Exists
20	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	*
21	KRECH	☐	PRCT_CALCULATION_TYPE	PRC_CALCULATION_TYPE	CHAR	3	0	Calculation Type for Condition	*
22	BOVER	☐	/BON/BOVER	/BON/BOVER	CHAR	1	0	Rebate Procedure
23	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
24	OI_CAP_CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
25	CURRENCY_IO	☐	CRM_MKTPL_CURRENCY_IO	CRM_MKTPL_CURRENCY_IO	CHAR	5	0	Character field to display a currency or a '%'
26	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
27	CAP_UNIT	☐	CRM_MKTPL_CAP_UNIT	CRM_MKTPL_CAP_UNIT	CHAR	5	0	Character field to display a currency or a unit of measure
28	SELECT_FLAG	☐	CRM_MKTGS_PROD_DESEL	XFELD	CHAR	1	0	Product Deselect Indicator
29	LIST_PRICE	☐	CRM_MKTPL_LIST_PRICE	CRM_MKTPL_LIST_PRICE	DEC	20	2	List Price
30	RETAIL_PRICE	☐	CRM_MKTPL_RETAIL_PRICE	CRM_MKTPL_RETAIL_PRICE	DEC	20	2	Retail Price
31	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
32	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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