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

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