SAP ABAP Table CRMS_MKTPL_CAU_TSP (Trade Spend Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM-CAU (Application Component) Causals
     ⤷ CRM_MKTPL_ASSIGN_CAUSAL (Package) CRM Marketing Planner : Causal Assignment

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_CAU_TSP	Table Relationship Diagram
Short Description	Trade Spend Structure

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	.INCLUDE	☐				0	0	Trade Spends assigned to a Causal
2	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment Primary Key Include
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
5	ASSIGN_GUID	☐	CRMT_ASSIGN_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of assignment	CRMD_MKTPL_CAU
6	TRADE_SPEND_GUID	☐	CRM_MKTPL_CAU_SPEND_GUID	SYSUUID	RAW	16	0	Trade Spend GUID
7	COST_TYPE	☐	CRM_MKTPL_COST_TYPE	CRM_MKTPL_COST_TYPE	CHAR	4	0	Spend Type	*
8	COST_CATEGORY	☐	CRM_MKTPL_COST_CAT	CRM_MKTPL_COST_CAT	CHAR	30	0	Spend Category	*
9	SPEND_METHOD	☐	CRM_MKTPL_SPEND_METHOD	CRM_MKTPL_SPEND_METHOD	CHAR	10	0	Spend Method for Key Figure Planning	*
10	DISC_METHOD	☐	CRM_MKTPL_DISC_METH	CRM_MKTPL_DISC_METH	CHAR	4	0	Discount Method	*
11	CAUSAL_TYPE	☐	CRM_MKTPL_CAU_TYPE	CRM_MKTPL_CAU_TYPE	CHAR	4	0	Causal Factor Type
12	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
13	EXPENSE_TYPE_DESC	☐	CRM_FM_EXPENSE_TYPE_DESC	TEXT40	CHAR	40	0	Expense Type Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_CAU_TSP	ASSIGN_GUID	CRMD_MKTPL_CAU	CLIENT

History

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