SAP ABAP Table UMB_SC100 (Scorecard: Header Table)

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_SC100	Table Relationship Diagram
Short Description	Scorecard: Header Table

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
3	OWNER	☐	UMB_Y_SCOWNR	XUBNAME	CHAR	12	0	Scorecard Owner	USR02
4	TSTATUS	☐	UMB_Y_TSTATUS	UMB_D_TSTATUS	CHAR	1	0	Technical status of the scorecard
5	WAERS	☐	UMB_Y_WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
6	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
7	ANALYSIS	☐	UMB_Y_SCANALYSIS	UMB_D_SCANALYSIS	CHAR	1	0	Element Breakdown in Scorecard Analysis View
8	OVERVIEW	☐	UMB_Y_SCOVERVIEW	UMB_D_SCOVERVIEW	CHAR	1	0	Element Breakdown in the Perspectives Overview
9	STATGEN	☐	UMB_Y_STATGEN1	UMB_D_STATGEN1	CHAR	1	0	Type of Status Determination
10	STATCALC	☐	UMB_Y_STATCALCSC	UMB_D_STATCALCSC	CHAR	1	0	Status Calculation for Scorecard
11	NOAC	☐	UMB_Y_NOAC	UMB_D_NOAC	CHAR	1	0	Entry of Assessments and Comments
12	RFCDEST_BIC	☐	UMC_Y_RFCDEST	RFCDEST	CHAR	32	0	RFC Destination	*
13	DOC_ID	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
14	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
15	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	*
16	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
17	INIT_CURVAR	☐	UMB_Y_CUR_VAR	UMB_D_VAR	CHAR	10	0	Variable for Initial Value of Current Period	UMC_TM100
18	INIT_TARVAR	☐	UMB_Y_TAR_VAR	UMB_D_VAR	CHAR	10	0	Variable for Initial Value of Target Period	UMC_TM100
19	INIT_INTVAR	☐	UMB_Y_INT_VAR	UMB_D_VAR	CHAR	10	0	Variable for Initial Value of Time Interval	UMC_TM100
20	PERIODICITY	☐	UMC_Y_APPL_PERIODICITY	UMC_D_PERIODICITY	CHAR	4	0	Periodization of an Application	UMC_RU100
21	BW_BUFFER	☐	UMB_Y_BW_BUFFER	UMB_D_BW_BUFFER	CHAR	1	0	Data Integrity During Presentation
22	DATE_FORMAT	☐	UMC_Y_DATE_FORMAT	UMC_D_DATE_FORMAT	CHAR	1	0	Date Format
23	RMS_ACTIVE	☐	UMR_Y_RMS_ACTIVE	AS4FLAG	CHAR	1	0	Risk Control for Target System: Active Flag
24	SHOWTREND	☐	UMC_Y_SHOW_TREND	UMC_D_SHOW_TREND	CHAR	1	0	Display Trend Indicator
25	GENLOG	☐	UMC_Y_GENLOG	UMC_D_GENLOG	CHAR	1	0	Created of a Change Log
26	STYPE	☐	UMB_Y_STYPE	UMB_D_STYPE	CHAR	1	0	Scorecard Type
27	TEMPLATE	☐	UMB_Y_SCARD_TEMPLATE	UMB_D_SCARD	CHAR	10	0	Scorecard Template	*
28	OWNTYPE	☐	UMB_Y_OWNTYPE	UMB_D_OWNTYPE	CHAR	1	0	User Type
29	VAR	☐	UMM_Y_VANAME	UMM_D_VANAME	CHAR	15	0	Technical Name of a CPM Variable	UMM_VA100
30	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
31	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
32	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
33	KURST	☐	KURST_CURR	KURST	CHAR	4	0	Exchange rate type	TCURV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UMB_SC100	INIT_CURVAR	UMC_TM100	VAR
2	UMB_SC100	INIT_INTVAR	UMC_TM100	VAR
3	UMB_SC100	INIT_TARVAR	UMC_TM100	VAR
4	UMB_SC100	KURST	TCURV	KURST	KEY
5	UMB_SC100	MANDT	T000	MANDT
6	UMB_SC100	OTYPE	T778O	OTYPE
7	UMB_SC100	OWNER	USR02	BNAME	KEY	1	CN
8	UMB_SC100	PERIODICITY	UMC_RU100	PERIODICITY
9	UMB_SC100	PERIV	T009	PERIV	KEY	1	CN
10	UMB_SC100	PLVAR	T778P	PLVAR
11	UMB_SC100	VAR	UMM_VA100	VANAME
12	UMB_SC100	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in