UMB_MC101 - Scorecard: Characteristics for the Value Fields of a Measure
Scorecard: Characteristics for the Value Fields of a Measure information is stored in SAP table UMB_MC101.
It is part of development package UMB in software component FIN-SEM-CPM-BSC. This development package consists of objects that can be grouped under "SEM-CPM: Balanced Scorecard".
It is part of development package UMB in software component FIN-SEM-CPM-BSC. This development package consists of objects that can be grouped under "SEM-CPM: Balanced Scorecard".
Fields for table UMB_MC101
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SCARD | Scorecard | X | UMB_Y_SCARD | CHAR | 20 | UMB_SC100 |
| MEAS | Measure | X | UMK_Y_MEAS | CHAR | 36 | UMB_SC103 |
| COL | Technical Name of Value Field | X | UMB_Y_COL | CHAR | 20 | UMB_MC100 |
| TCHANM | Field name dimension (ODBO identifier) | X | UMC_Y_TCHANM | CHAR | 64 | |
| SELNO | Selection number | X | UMC_Y_SELNO | NUMC | 4 | |
| ICHANM | Technical Name of Characteristic (BW) | UMC_Y_ICHANM | CHAR | 60 | ||
| SELTYPE | Selection Type | UMB_Y_SELTYPE | CHAR | 2 | ||
| CPM_VAR | Technical Name of a CPM Variable | UMM_Y_VANAME | CHAR | 30 | * | |
| VAR | Technical Name of Time Variable | UMB_Y_VAR | CHAR | 20 | * | |
| PERIOD_SHIFT | Period Offset | UMB_Y_PERIOD_SHIFT | INT4 | 4 | ||
| YEAR_SHIFT | Fiscal Year Offset | UMB_Y_YEAR_SHIFT | INT4 | 4 | ||
| AGGFLG | Indicator for Aggregation or Single Values | UMC_Y_AGGFLG | CHAR | 2 | ||
| YTD | Aggregation | UMC_Y_YTD | CHAR | 2 | ||
| .INCLUDE | RANGE | UMC_YS_RANGE | 0 | |||
| SIGN | Sign for selection | UMC_Y_SIGN | CHAR | 2 | ||
| OPER | Selection operand (EQ, NE, .....) | UMC_Y_OPER | CHAR | 4 | ||
| LOW | Lower interval limit (ODBO) | UMC_Y_LOW | CHAR | 286 | ||
| LOWBW | Upper Interval Limit (BW Internal Display) | UMC_Y_LOWBW | CHAR | 120 | ||
| LOWBW_EXT | Lower Interval Limit (BW) | UMC_Y_LOWBW_EXT | CHAR | 140 | ||
| HIGH | Upper interval limit (ODBO) | UMC_Y_HIGH | CHAR | 286 | ||
| HIGHBW | Lower Interval Limit (BW Internal Display) | UMC_Y_HIGHBW | CHAR | 120 | ||
| HIGHBW_EXT | Upper Interval Limit (BW) | UMC_Y_HIGHBW_EXT | CHAR | 140 | ||
| .INCLUDE | HYSELECT | UMC_YS_HYSELECT | 0 | |||
| HINAME | Hierarchy (ODBO Name) | UMC_Y_THINAME | CHAR | 130 | ||
| HINAMEBW | Hierarchy Name (BW) | UMC_Y_IHINAME | CHAR | 60 | ||
| HINODE | Hierarchy Node (ODBO) | UMC_Y_THINODE | CHAR | 286 | ||
| HINODEBW | Field for any Characteristic Value (BW Internal Display) | UMC_Y_ICHAVAL | CHAR | 120 | ||
| HINODEBW_EXT | Field for any Characteristic Value (BW) | UMC_Y_ICHAVALEXT | CHAR | 140 | ||
| HIVERS | Hierarchy version | UMC_Y_HIVERS | CHAR | 6 | ||
| HIDATE | Hierarchy: Key date | UMC_Y_HIDATE | DATS | 16 |