SAP ABAP Table CRMD_MKTGS_TSPEX (Trade Spend Exceptions Assignments table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTGS_TRADESPEND_EXCEPTION (Package) Trade Spend Exceptions

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_MKTGS_TSPEX	Table Relationship Diagram
Short Description	Trade Spend Exceptions Assignments table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	MKTGS OL: Generic Assignment Primary Key Include
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
4	.INCLUDE	☐				0	0	MKTGS OL: Key include for sub-assignments
5	ASSIGN_GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
6	PROD_DIM_GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
7	.INCLUDE	☐				0	0	CRM Trade Promotion: Include Structure Trade Spend Exception
8	PROD_DIM_TYPE	☐	CRM_MKTPL_PRODUCT_TYPE	CRM_MKTPL_PRODUCT_TYPE	CHAR	2	0	Product Level for Generating Conditions
9	TAKE_RATE	☐	CRM_MKTGS_TAKE_RATE	CRM_MKTGS_TAKE_RATE	NUMC	3	0	Take Rate
10	SPEND_VALUE	☐	CRM_MKTGS_SPEND_VALUE	CRM_MKTGS_SPEND_VALUE	CURR	20	2	Spend Value
11	EXCLUDE_FLAG	☐	CRM_MKTPL_PROD_SEL	FLAG	CHAR	1	0	Product Exclusion Checkbox
12	START_DATE	☐	CRM_MKTPL_TSPEND_STARTDATE	BCOS_TSTMP	DEC	15	0	Trade Spend Start Date
13	END_DATE	☐	CRM_MKTPL_TSPEND_ENDDATE	BCOS_TSTMP	DEC	15	0	Trade Spend End Date
14	OI_CAP	☐	CRM_MKTGS_OI_CAP	CRM_MKTGS_OI_CAP	CURR	20	2	Off Invoice Cap
15	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
16	OI_CAP_CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*

History

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