SAP ABAP Table CRMC_MCAL_TS (Customizing table for Trade Spends)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-CAL (Application Component) Marketing Calendar
     ⤷ CRM_MCAL_CUSTOMIZING (Package) Marketing Calendar Customizing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_MCAL_TS	Table Relationship Diagram
Short Description	Customizing table for Trade Spends

Delivery and Maintenance

Pool/cluster
Delivery Class	G	Customizing table, protected against SAP Upd., only INS all.
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	TRADE_SPEND_ID	☑	CRM_MCAL_TS_ID	CRM_MCAL_TS_ID	CHAR	8	0	Trade Spend ID for Trade Spend Customizing Table
3	SPEND_TYPE	☐	CRM_MKTPL_COST_TYPE	CRM_MKTPL_COST_TYPE	CHAR	4	0	Spend Type	CRMC_MKTPL_COST
4	SPEND_CATEGORY	☐	CRM_MKTPL_COST_CAT	CRM_MKTPL_COST_CAT	CHAR	30	0	Spend Category	CRMC_MKTPL_COS0
5	SPEND_METHOD	☐	CRM_MKTPL_SPEND_METHOD	CRM_MKTPL_SPEND_METHOD	CHAR	10	0	Spend Method for Key Figure Planning	CRMC_MKTPL_COS1
6	COLOR_ID	☐	CRM_MCAL_COLOR_ID	CRM_MCAL_COLOR_ID	CHAR	10	0	Color ID	CRMC_MCAL_COLOR
7	REPORT_ID	☐	CRM_MCAL_REPORT_ID	CHAR42	CHAR	42	0	BW Report
8	REPORT_ID_IMP	☐	CRM_MCAL_REPORT_ID	CHAR42	CHAR	42	0	BW Report

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_MCAL_TS	COLOR_ID	CRMC_MCAL_COLOR	COLOR_ID	REF
2	CRMC_MCAL_TS	SPEND_CATEGORY	CRMC_MKTPL_COS0	COST_CATEGORY	KEY
3	CRMC_MCAL_TS	SPEND_METHOD	CRMC_MKTPL_COS1	SPEND_METHOD	KEY
4	CRMC_MCAL_TS	SPEND_TYPE	CRMC_MKTPL_COST	COST_TYPE	KEY

History

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