SAP ABAP View V_KPI_USER_GATES (Personalized Threshold Values and Target Value for KPIs)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO (Application Component) Logistics - General
     ⤷ PLANT_MANAGER (Package) Plant Manager

Basic Data

View Type	C	Maintenance View
Maintenance View	V_KPI_USER_GATES
Short Description	Personalized Threshold Values and Target Value for KPIs
Root table	EPM_USER_GATES	User-Dependent Settings for Individual Threshold Values

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EPM_USER_GATES	EPM_USER_GATES
2	EPM_KPI_USER	EPM_USER_GATES	KPI_ID	E
3	EPM_KPI_CATALOG	EPM_KPI_USER	KPI_ID	E
4	EPM_KPI_CATALOGT	EPM_KPI_CATALOG	KPI_ID	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EPM_USER_GATES	MANDT	R	☐	MANDT	☐	Client
2	UNAME	EPM_USER_GATES	UNAME	S	☐	XUBNAME	☐	User Name in User Master Record
3	KPI_ID	EPM_USER_GATES	KPI_ID		☐	EPM_KPI_ID	☐	Technical Name of KPI
4	TEXT	EPM_KPI_CATALOGT	TEXT	R	☐	EPM_KPI_TEXT	☐	KPI Description
5	TEXT_LONG	EPM_KPI_CATALOGT	TEXT_LONG	R	☐	EPM_KPI_TEXT_LONG	☐	KPI Description
6	KPI_TYPE	EPM_KPI_CATALOG	KPI_TYPE	R	☐	EPM_KPI_TYPE	☐	KPI Type
7	CAT_ID	EPM_KPI_CATALOG	CAT_ID	R	☐	EPM_CAT_ID	☐	Technical Name for KPI Category
8	SOURCE_TYPE	EPM_KPI_CATALOG	SOURCE_TYPE	R	☐	EPM_KPI_SOURCE_TYPE	☐	Type of Source System for KPI Value
9	SOURCE	EPM_KPI_CATALOG	SOURCE	R	☐	EPM_KPI_SOURCE	☐	Logical Source System for KPI Value
10	UNIT	EPM_KPI_CATALOG	UNIT	R	☐	MEINH	☐	Unit of Measure for Display
11	CURR	EPM_KPI_CATALOG	CURR	R	☐	WAERS	☐	Currency Key
12	MIN_VALUE	EPM_KPI_CATALOG	MIN_VALUE	R	☐	EPM_MIN_VALUE	☐	Minimum Value of KPI
13	R2YGATE_DEF	EPM_KPI_CATALOG	R2YGATE	R	☐	EPM_GATE_VALUE_R2Y	☐	Threshold Value: Red to Yellow
14	R2YGATE	EPM_USER_GATES	R2YGATE		☐	EPM_GATE_VALUE_R2Y	☐	Threshold Value: Red to Yellow
15	Y2GGATE_DEF	EPM_KPI_CATALOG	Y2GGATE	R	☐	EPM_GATE_VALUE_Y2G	☐	Threshold Value: Yellow to Green
16	Y2GGATE	EPM_USER_GATES	Y2GGATE		☐	EPM_GATE_VALUE_Y2G	☐	Threshold Value: Yellow to Green
17	TARGET_DEF	EPM_KPI_CATALOG	TARGET	R	☐	EPM_TARGET_VALUE	☐	Target Value for KPI
18	TARGET	EPM_USER_GATES	TARGET		☐	EPM_TARGET_VALUE	☐	Target Value for KPI
19	G2YGATE_DEF	EPM_KPI_CATALOG	G2YGATE	R	☐	EPM_GATE_VALUE_G2Y	☐	Threshold Value: Green to Yellow
20	G2YGATE	EPM_USER_GATES	G2YGATE		☐	EPM_GATE_VALUE_G2Y	☐	Threshold Value: Green to Yellow
21	Y2RGATE_DEF	EPM_KPI_CATALOG	Y2RGATE	R	☐	EPM_GATE_VALUE_Y2R	☐	Threshold Value: Yellow to Red
22	Y2RGATE	EPM_USER_GATES	Y2RGATE		☐	EPM_GATE_VALUE_Y2R	☐	Threshold Value: Yellow to Red
23	MAX_VALUE	EPM_KPI_CATALOG	MAX_VALUE	R	☐	EPM_MAX_VALUE	☐	Maximum Value of KPI

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	20130529
SAP Release Created in	500