| 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 |
Possible values
| 1 |
Positive |
| 2 |
Negative |
| 3 |
In Two Directions |
|
| SOURCE_TYPE |
Type of Source System for KPI Value |
EPM_KPI_SOURCE_TYPE |
|
CHAR |
|
3 |
0 |
Possible values
| R/3 |
SAP R/3 or mySAP ERP |
| BW |
Business Information Warehouse |
| EXT |
External System |
|
| 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 |
Possible values
| 1 |
Hour |
| 2 |
Day |
| 3 |
Week |
| 4 |
Month |
| 5 |
Year |
|
