SAP ABAP View CRMV_MKTPL_CTEXP (Assign Expense Types and Accrual Profiles to MDF Initiative)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-MDF (Application Component) Marketing Development Funds
     ⤷ CRM_MKTPL_MDF_BW (Package) Package for BW development for MDF objects

Basic Data

View Type	D	Database View
Database View	CRMV_MKTPL_CTEXP
Short Description	Assign Expense Types and Accrual Profiles to MDF Initiative
Root table	CRMC_MKTPL_CTYEX	Assign Expense Types and Accrual Profiles to MDF Initiative

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMC_MKTPL_CTYEX	CRMC_MKTPL_CTYEX
2	CRMC_FM_FND_EXP
3	CRMC_MKTPL_CTYPE
4	CRMC_MKTPL_CTYPT
5	CRMC_FM_FND_EXPT
6	CRMC_FM_ACL_PF
7	CRMC_FM_ACL_PFT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMC_FM_FND_EXP	CLIENT	JL	EQ				0	0
2	CRMC_MKTPL_CTYEX	CLIENT	JR	EQ			AND	0	0
3	CRMC_FM_FND_EXP	EXPENSE_TYPE	JL	EQ				0	0
4	CRMC_MKTPL_CTYEX	EXPENSE_TYPE	JR	EQ			AND	0	0
5	CRMC_MKTPL_CTYPE	MANDT	JL	EQ				0	0
6	CRMC_MKTPL_CTYEX	CLIENT	JR	EQ			AND	0	0
7	CRMC_MKTPL_CTYPE	CAMP_TYPE	JL	EQ				0	0
8	CRMC_MKTPL_CTYEX	CAMP_TYPE	JR	EQ			AND	0	0
9	CRMC_MKTPL_CTYPE	MANDT	JL	EQ				0	0
10	CRMC_MKTPL_CTYPT	MANDT	JR	EQ			AND	0	0
11	CRMC_MKTPL_CTYPE	CAMP_TYPE	JL	EQ				0	0
12	CRMC_MKTPL_CTYPT	CAMP_TYPE	JR	EQ			AND	0	0
13	CRMC_FM_FND_EXP	CLIENT	JL	EQ				0	0
14	CRMC_FM_FND_EXPT	CLIENT	JR	EQ			AND	0	0
15	CRMC_FM_FND_EXP	EXPENSE_TYPE	JL	EQ				0	0
16	CRMC_FM_FND_EXPT	EXPENSE_TYPE	JR	EQ			AND	0	0
17	CRMC_FM_ACL_PF	CLIENT	JL	EQ				0	0
18	CRMC_MKTPL_CTYEX	CLIENT	JR	EQ			AND	0	0
19	CRMC_FM_ACL_PF	ID	JL	EQ				0	0
20	CRMC_MKTPL_CTYEX	ACC_PROFILE	JR	EQ			AND	0	0
21	CRMC_FM_ACL_PF	CLIENT	JL	EQ				0	0
22	CRMC_FM_ACL_PFT	CLIENT	JR	EQ			AND	0	0
23	CRMC_FM_ACL_PF	ID	JL	EQ				0	0
24	CRMC_FM_ACL_PFT	ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMC_MKTPL_CTYEX	CLIENT		☐	MANDT	☐	Client
2	CAMP_TYPE	CRMC_MKTPL_CTYEX	CAMP_TYPE		☐	CRM_MKTPL_CAMPTYPE	☐	Type
3	EXPENSE_TYPE	CRMC_MKTPL_CTYEX	EXPENSE_TYPE		☐	CRM_FM_EXPENSE_TYPE	☐	Expense Type
4	ACC_PROFILE	CRMC_MKTPL_CTYEX	ACC_PROFILE		☐	CRM_FM_ACL_PROFILE_ID	☐	Accrual Profile ID
5	ACC_DATE	CRMC_MKTPL_CTYEX	ACC_DATE		☐	CRM_MKTPL_DATE_MID	☐	Mixed Date ID

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		Display/Maintenance Allowed with Restrictions

History

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