SAP ABAP Table CRMD_MKTPL_TSP (Trade Spends assigned to a Causal)

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	TRANSP	Transparent table
Transparent table	CRMD_MKTPL_TSP	Table Relationship Diagram
Short Description	Trade Spends assigned to a Causal

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	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	ASSIGN_GUID	☐	CRMT_ASSIGN_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of assignment	CRMD_MKTPL_CAU
5	TRADE_SPEND_GUID	☐	CRM_MKTPL_CAU_SPEND_GUID	SYSUUID	RAW	16	0	Trade Spend GUID
6	COST_TYPE	☐	CRM_MKTPL_COST_TYPE	CRM_MKTPL_COST_TYPE	CHAR	4	0	Spend Type	*
7	COST_CATEGORY	☐	CRM_MKTPL_COST_CAT	CRM_MKTPL_COST_CAT	CHAR	30	0	Spend Category	*
8	SPEND_METHOD	☐	CRM_MKTPL_SPEND_METHOD	CRM_MKTPL_SPEND_METHOD	CHAR	10	0	Spend Method for Key Figure Planning	*
9	DISC_METHOD	☐	CRM_MKTPL_DISC_METH	CRM_MKTPL_DISC_METH	CHAR	4	0	Discount Method	*
10	CAUSAL_TYPE	☐	CRM_MKTPL_CAU_TYPE	CRM_MKTPL_CAU_TYPE	CHAR	4	0	Causal Factor Type
11	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type

Foreign Keys

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

History

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