SAP ABAP View V_CRM_MKTPL_COS3 (Spnd Meth to Spnd Type and Spnd Cat relationship)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRMC_MKTPL_KPI_INTEGRATION (Package) Customizing Marketing Planner - KPI Integration

Basic Data

View Type	C	Maintenance View
Maintenance View	V_CRM_MKTPL_COS3
Short Description	Spnd Meth to Spnd Type and Spnd Cat relationship
Root table	CRMC_MKTPL_COS3	CRM Marketing: spend method to cost type association

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMC_MKTPL_COS3	CRMC_MKTPL_COS3
2	CRMC_MKTPL_COS1	CRMC_MKTPL_COS3	SPEND_METHOD	E
3	CRMC_MKTPL_COS2	CRMC_MKTPL_COS3	COST_CATEGORY	E
4	CRMC_MKTPL_COS1T	CRMC_MKTPL_COS1	SPEND_METHOD	I
5	CRMC_MKTPL_COS0	CRMC_MKTPL_COS2	COST_CATEGORY	E
6	CRMC_MKTPL_COST	CRMC_MKTPL_COS2	COST_TYPE	E
7	CRMC_MKTPL_COS0T	CRMC_MKTPL_COS0	COST_CATEGORY	I
8	CRMC_MKTPL_COSTT	CRMC_MKTPL_COST	COST_TYPE	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMC_MKTPL_COS3	APPLICATION		EQ	'MKT'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMC_MKTPL_COS3	CLIENT		☐	MANDT	☐	Client
2	APPLICATION	CRMC_MKTPL_COS3	APPLICATION	H	☐	CGPL_APPLICATION_TYPE	☐	Application in Project Planning
3	COST_TYPE	CRMC_MKTPL_COS3	COST_TYPE	S	☐	CRM_MKTPL_COST_TYPE	☐	Spend Type
4	SPEND_METHOD	CRMC_MKTPL_COS3	SPEND_METHOD		☐	CRM_MKTPL_SPEND_METHOD	☐	Spend Method for Key Figure Planning
5	COST_CATEGORY	CRMC_MKTPL_COS3	COST_CATEGORY	S	☐	CRM_MKTPL_COST_CAT	☐	Spend Category
6	COST_TYPE_TEXT	CRMC_MKTPL_COSTT	COST_TYPE_TEXT	S	☐	CRM_MKTPL_COST_TEXT	☐	Spend Type
7	COST_CAT_TEXT	CRMC_MKTPL_COS0T	COST_CAT_TEXT	S	☐	CRM_MKTPL_COST_CAT_DESC	☐	Spend Category
8	SPEND_METHOD_TXT	CRMC_MKTPL_COS1T	SPEND_METHOD_TXT	R	☐	CRM_MKTPL_SPEND_METHOD_TEXT	☐	Spend Method Description
9	TAKE_RATE_KF	CRMC_MKTPL_COS3	TAKE_RATE_KF		☐	CRM_MKTPL_TAKE_RATE_KEYFIGURE	☐	TPM: Take Rate Key Figure
10	OI_CAP_KF	CRMC_MKTPL_COS3	OI_CAP_KF		☐	CRM_MKTPL_OI_CAP_KEYFIGURE	☐	TPM: Off Invoice Cap Key Figure
11	PREPOPULATE	CRMC_MKTPL_COS3	PREPOPULATE		☐	CRM_MKTPL_TRADE_SPEND_PRE_POPU	☐	Prepopulate Trade Spend Indicator

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

History

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