SAP ABAP Table CRMS_MKTPL_IB_TPM_TRADE_SPEND (Trade Spend Attributes of Node Trade (IBOM MKTPL))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM (Application Component) Trade Promotion Management
     ⤷ CRM_MKTPL_IB_TPM (Package) CRM Marketing: iBom for Trade Promotion and Deal

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_TPM_TRADE_SPEND	Table Relationship Diagram
Short Description	Trade Spend Attributes of Node Trade (IBOM MKTPL)

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	.INCLUDE	☐				0	0	generic structure for trade spends
3	INFO_OBJECT_COST	☐	CGPL_SEM_CHANM	RSIOBJNM	CHAR	30	0	SEM-API: Characteristic
4	COST_TYPE_TEXT	☐	CRM_MKTGS_COST_TEXT	CRM_MKTGS_COST_TEXT	CHAR	20	0	Spend Type
5	CAT_TYPE_TEXT	☐	CRM_MKTGS_COST_CAT_DESC	CRM_MKTGS_COST_CAT_DESC	CHAR	40	0	Spend Category
6	SPEND_METHOD_TXT	☐	CRM_MKTGS_SPEND_METHOD_TEXT	CRM_MKTGS_SPEND_METHOD_TEXT	CHAR	20	0	Spend Method Description
7	DISC_METHOD_TXT	☐	CRM_MKTGS_DISC_METH_DESC	CRM_MKTGS_DISC_METH_DESC	CHAR	20	0	Discount Method Description
8	VOLUME_TEXT	☐	CRM_MKTGS_VOLUME_TEXT	CRM_MKTGS_VOLUME_TEXT	CHAR	20	0	Related Volume Text
9	INFO_OBJECT_VOLUME	☐	CGPL_SEM_CHANM	RSIOBJNM	CHAR	30	0	SEM-API: Characteristic
10	KRECH	☐	PRCT_CALCULATION_TYPE	PRC_CALCULATION_TYPE	CHAR	3	0	Calculation Type for Condition	*
11	PAYMENT_TYPE_TXT	☐	CRMT_BUAG_PAYM_T	TEXT30	CHAR	30	0	Text for Payment Method
12	COND_GENERATED_TEXT	☐	CRM_MKTGS_COND_GENERATED_TEXT	CRM_MKTGS_COND_GENERATED_TEXT	CHAR	60	0	Cond Generated Text (From The Domain) - Language-Dependent
13	REBATE_STAT_TEXT	☐	CRM_MKTGS_REBATE_STAT_TEXT	CRM_MKTGS_REBATE_STAT_TEXT	CHAR	60	0	Rebate Status Text (From the Domain) - Language-Dependent
14	KAPPL	☐	/SAPCND/APPLICATION	/SAPCND/APPLICATION	CHAR	3	0	Application as Condition Technique	*
15	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	*
16	KSCHL	☐	CRM_MKTGS_KSCHL_PR	/SAPCND/COND_TYPE	CHAR	4	0	Conition Type for Pricing	*
17	AG_TYPE	☐	/BON/AG_TYPE	CHAR4	CHAR	4	0	Agreement Type
18	DATE_RANGE_TEXT	☐	CRM_MKTGS_DATE_RANGE_TEXT	CRM_MKTGS_DATE_RANGE_TEXT	CHAR	20	0	Date Range Description Text
19	START_DATE_IO	☐	CRM_MKTPL_PLANSTART_IO	TZTF_IO_FIELD	CHAR	26	0	Planned Start Date
20	END_DATE_IO	☐	CRM_MKTPL_PLANFINISH_IO	TZTF_IO_FIELD	CHAR	26	0	Planned End Date
21	TRANSFER_STATUS	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
22	GENERATE_CONDITIONS_STATUS	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
23	REBATES_STATUS	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
24	RATES_ORIGIN	☐	CRM_MKTGS_RATES_ORIGIN	CRM_MKTGS_RATES_ORIGIN	CHAR	1	0	Rates Origin
25	TAKE_RATE_INFO_OBJECT	☐	CGPL_SEM_KEYFIGURE	RSIOBJNM	CHAR	30	0	Key Figure
26	OI_CAP_INFO_OBJECT	☐	CGPL_SEM_KEYFIGURE	RSIOBJNM	CHAR	30	0	Key Figure
27	EXCEPTION_EXISTS	☐	CRM_MKTGS_EXCEPTION_EXISTS	XFELD	CHAR	1	0	Flag indicating Trade Spend Exceptions Exists
28	TGR_ENABLED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
29	BOVER	☐	/BON/BOVER	/BON/BOVER	CHAR	1	0	Rebate Procedure
30	SPEND_USAGE	☐	CRM_MKTPL_COST_TYPE_USAGE	CRM_MKTPL_COST_TYPE_USAGE	CHAR	1	0	Trade Spend Usage
31	START_DATE_DATS	☐	CRM_MKTGS_START_DATE	DATS	DATS	8	0	Start Date
32	END_DATE_DATS	☐	CRM_MKTGS_END_DATE	DATS	DATS	8	0	End Date
33	.INCLUDE	☐				0	0	CRM Marketing Planning: Include Structure Trade Spend
34	COST_TYPE	☐	CRM_MKTPL_COST_TYPE	CRM_MKTPL_COST_TYPE	CHAR	4	0	Spend Type	CRMC_MKTPL_COST
35	COST_CATEGORY	☐	CRM_MKTPL_COST_CAT	CRM_MKTPL_COST_CAT	CHAR	30	0	Spend Category	CRMC_MKTPL_COS0
36	SPEND_METHOD	☐	CRM_MKTPL_SPEND_METHOD	CRM_MKTPL_SPEND_METHOD	CHAR	10	0	Spend Method for Key Figure Planning	CRMC_MKTPL_COS1
37	PMNT_TYPE	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	CRMC_BUAG_PAYM
38	DISC_METHOD	☐	CRM_MKTPL_DISC_METH	CRM_MKTPL_DISC_METH	CHAR	4	0	Discount Method	CRMC_MKTPL_DISC
39	VOLUME	☐	CRM_MKTPL_VOLUME	CRM_MKTPL_VOLUME	CHAR	4	0	Related Volume	CRMC_MKTPL_COS5
40	PARTICIP_RATE	☐	CRM_MKTPL_PARTICIP_RATE	CRM_MKTPL_PARTICIP_RATE	CHAR	3	0	Participation Rate (0-100%)
41	START_DATE	☐	CRM_MKTPL_TSPEND_STARTDATE	BCOS_TSTMP	DEC	15	0	Trade Spend Start Date
42	END_DATE	☐	CRM_MKTPL_TSPEND_ENDDATE	BCOS_TSTMP	DEC	15	0	Trade Spend End Date
43	COND_GENERATED	☐	CRM_MKTPL_COND_GENERATED	CRM_MKTPL_COND_GENERATED	CHAR	1	0	Condition Generated (Indicator)
44	REBATE_STAT	☐	CRM_MKTPL_REBATE_STAT	CRM_MKTPL_REBATE_STAT	CHAR	1	0	Rebate Status
45	DATES_MODIFIED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
46	TAKE_RATE	☐	CRM_MKTGS_TAKE_RATE	CRM_MKTGS_TAKE_RATE	NUMC	3	0	Take Rate
47	SPEND_VALUE	☐	CRM_MKTGS_SPEND_VALUE	CRM_MKTGS_SPEND_VALUE	CURR	20	2	Spend Value
48	OI_CAP	☐	CRM_MKTGS_OI_CAP	CRM_MKTGS_OI_CAP	CURR	20	2	Off Invoice Cap
49	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
50	OI_CAP_CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
51	DATE_RANGE_TYPE	☐	CRM_MKTGS_IB_DATE_TYPE		CHAR	10	0	Date type for the IBOM layer
52	DATE_RANGE_ID	☐	CRM_MKTPL_DATE_ID	CRM_MKTPL_DATE_ID	NUMC	2	0	Unique Identifier for Additional Date Ranges
53	.INCLUDE	☐				0	0	Extensibility Include - Trade Spend
54	MKTPL_TRADESPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
55	.INCLUDE	☐				0	0	Fund Association
56	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
57	FUND_DESC	☐	CRM_FM_FND_FUND_TYPE_DESC	TEXT40	CHAR	40	0	Fund Type Description
58	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
59	.INCLUDE	☐				0	0	Include structure for Claims related data
60	SETTL_CALENDAR	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
61	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
62	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_IB_TPM_TRADE_SPEND	COST_CATEGORY	CRMC_MKTPL_COS0	COST_CATEGORY
2	CRMS_MKTPL_IB_TPM_TRADE_SPEND	COST_TYPE	CRMC_MKTPL_COST	COST_TYPE
3	CRMS_MKTPL_IB_TPM_TRADE_SPEND	DISC_METHOD	CRMC_MKTPL_DISC	DISC_METHOD
4	CRMS_MKTPL_IB_TPM_TRADE_SPEND	PMNT_TYPE	CRMC_BUAG_PAYM	PAYM_METH
5	CRMS_MKTPL_IB_TPM_TRADE_SPEND	SPEND_METHOD	CRMC_MKTPL_COS1	SPEND_METHOD
6	CRMS_MKTPL_IB_TPM_TRADE_SPEND	VOLUME	CRMC_MKTPL_COS5	VOLUME

History

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