SAP ABAP Table UMB_SC120 (Scorecard: Strategy Assignment (Time-Dependent))

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_SC120	Table Relationship Diagram
Short Description	Scorecard: Strategy Assignment (Time-Dependent)

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_SC100
3	STRATEGY	☑	UMB_Y_STRATEGY	UMB_D_STRATEGY	CHAR	10	0	Technical Name of Strategy	UMB_SC104
4	VALID_FR	☑	UMC_Y_VALIDFR	UMC_D_FISCPER	NUMC	7	0	Start of Validity Period
5	VALID_TO	☐	UMC_Y_VALIDTO	UMC_D_FISCPER	NUMC	7	0	End of Validity Period
6	OWNTYPE	☐	UMB_Y_OWNTYPE	UMB_D_OWNTYPE	CHAR	1	0	User Type
7	OWNER	☐	UMB_Y_STOWNR_A	XUBNAME	CHAR	12	0	Strategy Owner	USR02
8	VAR	☐	UMM_Y_VANAME	UMM_D_VANAME	CHAR	15	0	Technical Name of a CPM Variable	UMM_VA100
9	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
10	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
11	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UMB_SC120	MANDT	T000	MANDT
2	UMB_SC120	OTYPE	T778O	OTYPE
3	UMB_SC120	OWNER	USR02	BNAME	KEY	1	CN
4	UMB_SC120	PLVAR	T778P	PLVAR
5	UMB_SC120	SCARD	UMB_SC100	SCARD	KEY	1	CN
6	UMB_SC120	STRATEGY	UMB_SC104	STRATEGY	KEY	1	CN
7	UMB_SC120	VAR	UMM_VA100	VANAME

History

Last changed by/on	SAP	20110901
SAP Release Created in