SAP Table EPM_KPI_CATALOGH
History of KPIs in KPI Catalog
EPM_KPI_CATALOGH (History of KPIs in KPI Catalog) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link EPM_KPI_CATALOGH to other SAP tables.
EPM_KPI_CATALOGH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||
|
KPI_ID
Technical Name of KPI
|
EPM_KPI_ID |
CHAR
|
30 | 0 | ||||||||||||||
|
KPI_TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
CAT_ID
Technical Name for KPI Category
|
EPM_CAT_ID |
CHAR
|
30 | 0 | ||||||||||||||
|
KPI_TYPE
KPI Type
|
EPM_KPI_TYPE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
SOURCE_TYPE
Type of Source System for KPI Value
|
EPM_KPI_SOURCE_TYPE |
CHAR
|
3 | 0 | ||||||||||||||
|
||||||||||||||||||
|
SOURCE
Logical Source System for KPI Value
|
EPM_KPI_SOURCE |
CHAR
|
10 | 0 | ||||||||||||||
|
BW_AN_PROCESS
Analysis Process from Business Information Warehouse
|
EPM_AN_PROCESS |
CHAR
|
30 | 0 | ||||||||||||||
|
BW_WEBTEMPLATE
BW Web Template (Business Warehouse)
|
EPM_WEBTEMPLATE |
CHAR
|
30 | 0 | ||||||||||||||
|
EXT_URL
URL Address for Detail View of External Source System
|
EPM_URL |
CHAR
|
255 | 0 | ||||||||||||||
|
EPM_PROGRAM
R/3 and mySAP ERP Program for Generating Key Figure
|
EPM_PROGRAM |
CHAR
|
40 | 0 | ||||||||||||||
|
EPM_VARIANT
Variant for R/3 Program that Determines KPIs
|
EPM_VARIANT |
CHAR
|
14 | 0 | ||||||||||||||
|
TARGET
Target Value for KPI
|
EPM_TARGET_VALUE |
DEC
|
15 | 3 | ||||||||||||||
|
MIN_VALUE
Minimum Value of KPI
|
EPM_MIN_VALUE |
DEC
|
15 | 3 | ||||||||||||||
|
R2YGATE
Threshold Value: Red to Yellow
|
EPM_GATE_VALUE_R2Y |
DEC
|
15 | 3 | ||||||||||||||
|
Y2GGATE
Threshold Value: Yellow to Green
|
EPM_GATE_VALUE_Y2G |
DEC
|
15 | 3 | ||||||||||||||
|
G2YGATE
Threshold Value: Green to Yellow
|
EPM_GATE_VALUE_G2Y |
DEC
|
15 | 3 | ||||||||||||||
|
Y2RGATE
Threshold Value: Yellow to Red
|
EPM_GATE_VALUE_Y2R |
DEC
|
15 | 3 | ||||||||||||||
|
MAX_VALUE
Maximum Value of KPI
|
EPM_MAX_VALUE |
DEC
|
15 | 3 | ||||||||||||||
|
RANGE_PER_PERIOD
Number of Periods
|
EPM_RANGE_PER_PERIOD |
NUMC
|
3 | 0 | ||||||||||||||
|
PERIOD
Period
|
EPM_PERIOD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||