SAP ABAP Table UMB_SC180 (Scorecard: Initiatives)

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_SC180	Table Relationship Diagram
Short Description	Scorecard: Initiatives

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	INIT	☑	UMB_Y_INIT	UMB_D_INIT	CHAR	10	0	Initiative
4	DURFR	☐	UMB_Y_INITDURFR	UMC_D_VALID	NUMC	7	0	Start of Initiative
5	DURTO	☐	UMB_Y_INITDURTO	UMC_D_VALID	NUMC	7	0	End of Initiative
6	PRIO	☐	UMB_Y_INITPRIO	UMB_D_INITPRIO	CHAR	1	0	Priority of Initiative
7	OWNER	☐	UMB_Y_INOWNR	XUBNAME	CHAR	12	0	Initiative Owner	*
8	RFCDEST_BIC	☐	UMC_Y_RFCDEST	RFCDEST	CHAR	32	0	RFC Destination	*
9	DOC_ID	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
10	.INCLUDE	☐				0	0	InfoCube and BW Report
11	RFCDEST	☐	UMC_Y_RFCDEST	RFCDEST	CHAR	32	0	RFC Destination	*
12	ICUBE	☐	UMC_Y_ICUBE	UMC_D_ICUBE	CHAR	30	0	InfoCube (BW)
13	TCUBE	☐	UMC_Y_TCUBE	UMC_D_TCUBE	CHAR	32	0	InfoCube (ODBO Name)
14	IQUERY	☐	UMC_Y_IQUERY	UMC_D_IQUERY	CHAR	30	0	BW Report (BW Internal Display)
15	TQUERY	☐	UMC_Y_TQUERY	UMC_D_TQUERY	CHAR	70	0	BW Report (ODBO Name)
16	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
17	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
18	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
19	NOAC	☐	UMB_Y_NOAC	UMB_D_NOAC	CHAR	1	0	Entry of Assessments and Comments
20	ISEQ	☐	UMB_Y_BSC_SEQ	NUMC4	NUMC	4	0	Scorecard: Sequence of Elements
21	OWNTYPE	☐	UMB_Y_OWNTYPE	UMB_D_OWNTYPE	CHAR	1	0	User Type
22	VAR	☐	UMM_Y_VANAME	UMM_D_VANAME	CHAR	15	0	Technical Name of a CPM Variable	UMM_VA100
23	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
24	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
25	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
26	STATGEN	☐	UMB_Y_STATGEN	UMB_D_STATGEN	CHAR	1	0	Type of Status Determination
27	.INCLUDE	☐				0	0	Formula ID and Assignment Table
28	MAP	☐	UMC_Y_MAP	UMC_D_MAP	CHAR	10	0	Assignment Table	UMC_GS120
29	FORMULA	☐	UMC_Y_FORMULA	UMC_D_FORMULA	CHAR	10	0	Formula ID	UMC_GS110
30	CINIT	☐	UMB_Y_CINIT	UMB_D_CINIT	CHAR	10	0	Common Initiative	UMB_CI100
31	PROJECT	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
32	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
33	PERIODICITY	☐	UMB_Y_EL_PERIODICITY	UMC_D_PERIODICITY	CHAR	4	0	Periodization of Element	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UMB_SC180	CINIT	UMB_CI100	CINIT	KEY	1	CN
2	UMB_SC180	FORMULA	UMC_GS110	FORMULA	KEY	1	CN
3	UMB_SC180	MANDT	T000	MANDT
4	UMB_SC180	MAP	UMC_GS120	MAP	KEY	1	CN
5	UMB_SC180	OTYPE	T778O	OTYPE
6	UMB_SC180	PLVAR	T778P	PLVAR
7	UMB_SC180	SCARD	UMB_SC100	SCARD	KEY	1	CN
8	UMB_SC180	TSTPNM	USR02	BNAME	KEY	C	CN
9	UMB_SC180	VAR	UMM_VA100	VANAME

History

Last changed by/on	SAP	20110901
SAP Release Created in