SAP ABAP Table UMV_TR117 (Obsolete: Value Driver Tree: BW Variables for Value Fields)

Hierarchy

☛ SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
   ⤷ FIN-SEM-CPM (Application Component) Corporate Performance Monitor
     ⤷ UMV (Package) CPM : Value Driver Tree

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	UMV_TR117	Table Relationship Diagram
Short Description	Obsolete: Value Driver Tree: BW Variables for Value Fields

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	VDTREE	☑	UMV_Y_VDTREE	UMV_D_VDTREE	CHAR	10	0	Value Driver Tree	UMV_TR116
3	VDRIVER	☑	UMV_Y_VDRIVER	UMV_D_VDRIVER	CHAR	10	0	Value Driver	UMV_TR116
4	COL	☑	UMB_Y_COL	UMB_D_COL	CHAR	10	0	Technical Name of Value Field	UMV_TR116
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	.INCLUDE	☐				0	0	Selection Conditions for Characteristic Values
12	SIGN	☐	UMC_Y_SIGN	UMC_D_SIGN	CHAR	1	0	Sign for selection
13	OPER	☐	UMC_Y_OPER	UMC_D_OPER	CHAR	2	0	Selection operand (EQ, NE, .....)
14	LOW	☐	UMC_Y_LOW	UMC_D_TCHAVAL	CHAR	143	0	Lower interval limit (ODBO)
15	LOWBW	☐	UMC_Y_LOWBW	UMC_D_ICHAVAL	CHAR	60	0	Upper Interval Limit (BW Internal Display)
16	LOWBW_EXT	☐	UMC_Y_LOWBW_EXT	UMC_D_ICHAVALEXT	CHAR	70	0	Lower Interval Limit (BW)
17	HIGH	☐	UMC_Y_HIGH	UMC_D_TCHAVAL	CHAR	143	0	Upper interval limit (ODBO)
18	HIGHBW	☐	UMC_Y_HIGHBW	UMC_D_ICHAVAL	CHAR	60	0	Lower Interval Limit (BW Internal Display)
19	HIGHBW_EXT	☐	UMC_Y_HIGHBW_EXT	UMC_D_ICHAVALEXT	CHAR	70	0	Upper Interval Limit (BW)
20	.INCLUDE	☐				0	0	Selection Conditions for Hierarchy Nodes
21	HINAME	☐	UMC_Y_THINAME	UMC_D_THINAME	CHAR	65	0	Hierarchy (ODBO Name)
22	HINAMEBW	☐	UMC_Y_IHINAME	UMC_D_IHINAME	CHAR	30	0	Hierarchy Name (BW)
23	HINODE	☐	UMC_Y_THINODE	UMC_D_TCHAVAL	CHAR	143	0	Hierarchy Node (ODBO)
24	HINODEBW	☐	UMC_Y_ICHAVAL	UMC_D_ICHAVAL	CHAR	60	0	Field for any Characteristic Value (BW Internal Display)
25	HINODEBW_EXT	☐	UMC_Y_ICHAVALEXT	UMC_D_ICHAVALEXT	CHAR	70	0	Field for any Characteristic Value (BW)
26	HIVERS	☐	UMC_Y_HIVERS	UMC_D_HIVERS	CHAR	3	0	Hierarchy version
27	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	UMV_TR117	COL	UMV_TR116	COL	KEY	1	CN
2	UMV_TR117	MANDT	T000	MANDT
3	UMV_TR117	VDRIVER	UMV_TR116	VDRIVER	KEY	1	CN
4	UMV_TR117	VDTREE	UMV_TR116	VDTREE	KEY	1	CN

History

Last changed by/on	SAP	20041006
SAP Release Created in	3.0A