SAP ABAP Table CRMS_MKTPL_QE_TSPEND_ATTR (Attributes for Quick Entry of Spend Values, trade spend lead)

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_TSPEND_ATTR	Table Relationship Diagram
Short Description	Attributes for Quick Entry of Spend Values, trade spend lead

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	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
2	COST_TYPE	☐	CRM_MKTPL_COST_TYPE	CRM_MKTPL_COST_TYPE	CHAR	4	0	Spend Type	*
3	COST_CATEGORY	☐	CRM_MKTPL_COST_CAT	CRM_MKTPL_COST_CAT	CHAR	30	0	Spend Category	*
4	SPEND_METHOD	☐	CRM_MKTPL_SPEND_METHOD	CRM_MKTPL_SPEND_METHOD	CHAR	10	0	Spend Method for Key Figure Planning	*
5	DISC_METHOD	☐	CRM_MKTPL_DISC_METH	CRM_MKTPL_DISC_METH	CHAR	4	0	Discount Method	*
6	VOLUME	☐	CRM_MKTPL_VOLUME	CRM_MKTPL_VOLUME	CHAR	4	0	Related Volume	*
7	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
8	EXPENSE_TYPE_DESC	☐	CRM_FM_EXPENSE_TYPE_DESC	TEXT40	CHAR	40	0	Expense Type Description
9	.INCLUDE	☐				0	0	Common attr. for Quick Entry of Spend Values, TSP lead
10	ID	☐	CRM_MKTPL_QE_ID	CRM_MKTPL_QE_ID	CHAR	40	0	ID in trade spend-based Spend Value Overview
11	DESCRIPTION	☐	CRM_MKTPL_QE_DESCRIPTION	CRM_MKTPL_QE_DESCRIPTION	CHAR	200	0	Description in trade spend-based Spend Value Overview
12	START_DATE_DATS	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
13	END_DATE_DATS	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
14	SPEND_VALUE	☐	CRM_MKTGS_SPEND_VALUE	CRM_MKTGS_SPEND_VALUE	CURR	20	2	Spend Value
15	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 '*'
16	OI_CAP	☐	CRM_MKTGS_OI_CAP	CRM_MKTGS_OI_CAP	CURR	20	2	Off Invoice Cap
17	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 '*'
18	CAP_TYPE	☐	CND_CAP_TYPE	CND_CAP_TYPE	CHAR	4	0	Type of Cross-Order Cap
19	TAKE_RATE	☐	CRM_MKTGS_TAKE_RATE	CRM_MKTGS_TAKE_RATE	NUMC	3	0	Take Rate
20	TAKE_RATE_IO	☐	CRM_MKTPL_TAKE_RATE_IO	CRM_MKTPL_RATE_IO	CHAR	30	0	Character field to display the take rate or a '*'
21	EXCEPTION_EXISTS	☐	CRM_MKTGS_EXCEPTION_EXISTS	XFELD	CHAR	1	0	Flag indicating Trade Spend Exceptions Exists
22	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	*
23	KRECH	☐	PRCT_CALCULATION_TYPE	PRC_CALCULATION_TYPE	CHAR	3	0	Calculation Type for Condition	*
24	BOVER	☐	/BON/BOVER	/BON/BOVER	CHAR	1	0	Rebate Procedure
25	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
26	OI_CAP_CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
27	AG_TYPE	☐	/BON/AG_TYPE	CHAR4	CHAR	4	0	Agreement Type
28	KSCHL	☐	CRM_MKTGS_KSCHL_PR	/SAPCND/COND_TYPE	CHAR	4	0	Conition Type for Pricing	*
29	COND_GENERATED_TEXT	☐	CRM_MKTGS_COND_GENERATED_TEXT	CRM_MKTGS_COND_GENERATED_TEXT	CHAR	60	0	Cond Generated Text (From The Domain) - Language-Dependent
30	DATE_RANGE_TEXT	☐	CRM_MKTGS_DATE_RANGE_TEXT	CRM_MKTGS_DATE_RANGE_TEXT	CHAR	20	0	Date Range Description Text
31	DISC_METHOD_TXT	☐	CRM_MKTGS_DISC_METH_DESC	CRM_MKTGS_DISC_METH_DESC	CHAR	20	0	Discount Method Description
32	PARTICIP_RATE	☐	CRM_MKTPL_PARTICIP_RATE	CRM_MKTPL_PARTICIP_RATE	CHAR	3	0	Participation Rate (0-100%)
33	REBATE_STAT_TEXT	☐	CRM_MKTGS_REBATE_STAT_TEXT	CRM_MKTGS_REBATE_STAT_TEXT	CHAR	60	0	Rebate Status Text (From the Domain) - Language-Dependent
34	VOLUME_TEXT	☐	CRM_MKTGS_VOLUME_TEXT	CRM_MKTGS_VOLUME_TEXT	CHAR	20	0	Related Volume Text
35	CAT_TYPE_TEXT	☐	CRM_MKTGS_COST_CAT_DESC	CRM_MKTGS_COST_CAT_DESC	CHAR	40	0	Spend Category
36	SPEND_METHOD_TXT	☐	CRM_MKTGS_SPEND_METHOD_TEXT	CRM_MKTGS_SPEND_METHOD_TEXT	CHAR	20	0	Spend Method Description
37	COST_TYPE_TEXT	☐	CRM_MKTGS_COST_TEXT	CRM_MKTGS_COST_TEXT	CHAR	20	0	Spend Type
38	PAYMENT_TYPE_TXT	☐	CRMT_BUAG_PAYM_T	TEXT30	CHAR	30	0	Text for Payment Method
39	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
40	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