EPM_KPI_CATALOGH - History of KPIs in KPI Catalog
History of KPIs in KPI Catalog information is stored in SAP table EPM_KPI_CATALOGH.
It is part of development package PLANT_MANAGER in software component EP-PCT-MAN-PM. This development package consists of objects that can be grouped under "Plant Manager".
It is part of development package PLANT_MANAGER in software component EP-PCT-MAN-PM. This development package consists of objects that can be grouped under "Plant Manager".
Fields for table EPM_KPI_CATALOGH
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | * |
| KPI_ID | Technical Name of KPI | X | EPM_KPI_ID | CHAR | 30 | |
| KPI_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | X | TIMESTAMP | DEC | 8 | |
| CAT_ID | Technical Name for KPI Category | EPM_CAT_ID | CHAR | 30 | ||
| KPI_TYPE | KPI Type | EPM_KPI_TYPE | CHAR | 1 | ||
| SOURCE_TYPE | Type of Source System for KPI Value | EPM_KPI_SOURCE_TYPE | CHAR | 3 | ||
| SOURCE | Logical Source System for KPI Value | EPM_KPI_SOURCE | CHAR | 10 | * | |
| BW_AN_PROCESS | Analysis Process from Business Information Warehouse | EPM_AN_PROCESS | CHAR | 30 | ||
| BW_WEBTEMPLATE | BW Web Template (Business Warehouse) | EPM_WEBTEMPLATE | CHAR | 30 | ||
| EXT_URL | URL Address for Detail View of External Source System | EPM_URL | CHAR | 255 | ||
| EPM_PROGRAM | R/3 and mySAP ERP Program for Generating Key Figure | EPM_PROGRAM | CHAR | 40 | * | |
| EPM_VARIANT | Variant for R/3 Program that Determines KPIs | EPM_VARIANT | CHAR | 14 | * | |
| TARGET | Target Value for KPI | EPM_TARGET_VALUE | DEC | 8 | ||
| MIN_VALUE | Minimum Value of KPI | EPM_MIN_VALUE | DEC | 8 | ||
| R2YGATE | Threshold Value: Red to Yellow | EPM_GATE_VALUE_R2Y | DEC | 8 | ||
| Y2GGATE | Threshold Value: Yellow to Green | EPM_GATE_VALUE_Y2G | DEC | 8 | ||
| G2YGATE | Threshold Value: Green to Yellow | EPM_GATE_VALUE_G2Y | DEC | 8 | ||
| Y2RGATE | Threshold Value: Yellow to Red | EPM_GATE_VALUE_Y2R | DEC | 8 | ||
| MAX_VALUE | Maximum Value of KPI | EPM_MAX_VALUE | DEC | 8 | ||
| RANGE_PER_PERIOD | Number of Periods | EPM_RANGE_PER_PERIOD | NUMC | 3 | ||
| PERIOD | Period | EPM_PERIOD | CHAR | 1 |