SAP ABAP Table UMB_YS_SCORECARD (Interface for Scorecard)

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	INTTAB	Structure
Structure	UMB_YS_SCORECARD	Table Relationship Diagram
Short Description	Interface for Scorecard

Delivery and Maintenance

Pool/cluster
Delivery Class
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	*
2	SCARD	☐	UMB_Y_SCARD	UMB_D_SCARD	CHAR	10	0	Scorecard	*
3	OWNER	☐	UMB_Y_SCOWNR	XUBNAME	CHAR	12	0	Scorecard Owner	*
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	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
12	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
13	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
14	.INCLUDE	☐				0	0	Short, medium and long text
15	LTXT	☐	UMC_Y_LTXT	UMC_D_LTXT	CHAR	60	0	Long Text
16	MTXT	☐	UMC_Y_MTXT	UMC_D_MTXT	CHAR	30	0	Medium Text
17	STXT	☐	UMC_Y_STXT	UMC_D_STXT	CHAR	15	0	Short text
18	NOAC	☐	UMB_Y_NOAC	UMB_D_NOAC	CHAR	1	0	Entry of Assessments and Comments
19	DOC_ID	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
20	INIT_CURVAR	☐	UMB_Y_CUR_VAR	UMB_D_VAR	CHAR	10	0	Variable for Initial Value of Current Period	UMC_TM100
21	INIT_TARVAR	☐	UMB_Y_TAR_VAR	UMB_D_VAR	CHAR	10	0	Variable for Initial Value of Target Period	UMC_TM100
22	INIT_INTVAR	☐	UMB_Y_INT_VAR	UMB_D_VAR	CHAR	10	0	Variable for Initial Value of Time Interval	UMC_TM100
23	PERIODICITY	☐	UMC_Y_PERIODICITY	UMC_D_PERIODICITY	CHAR	4	0	Technical Name of Periodization	UMC_RU100
24	BW_BUFFER	☐	UMB_Y_BW_BUFFER	UMB_D_BW_BUFFER	CHAR	1	0	Data Integrity During Presentation
25	DATE_FORMAT	☐	UMC_Y_DATE_FORMAT	UMC_D_DATE_FORMAT	CHAR	1	0	Date Format
26	RMS_ACTIVE	☐	UMR_Y_RMS_ACTIVE	AS4FLAG	CHAR	1	0	Risk Control for Target System: Active Flag
27	SHOWTREND	☐	UMC_Y_SHOW_TREND	UMC_D_SHOW_TREND	CHAR	1	0	Display Trend Indicator
28	GENLOG	☐	UMC_Y_GENLOG	UMC_D_GENLOG	CHAR	1	0	Created of a Change Log
29	STYPE	☐	UMB_Y_STYPE	UMB_D_STYPE	CHAR	1	0	Scorecard Type
30	TEMPLATE	☐	UMB_Y_SCARD_TEMPLATE	UMB_D_SCARD	CHAR	10	0	Scorecard Template	*
31	OWNTYPE	☐	UMB_Y_OWNTYPE	UMB_D_OWNTYPE	CHAR	1	0	User Type
32	VAR	☐	UMM_Y_VANAME	UMM_D_VANAME	CHAR	15	0	Technical Name of a CPM Variable	*
33	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
34	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
35	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
36	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_YS_SCORECARD	INIT_CURVAR	UMC_TM100	VAR	KEY
2	UMB_YS_SCORECARD	INIT_INTVAR	UMC_TM100	VAR	KEY
3	UMB_YS_SCORECARD	INIT_TARVAR	UMC_TM100	VAR	KEY
4	UMB_YS_SCORECARD	KURST	TCURV	KURST	KEY
5	UMB_YS_SCORECARD	PERIODICITY	UMC_RU100	PERIODICITY	KEY
6	UMB_YS_SCORECARD	PERIV	T009	PERIV	KEY
7	UMB_YS_SCORECARD	TSTPNM	USR02	BNAME	KEY	C	CN
8	UMB_YS_SCORECARD	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in