SAP ABAP Table EPM_TS_KPI_CAT (KPIs Available in Company Catalog)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	EPM_TS_KPI_CAT	Table Relationship Diagram
Short Description	KPIs Available in Company Catalog

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	KPIs Available in Company Catalog
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KPI_ID	☐	EPM_KPI_ID	EPM_KPI_ID	CHAR	30	0	Technical Name of KPI
4	CAT_ID	☐	EPM_CAT_ID	EPM_CAT_ID	CHAR	30	0	Technical Name for KPI Category	EPM_KPI_CATEGORY
5	KPI_TYPE	☐	EPM_KPI_TYPE	EPM_KPI_TYPE	CHAR	1	0	KPI Type
6	SOURCE_TYPE	☐	EPM_KPI_SOURCE_TYPE	EPM_SOURCE_TYPE	CHAR	3	0	Type of Source System for KPI Value
7	SOURCE	☐	EPM_KPI_SOURCE	LOGSYS	CHAR	10	0	Logical Source System for KPI Value	TBDLS
8	BW_AN_PROCESS	☐	EPM_AN_PROCESS	CHAR30	CHAR	30	0	Analysis Process from Business Information Warehouse
9	BW_WEBTEMPLATE	☐	EPM_WEBTEMPLATE	CHAR30	CHAR	30	0	BW Web Template (Business Warehouse)
10	EXT_URL	☐	EPM_URL	TEXT255	CHAR	255	0	URL Address for Detail View of External Source System
11	EPM_PROGRAM	☐	EPM_PROGRAM	PROGRAMM	CHAR	40	0	R/3 and mySAP ERP Program for Generating Key Figure	*
12	EPM_VARIANT	☐	EPM_VARIANT	VARIANT	CHAR	14	0	Variant for R/3 Program that Determines KPIs	*
13	TARGET	☐	EPM_TARGET_VALUE	EPM_VALUE	DEC	15	3	Target Value for KPI
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	G2YGATE	☐	EPM_GATE_VALUE_G2Y	EPM_VALUE	DEC	15	3	Threshold Value: Green to Yellow
20	Y2RGATE	☐	EPM_GATE_VALUE_Y2R	EPM_VALUE	DEC	15	3	Threshold Value: Yellow to Red
21	MAX_VALUE	☐	EPM_MAX_VALUE	EPM_VALUE	DEC	15	3	Maximum Value of KPI
22	RANGE_PER_PERIOD	☐	EPM_RANGE_PER_PERIOD	NUMC3	NUMC	3	0	Number of Periods
23	PERIOD	☐	EPM_PERIOD	EPM_PERIOD	CHAR	1	0	Period
24	KPINAME	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
25	TEXT_LONG	☐	TEXT255	TEXT255	CHAR	255	0	Text, 255 Characters

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	500