SAP ABAP Table V_KPI_USER_GATES (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_KPI_USER_GATES	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	UNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	EPM_KPI_USER
3	KPI_ID	☑	EPM_KPI_ID	EPM_KPI_ID	CHAR	30	0	Technical Name of KPI	EPM_KPI_USER
4	TEXT	☐	EPM_KPI_TEXT	TEXT60	CHAR	60	0	KPI Description
5	TEXT_LONG	☐	EPM_KPI_TEXT_LONG	TEXT255	CHAR	255	0	KPI Description
6	KPI_TYPE	☐	EPM_KPI_TYPE	EPM_KPI_TYPE	CHAR	1	0	KPI Type
7	CAT_ID	☐	EPM_CAT_ID	EPM_CAT_ID	CHAR	30	0	Technical Name for KPI Category	EPM_KPI_CATEGORY
8	SOURCE_TYPE	☐	EPM_KPI_SOURCE_TYPE	EPM_SOURCE_TYPE	CHAR	3	0	Type of Source System for KPI Value
9	SOURCE	☐	EPM_KPI_SOURCE	LOGSYS	CHAR	10	0	Logical Source System for KPI Value	TBDLS
10	UNIT	☐	MEINH	MEINS	UNIT	3	0	Unit of Measure for Display	T006
11	CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
12	MIN_VALUE	☐	EPM_MIN_VALUE	EPM_VALUE	DEC	15	3	Minimum Value of KPI
13	R2YGATE_DEF	☐	EPM_GATE_VALUE_R2Y	EPM_VALUE	DEC	15	3	Threshold Value: Red to Yellow
14	R2YGATE	☐	EPM_GATE_VALUE_R2Y	EPM_VALUE	DEC	15	3	Threshold Value: Red to Yellow
15	Y2GGATE_DEF	☐	EPM_GATE_VALUE_Y2G	EPM_VALUE	DEC	15	3	Threshold Value: Yellow to Green
16	Y2GGATE	☐	EPM_GATE_VALUE_Y2G	EPM_VALUE	DEC	15	3	Threshold Value: Yellow to Green
17	TARGET_DEF	☐	EPM_TARGET_VALUE	EPM_VALUE	DEC	15	3	Target Value for KPI
18	TARGET	☐	EPM_TARGET_VALUE	EPM_VALUE	DEC	15	3	Target Value for KPI
19	G2YGATE_DEF	☐	EPM_GATE_VALUE_G2Y	EPM_VALUE	DEC	15	3	Threshold Value: Green to Yellow
20	G2YGATE	☐	EPM_GATE_VALUE_G2Y	EPM_VALUE	DEC	15	3	Threshold Value: Green to Yellow
21	Y2RGATE_DEF	☐	EPM_GATE_VALUE_Y2R	EPM_VALUE	DEC	15	3	Threshold Value: Yellow to Red
22	Y2RGATE	☐	EPM_GATE_VALUE_Y2R	EPM_VALUE	DEC	15	3	Threshold Value: Yellow to Red
23	MAX_VALUE	☐	EPM_MAX_VALUE	EPM_VALUE	DEC	15	3	Maximum Value of KPI

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_KPI_USER_GATES	CAT_ID	EPM_KPI_CATEGORY	CAT_ID
2	V_KPI_USER_GATES	CURR	TCURC	WAERS
3	V_KPI_USER_GATES	KPI_ID	EPM_KPI_USER	KPI_ID	KEY	1	CN
4	V_KPI_USER_GATES	MANDT	T000	MANDT
5	V_KPI_USER_GATES	SOURCE	TBDLS	LOGSYS
6	V_KPI_USER_GATES	UNAME	EPM_KPI_USER	UNAME
7	V_KPI_USER_GATES	UNIT	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in