SAP ABAP Table UMB_SC211 (Scorecard: Strategy Score & A&C BDS Doc ID)

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_SC211	Table Relationship Diagram
Short Description	Scorecard: Strategy Score & A&C BDS Doc ID

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	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	FISCPER	☑	UMB_Y_STATDAT	UMC_D_VALID	NUMC	7	0	Period
5	GSCORE	☐	UMB_Y_GSCORE	UMB_D_SCORE	DEC	4	0	System-Generated Score
6	GSET	☐	UMB_Y_GSET	AS4FLAG	CHAR	1	0	System-Generated Status is Set
7	OSCORE	☐	UMB_Y_OSCORE	UMB_D_SCORE	DEC	4	0	Manually Assigned Score
8	OSET	☐	UMB_Y_OSET	UMB_D_OSET	CHAR	1	0	Manually Assigned Status Is Set
9	DOC_ID	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
10	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
11	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
12	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UMB_SC211	MANDT	T000	MANDT
2	UMB_SC211	SCARD	UMB_SC100	SCARD
3	UMB_SC211	STRATEGY	UMB_SC104	STRATEGY
4	UMB_SC211	TSTPNM	USR02	BNAME	KEY	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in