SAP ABAP Table V_KPI_CATALOG (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_KPI_CATALOG	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	KPI_ID	☑	EPM_KPI_ID	EPM_KPI_ID	CHAR	30	0	Technical Name of KPI
3	TEXT	☐	EPM_KPI_TEXT	TEXT60	CHAR	60	0	KPI Description
4	TEXT_LONG	☐	EPM_KPI_TEXT_LONG	TEXT255	CHAR	255	0	KPI Description
5	CAT_ID	☐	EPM_CAT_ID	EPM_CAT_ID	CHAR	30	0	Technical Name for KPI Category	EPM_KPI_CATEGORY
6	KPI_TYPE	☐	EPM_KPI_TYPE	EPM_KPI_TYPE	CHAR	1	0	KPI Type
7	SOURCE_TYPE	☐	EPM_KPI_SOURCE_TYPE	EPM_SOURCE_TYPE	CHAR	3	0	Type of Source System for KPI Value
8	SOURCE	☐	EPM_KPI_SOURCE	LOGSYS	CHAR	10	0	Logical Source System for KPI Value	TBDLS
9	BW_AN_PROCESS	☐	EPM_AN_PROCESS	CHAR30	CHAR	30	0	Analysis Process from Business Information Warehouse
10	BW_WEBTEMPLATE	☐	EPM_WEBTEMPLATE	CHAR30	CHAR	30	0	BW Web Template (Business Warehouse)
11	EXT_URL	☐	EPM_URL	TEXT255	CHAR	255	0	URL Address for Detail View of External Source System
12	EPM_PROGRAM	☐	EPM_PROGRAM	PROGRAMM	CHAR	40	0	R/3 and mySAP ERP Program for Generating Key Figure
13	EPM_VARIANT	☐	EPM_VARIANT	VARIANT	CHAR	14	0	Variant for R/3 Program that Determines KPIs
14	UNIT	☐	MEINH	MEINS	UNIT	3	0	Unit of Measure for Display	T006
15	CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
16	MIN_VALUE	☐	EPM_MIN_VALUE	EPM_VALUE	DEC	15	3	Minimum Value of KPI
17	R2YGATE	☐	EPM_GATE_VALUE_R2Y	EPM_VALUE	DEC	15	3	Threshold Value: Red to Yellow
18	Y2GGATE	☐	EPM_GATE_VALUE_Y2G	EPM_VALUE	DEC	15	3	Threshold Value: Yellow to Green
19	TARGET	☐	EPM_TARGET_VALUE	EPM_VALUE	DEC	15	3	Target Value for KPI
20	G2YGATE	☐	EPM_GATE_VALUE_G2Y	EPM_VALUE	DEC	15	3	Threshold Value: Green to Yellow
21	Y2RGATE	☐	EPM_GATE_VALUE_Y2R	EPM_VALUE	DEC	15	3	Threshold Value: Yellow to Red
22	MAX_VALUE	☐	EPM_MAX_VALUE	EPM_VALUE	DEC	15	3	Maximum Value of KPI
23	PERIOD	☐	EPM_PERIOD	EPM_PERIOD	CHAR	1	0	Period
24	RANGE_PER_PERIOD	☐	EPM_RANGE_PER_PERIOD	NUMC3	NUMC	3	0	Number of Periods

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_KPI_CATALOG	CAT_ID	EPM_KPI_CATEGORY	CAT_ID
2	V_KPI_CATALOG	CURR	TCURC	WAERS
3	V_KPI_CATALOG	MANDT	T000	MANDT
4	V_KPI_CATALOG	SOURCE	TBDLS	LOGSYS
5	V_KPI_CATALOG	UNIT	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in