SAP ABAP Table UMB_YS_SCNODE (Scorecard Node)

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_SCNODE	Table Relationship Diagram
Short Description	Scorecard Node

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UMB_YS_SCNODE	INIT_CURVAR	UMC_TM100	VAR	KEY
2	UMB_YS_SCNODE	INIT_INTVAR	UMC_TM100	VAR	KEY
3	UMB_YS_SCNODE	INIT_TARVAR	UMC_TM100	VAR	KEY
4	UMB_YS_SCNODE	KURST	TCURV	KURST	KEY
5	UMB_YS_SCNODE	PERIODICITY	UMC_RU100	PERIODICITY	KEY
6	UMB_YS_SCNODE	PERIV	T009	PERIV	KEY
7	UMB_YS_SCNODE	TSTPNM	USR02	BNAME	KEY	C	CN
8	UMB_YS_SCNODE	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	3.1A