SAP ABAP View V_CRMMKTPL_KPIMB (SKM - database view)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-ST-KFP (Application Component) Key Figure Planning
     ⤷ CRM_MKTPL_KPI_INTEGRATION (Package) CRM Marketing Planner: KPI Integration

Basic Data

View Type	D	Database View
Database View	V_CRMMKTPL_KPIMB
Short Description	SKM - database view
Root table	CRMC_MKTPL_SKM	Success Key Measure - relations

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMC_MKTPL_SKM	CRMC_MKTPL_SKM
2	CRMC_MKTPL_CTYOB
3	CRMC_MKTPL_SKM_K
4	CRMC_MKTPL_CTYPE
5	CRMC_MKTPL_OBJTV
6	CRMC_MKTPL_SKM_T
7	CRMC_MKTPL_CTYPT
8	CRMC_MKTPL_OBJTT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMC_MKTPL_CTYOB	CLIENT	JL	EQ				0	0
2	CRMC_MKTPL_SKM	MANDT	JR	EQ			AND	0	0
3	CRMC_MKTPL_CTYOB	CAMP_TYPE	JL	EQ				0	0
4	CRMC_MKTPL_SKM	CAMP_TYPE	JR	EQ			AND	0	0
5	CRMC_MKTPL_CTYOB	OBJECTIVE	JL	EQ				0	0
6	CRMC_MKTPL_SKM	OBJECTIVE	JR	EQ			AND	0	0
7	CRMC_MKTPL_SKM_K	MANDT	JL	EQ				0	0
8	CRMC_MKTPL_SKM	MANDT	JR	EQ			AND	0	0
9	CRMC_MKTPL_SKM_K	KPI	JL	EQ				0	0
10	CRMC_MKTPL_SKM	KPI	JR	EQ			AND	0	0
11	CRMC_MKTPL_CTYPE	MANDT	JL	EQ				0	0
12	CRMC_MKTPL_CTYOB	CLIENT	JR	EQ			AND	0	0
13	CRMC_MKTPL_CTYPE	CAMP_TYPE	JL	EQ				0	0
14	CRMC_MKTPL_CTYOB	CAMP_TYPE	JR	EQ			AND	0	0
15	CRMC_MKTPL_OBJTV	MANDT	JL	EQ				0	0
16	CRMC_MKTPL_CTYOB	CLIENT	JR	EQ			AND	0	0
17	CRMC_MKTPL_OBJTV	OBJECTIVE	JL	EQ				0	0
18	CRMC_MKTPL_CTYOB	OBJECTIVE	JR	EQ			AND	0	0
19	CRMC_MKTPL_SKM_K	MANDT	JL	EQ				0	0
20	CRMC_MKTPL_SKM_T	MANDT	JR	EQ			AND	0	0
21	CRMC_MKTPL_SKM_K	KPI	JL	EQ				0	0
22	CRMC_MKTPL_SKM_T	KPI	JR	EQ			AND	0	0
23	CRMC_MKTPL_CTYPE	MANDT	JL	EQ				0	0
24	CRMC_MKTPL_CTYPT	MANDT	JR	EQ			AND	0	0
25	CRMC_MKTPL_CTYPE	CAMP_TYPE	JL	EQ				0	0
26	CRMC_MKTPL_CTYPT	CAMP_TYPE	JR	EQ			AND	0	0
27	CRMC_MKTPL_OBJTV	MANDT	JL	EQ				0	0
28	CRMC_MKTPL_OBJTT	MANDT	JR	EQ			AND	0	0
29	CRMC_MKTPL_OBJTV	OBJECTIVE	JL	EQ				0	0
30	CRMC_MKTPL_OBJTT	OBJECTIVE	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	CRMC_MKTPL_SKM	MANDT		☐	MANDT	☐	Client
2	CAMP_TYPE	CRMC_MKTPL_SKM	CAMP_TYPE		☐	CRM_MKTPL_CAMPTYPE	☐	Type
3	OBJECTIVE	CRMC_MKTPL_SKM	OBJECTIVE		☐	CRM_MKTPL_OBJECTIVE	☐	Objective
4	KPI	CRMC_MKTPL_SKM	KPI		☐	CGPL_UMK_Y_MEAS	☐	Key Figure
5	LANGU	CRMC_MKTPL_SKM_T	LANGU		☐	SPRAS	☐	Language Key
6	KPI_TEXT	CRMC_MKTPL_SKM_T	KPI_TEXT		☐	CRM_MKTPL_KPI_TEXT	☐	Measure Text
7	UNIT_TYPE	CRMC_MKTPL_SKM_K	UNIT_TYPE		☐	CRM_MKTPL_KPI_UNIT_TYPE	☐	KPI: Unit Measure Type

Maintenance Status

Access

☑   read only

☐   read and change

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

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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