SAP ABAP Table UMB_WIZARD102 (Default Settings for Each User. Used by BSC Wizard)

Hierarchy

☛ SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
   ⤷ FIN-SEM-CPM-BSC (Application Component) Balanced Scorecard
     ⤷ UMB_WIZARD (Package) Scorecard Wizard

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	UMB_WIZARD102	Table Relationship Diagram
Short Description	Default Settings for Each User. Used by BSC Wizard

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	UNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
3	.INCLUDE	☐				0	0	Owner
4	.INCLUDE	☐				0	0	Period Structure
5	VALID_FR	☐	UMC_Y_VALIDFR	UMC_D_FISCPER	NUMC	7	0	Start of Validity Period
6	VALID_TO	☐	UMC_Y_VALIDTO	UMC_D_FISCPER	NUMC	7	0	End of Validity Period
7	OWNER	☐	UMB_Y_OBOWNR_A	XUBNAME	CHAR	12	0	Owner for Scorecard Element	*
8	OWNTYPE	☐	UMB_Y_OWNTYPE	UMB_D_OWNTYPE	CHAR	1	0	User Type
9	VAR	☐	UMM_Y_VANAME	UMM_D_VANAME	CHAR	15	0	Technical Name of a CPM Variable	*
10	.INCLUDE	☐				0	0	Object
11	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
12	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
13	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
14	NOAC	☐	UMB_Y_NOAC	UMB_D_NOAC	CHAR	1	0	Entry of Assessments and Comments
15	STATGEN	☐	UMB_Y_STATGEN1	UMB_D_STATGEN1	CHAR	1	0	Type of Status Determination
16	SC_STATCALC	☐	UMB_Y_STATCALCSC	UMB_D_STATCALCSC	CHAR	1	0	Status Calculation for Scorecard
17	STRA_STATCALC	☐	UMB_Y_STATCALCST	UMB_D_STATCALCST	CHAR	1	0	Status Calculation for Strategy
18	PERS_STATCALC	☐	UMB_Y_STATCALCPE	UMB_D_STATCALCPE	CHAR	1	0	Status Calculation for Perspective
19	OBJ_STATCALC	☐	UMB_Y_STATCALC	UMB_D_STATCALC	CHAR	1	0	Type of Automatic Status Calculation
20	.INCLUDE	☐				0	0	Structure: BW Key Figure
21	RFCDEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
22	RFCDEST_EXIST	☐	UMK_Y_BOOL	UMK_D_BOOL	CHAR	1	0	Boolean (no = space / yes = X)
23	ICUBE	☐	UMK_Y_INFOPROV		CHAR	30	0	InfoProvider
24	ICUBE_TXT	☐	UMK_Y_LTXT	UMK_D_LTXT	CHAR	60	0	Long Text
25	ICUBE_EXIST	☐	UMK_Y_BOOL	UMK_D_BOOL	CHAR	1	0	Boolean (no = space / yes = X)
26	TMPLT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
27	TMPLT_COMPID	☐	SYSUUID_25	SYSUUID_25	CHAR	25	0	UUID in compressed form
28	TMPLT_TXT	☐	UMK_Y_LTXT	UMK_D_LTXT	CHAR	60	0	Long Text
29	TMPLT_EXIST	☐	UMK_Y_BOOL	UMK_D_BOOL	CHAR	1	0	Boolean (no = space / yes = X)
30	KEYF	☐	UMK_Y_IOBJNM	UMK_D_IOBJNM	CHAR	30	0	InfoObject Name
31	KEYF_COMPID	☐	UMK_Y_IOBJNM	UMK_D_IOBJNM	CHAR	30	0	InfoObject Name
32	KEYF_TXT	☐	UMK_Y_LTXT	UMK_D_LTXT	CHAR	60	0	Long Text
33	KEYF_EXIST	☐	UMK_Y_BOOL	UMK_D_BOOL	CHAR	1	0	Boolean (no = space / yes = X)
34	TYPE	☐	UMK_Y_ICKEYFTYPE	UMK_D_ICKEYFTYPE	CHAR	1	0	Measure Type
35	ICUBE_TYPE	☐	UMK_Y_INFOPROV_TYPE	UMK_D_INFOPROV_TYPE	CHAR	1	0	InfoProvider Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UMB_WIZARD102	OTYPE	T778O	OTYPE
2	UMB_WIZARD102	PLVAR	T778P	PLVAR

History

Last changed by/on	SAP	20110901
SAP Release Created in	350