SAP ABAP Table UMB_MC100 (Scorecard: Measure Value Fields)

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_MC100	Table Relationship Diagram
Short Description	Scorecard: Measure Value Fields

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	MEAS	☑	UMK_Y_MEAS	UMK_D_MEAS	CHAR	18	0	Measure	UMB_SC103
4	COL	☑	UMB_Y_COL	UMB_D_COL	CHAR	10	0	Technical Name of Value Field	UMB_GS100
5	WRT	☐	UMB_Y_WRT	AS4FLAG	CHAR	1	0	Write Access for Value Field
6	.INCLUDE	☐				0	0	Value Field: BW Report and Measure
7	.INCLUDE	☐				0	0	InfoCube and BW Report
8	RFCDEST	☐	UMC_Y_RFCDEST	RFCDEST	CHAR	32	0	RFC Destination	*
9	ICUBE	☐	UMC_Y_ICUBE	UMC_D_ICUBE	CHAR	30	0	InfoCube (BW)
10	TCUBE	☐	UMC_Y_TCUBE	UMC_D_TCUBE	CHAR	32	0	InfoCube (ODBO Name)
11	IQUERY	☐	UMC_Y_IQUERY	UMC_D_IQUERY	CHAR	30	0	BW Report (BW Internal Display)
12	TQUERY	☐	UMC_Y_TQUERY	UMC_D_TQUERY	CHAR	70	0	BW Report (ODBO Name)
13	IKFNM	☐	UMC_Y_IKFNM	UMC_D_IKFNM	CHAR	30	0	Measure (BW Internal Display)
14	TKFNM	☐	UMC_Y_TKFNM	UMC_D_TKFNM	CHAR	143	0	Field Name of Key Figure (ODBO Name)
15	AREA	☐	UPC_Y_AREA	UPC_AREA	CHAR	8	0	Planning Area	*
16	PERIODICITY	☐	UMB_Y_COL_PERIODICITY	UMC_D_PERIODICITY	CHAR	4	0	Value Fields - Periodization	UMC_RU100
17	YTD	☐	UMC_Y_YTD	UMC_D_YTD	CHAR	1	0	Aggregation
18	YTD_PERIODICITY	☐	UMC_Y_YTD_PERIODICITY	UMC_D_PERIODICITY	CHAR	4	0	Time Period for the Aggregation	UMC_RU100
19	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
20	BW_EXCEPTION	☐	UMB_Y_BW_EXCEPTION		CHAR	1	0	Display BW Exceptions

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UMB_MC100	COL	UMB_GS100	COL	KEY	1	CN
2	UMB_MC100	MANDT	T000	MANDT
3	UMB_MC100	MEAS	UMB_SC103	MEAS	KEY	1	CN
4	UMB_MC100	PERIODICITY	UMC_RU100	PERIODICITY		1	N
5	UMB_MC100	SCARD	UMB_SC100	SCARD	KEY	1	CN
6	UMB_MC100	YTD_PERIODICITY	UMC_RU100	PERIODICITY	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in