SAP ABAP Table CRMS_MKTPL_IB_QE_TSPEND_ATTR (IBOM Attributes for Quick Entry of Spend Values, TSP lead)

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_TSPEND_ATTR	Table Relationship Diagram
Short Description	IBOM Attributes for Quick Entry of Spend Values, TSP 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	ID	☐	CRM_MKTPL_QE_ID	CRM_MKTPL_QE_ID	CHAR	40	0	ID in trade spend-based Spend Value Overview
10	DESCRIPTION	☐	CRM_MKTPL_QE_DESCRIPTION	CRM_MKTPL_QE_DESCRIPTION	CHAR	200	0	Description in trade spend-based Spend Value Overview
11	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 '*'
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	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 '*'
15	TAKE_RATE_IO	☐	CRM_MKTPL_TAKE_RATE_IO	CRM_MKTPL_RATE_IO	CHAR	30	0	Character field to display the take rate or a '*'
16	EXCEPTION_EXISTS	☐	CRM_MKTGS_EXCEPTION_EXISTS	XFELD	CHAR	1	0	Flag indicating Trade Spend Exceptions Exists
17	AG_TYPE	☐	/BON/AG_TYPE	CHAR4	CHAR	4	0	Agreement Type
18	KSCHL	☐	CRM_MKTGS_KSCHL_PR	/SAPCND/COND_TYPE	CHAR	4	0	Conition Type for Pricing	*
19	COND_GENERATED_TEXT	☐	CRM_MKTGS_COND_GENERATED_TEXT	CRM_MKTGS_COND_GENERATED_TEXT	CHAR	60	0	Cond Generated Text (From The Domain) - Language-Dependent
20	DATE_RANGE_TEXT	☐	CRM_MKTGS_DATE_RANGE_TEXT	CRM_MKTGS_DATE_RANGE_TEXT	CHAR	20	0	Date Range Description Text
21	DISC_METHOD_TXT	☐	CRM_MKTGS_DISC_METH_DESC	CRM_MKTGS_DISC_METH_DESC	CHAR	20	0	Discount Method Description
22	PARTICIP_RATE	☐	CRM_MKTPL_PARTICIP_RATE	CRM_MKTPL_PARTICIP_RATE	CHAR	3	0	Participation Rate (0-100%)
23	REBATE_STAT_TEXT	☐	CRM_MKTGS_REBATE_STAT_TEXT	CRM_MKTGS_REBATE_STAT_TEXT	CHAR	60	0	Rebate Status Text (From the Domain) - Language-Dependent
24	VOLUME_TEXT	☐	CRM_MKTGS_VOLUME_TEXT	CRM_MKTGS_VOLUME_TEXT	CHAR	20	0	Related Volume Text
25	CAT_TYPE_TEXT	☐	CRM_MKTGS_COST_CAT_DESC	CRM_MKTGS_COST_CAT_DESC	CHAR	40	0	Spend Category
26	SPEND_METHOD_TXT	☐	CRM_MKTGS_SPEND_METHOD_TEXT	CRM_MKTGS_SPEND_METHOD_TEXT	CHAR	20	0	Spend Method Description
27	COST_TYPE_TEXT	☐	CRM_MKTGS_COST_TEXT	CRM_MKTGS_COST_TEXT	CHAR	20	0	Spend Type
28	PAYMENT_TYPE_TXT	☐	CRMT_BUAG_PAYM_T	TEXT30	CHAR	30	0	Text for Payment Method
29	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	*
30	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
31	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