SAP ABAP Table UMB_SC196 (Scorecard: BW Variables for Value Fields of an Initiative)
Hierarchy
☛
SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
⤷ FIN-SEM-CPM-BSC (Application Component) Balanced Scorecard
⤷ UMB (Package) SEM-CPM: Balanced Scorecard
⤷ FIN-SEM-CPM-BSC (Application Component) Balanced Scorecard
⤷ UMB (Package) SEM-CPM: Balanced Scorecard
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | UMB_SC196 | Table Relationship Diagram |
Short Description | Scorecard: BW Variables for Value Fields of an Initiative |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | SCARD | UMB_Y_SCARD | UMB_D_SCARD | CHAR | 10 | 0 | Scorecard | UMB_SC195 | |
3 | INIT | UMB_Y_INIT | UMB_D_INIT | CHAR | 10 | 0 | Initiative | UMB_SC195 | |
4 | COL | UMB_Y_COL | UMB_D_COL | CHAR | 10 | 0 | Technical Name of Value Field | UMB_SC195 | |
5 | BW_VAR | UMC_Y_BW_VAR | UMC_D_BW_VAR | CHAR | 8 | 0 | BW Variable | ||
6 | PERIOD_SEQ | UMC_Y_PERIOD_SEQ | NUMC | 2 | 0 | Number of Subinterval | |||
7 | SELNO | UMC_Y_SELNO | NUM02 | NUMC | 2 | 0 | Selection number | ||
8 | SELTYPE | UMB_Y_SELTYPE | UMB_D_SELTYPE | CHAR | 1 | 0 | Selection Type | ||
9 | CPM_VAR | UMM_Y_VANAME | UMM_D_VANAME | CHAR | 15 | 0 | Technical Name of a CPM Variable | * | |
10 | VAR | UMB_Y_VAR | UMB_D_VAR | CHAR | 10 | 0 | Technical Name of Time Variable | * | |
11 | PERIOD_SHIFT | UMB_Y_PERIOD_SHIFT | UMB_D_PERIOD_SHIFT | INT4 | 10 | 0 | Period Offset | ||
12 | YEAR_SHIFT | UMB_Y_YEAR_SHIFT | UMB_D_YEAR_SHIFT | INT4 | 10 | 0 | Fiscal Year Offset | ||
13 | .INCLUDE | 0 | 0 | Selection Conditions for Characteristic Values | |||||
14 | SIGN | UMC_Y_SIGN | UMC_D_SIGN | CHAR | 1 | 0 | Sign for selection | ||
15 | OPER | UMC_Y_OPER | UMC_D_OPER | CHAR | 2 | 0 | Selection operand (EQ, NE, .....) | ||
16 | LOW | UMC_Y_LOW | UMC_D_TCHAVAL | CHAR | 143 | 0 | Lower interval limit (ODBO) | ||
17 | LOWBW | UMC_Y_LOWBW | UMC_D_ICHAVAL | CHAR | 60 | 0 | Upper Interval Limit (BW Internal Display) | ||
18 | LOWBW_EXT | UMC_Y_LOWBW_EXT | UMC_D_ICHAVALEXT | CHAR | 70 | 0 | Lower Interval Limit (BW) | ||
19 | HIGH | UMC_Y_HIGH | UMC_D_TCHAVAL | CHAR | 143 | 0 | Upper interval limit (ODBO) | ||
20 | HIGHBW | UMC_Y_HIGHBW | UMC_D_ICHAVAL | CHAR | 60 | 0 | Lower Interval Limit (BW Internal Display) | ||
21 | HIGHBW_EXT | UMC_Y_HIGHBW_EXT | UMC_D_ICHAVALEXT | CHAR | 70 | 0 | Upper Interval Limit (BW) | ||
22 | .INCLUDE | 0 | 0 | Selection Conditions for Hierarchy Nodes | |||||
23 | HINAME | UMC_Y_THINAME | UMC_D_THINAME | CHAR | 65 | 0 | Hierarchy (ODBO Name) | ||
24 | HINAMEBW | UMC_Y_IHINAME | UMC_D_IHINAME | CHAR | 30 | 0 | Hierarchy Name (BW) | ||
25 | HINODE | UMC_Y_THINODE | UMC_D_TCHAVAL | CHAR | 143 | 0 | Hierarchy Node (ODBO) | ||
26 | HINODEBW | UMC_Y_ICHAVAL | UMC_D_ICHAVAL | CHAR | 60 | 0 | Field for any Characteristic Value (BW Internal Display) | ||
27 | HINODEBW_EXT | UMC_Y_ICHAVALEXT | UMC_D_ICHAVALEXT | CHAR | 70 | 0 | Field for any Characteristic Value (BW) | ||
28 | HIVERS | UMC_Y_HIVERS | UMC_D_HIVERS | CHAR | 3 | 0 | Hierarchy version | ||
29 | HIDATE | UMC_Y_HIDATE | DATUM | DATS | 8 | 0 | Hierarchy: Key date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | UMB_SC196 | COL | UMB_SC195 | COL | KEY | 1 | CN |
2 | UMB_SC196 | INIT | UMB_SC195 | INIT | KEY | 1 | CN |
3 | UMB_SC196 | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | UMB_SC196 | SCARD | UMB_SC195 | SCARD | KEY | 1 | CN |
History
Last changed by/on | SAP | 20041006 |
SAP Release Created in |