SAP ABAP Table /MRSS/V_SGU_PRO (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/MRSS/V_SGU_PRO	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	ID	☑	/MRSS/T_UI_PROFILE	/MRSS/_SGU_UI_PROFILE	CHAR	10	0	User Interface Profile
3	TEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
4	PRF_GRUPPE	☐	BCPRFGROUP	BCPRFGROUP	CHAR	4	0	Profile group (sort graphics profiles)	TBCG
5	PRF_NAME	☐	BCPRFNAME	CHAR12	CHAR	12	0	Name of graphics profile	TBCG
6	PRF_INDEX	☐	BCPRFINDEX	CHAR1	CHAR	1	0	Profile index for the graphics profile	TBCG
7	VIEW_ID	☐	/MRSS/T_SGU_VIEW_ID_PRO	NUMC3	NUMC	3	0	View Profile ID
8	ZOOM_LEVEL	☐	/MRSS/T_SGU_ZOOM_LEVEL		NUMC	3	0	Zoom Factor
9	TICK_SIZE	☐	/MRSS/T_SGU_TICKSIZE	NUMC4	NUMC	4	0	Width of Area in Time Axis of Bar Chart
10	DEFAULT_MODE	☐	/MRSS/T_SGU_DEFAULT_MODE	/MRSS/_SGU_DEFAULT_MODE	CHAR	4	0	Standard Mode for Planning Board
11	TICK_SIZE_COMPR	☐	/MRSS/T_SGU_SECTSIZE	NUMC4	NUMC	4	0	Width of a Compressed, Displayed Area
12	TIME_COMPRESS	☐	/MRSS/T_SGU_TIME_COMPRESS	/MRSS/_BOOLEAN	CHAR	1	0	Compressed Display of Non-Working Times
13	DAILY_START	☐	/MRSS/T_SGU_DAILY_START	UZEIT	TIMS	6	0	Daily Start of Working Time
14	DAILY_END	☐	/MRSS/T_SGU_DAILY_END	UZEIT	TIMS	6	0	Daily End of Working Time
15	FACTORY_CALENDAR	☐	/MRSS/T_SGU_WFCID	WFCID	CHAR	2	0	Factory Calendar
16	SCALING_UNIT	☐	/MRSS/T_SCALING_UNIT	/MRSS/_SCALING_UNIT	CHAR	10	0	Scaling unit
17	ITEM_WORKL_MULT	☐	/MRSS/T_WORKL_MULT	/MRSS/_BOOLEAN	CHAR	1	0	Enable multi select of item worklist
18	UTILTHRESH_DAY	☐	/MRSS/T_DEF_UTIL_THRESHOLD	/MRSS/THRESHOLD	INT1	3	0	Default utilization threshold
19	UTILTHRESH_WEEK	☐	/MRSS/T_DEF_UTIL_THRESHOLD_W	/MRSS/THRESHOLD	INT1	3	0	Default utilization threshold per Week
20	PERCENTAGE_LINE	☐	/MRSS/T_SGU_GANTT_PER_LINE	/MRSS/_SGU_GANTT_PER_LINE	DEC	3	0	Percentage Line for Planning Node Gantt
21	PN_VEW_TYPE	☐	/MRSS/T_SGU_PN_VIEW_TYPE	/MRSS/_SGU_PN_VIEW_TYPE	CHAR	1	0	Planning Node Gantt View Type
22	GRAPH_COLOR_FILL	☐	/MRSS/T_SGU_GRAPH_COLFILL	/MRSS/_BOOLEAN	CHAR	1	0	Planning Node Gantt Color Fill
23	ROW_WIDTH	☐	/MRSS/T_SGU_PN_LINE_WIDTH	CHAR2	CHAR	2	0	Planning Node Gantt Row Width
24	FONT_SIZE	☐	/MRSS/T_SGU_PN_FONT_SIZE	CHAR2	CHAR	2	0	Planning Node Gantt Font Size
25	MAX_LIMIT	☐	/MRSS/T_SGU_PN_MAX_LIMIT	/MRSS/_SGU_GANTT_PER_LINE	DEC	3	0	Maximum Graph limit for Y axis of Planning Node Gantt
26	MIN_LIMIT	☐	/MRSS/T_SGU_PN_MIN_LIMIT	/MRSS/_SGU_GANTT_PER_LINE	DEC	3	0	Minimum Graph limit for Y axis of Planning Node Gantt
27	PN_GRAPH_TYPE	☐	/MRSS/T_SGU_PN_GRAPH_TYPE	/MRSS/_SGU_PN_GRAPH_TYPE	CHAR	1	0	Planning Node Gantt Graph Type
28	RESTR_START_TYPE	☐	/MRSS/T_DEM_RESTRICT_START	/MRSS/_DEM_RESTRICT_START	CHAR	1	0	Demand Start Restriction
29	RESTR_END_TYPE	☐	/MRSS/T_DEM_RESTRICT_END	/MRSS/_DEM_RESTRICT_END	CHAR	1	0	Demand End Restriction
30	USE_WL_MENU	☐	/MRSS/T_SGU_USE_WL_MENU	/MRSS/_BOOLEAN	CHAR	1	0	Use Enhanced context menu for Demand Gantt
31	ABS_AVAIL_DISP	☐	/MRSS/T_SGU_ABS_AVAIL_DISPLAY	/MRSS/_BOOLEAN	CHAR	1	0	Display Absolute Availability
32	RES_IN_DISPGANTT	☐	/MRSS/T_SGU_GANTT_DISP_RES	/MRSS/_BOOLEAN	CHAR	1	0	Display Resources in Dispatching Gantt
33	SET_DISPATCH	☐	/MRSS/T_SGU_DISPATCHED_STAT	/MRSS/_BOOLEAN	CHAR	1	0	Set Dispatch Status
34	ROW_WIDTH_ABS	☐	/MRSS/T_SGU_PN_LINE_WIDTH_ABS	CHAR3	CHAR	3	0	Planning Node Gantt Row Width for ABS display
35	MAX_LIMIT_ABS	☐	/MRSS/T_SGU_PN_MAX_LIMIT_ABS	/MRSS/_SGU_GANTT_PER_LINE	DEC	3	0	Maximum Graph limit for Y axis of Planning Node Gantt ABS
36	MIN_LIMIT_ABS	☐	/MRSS/T_SGU_PN_MIN_LIMIT_ABS	/MRSS/_SGU_GANTT_PER_LINE	DEC	3	0	Minimum Graph limit for Y axis of Planning Node Gantt ABS
37	JUMP_TO_DATE	☐	/MRSS/T_SGU_JUMP_BEGIN_SET	/MRSS/_BOOLEAN	CHAR	1	0	Set Plb Start Date
38	JUMP_START_SIGN	☐	/MRSS/T_SGU_JUMP_BEGIN_SIGN	/MRSS/_SGU_JUMP_BEGIN_SIGN	CHAR	1	0	Sign for Gantt Start Date
39	JUMP_START_DATE	☐	/MRSS/T_SGU_JUMP_BEGIN	NUMC3	NUMC	3	0	Jump to Current Date
40	DAY_WISE_CG	☐	/MRSS/T_SGU_DAY_WISE_PLAN	/MRSS/_BOOLEAN	CHAR	1	0	Hide Non-Working Times
41	CAP_IN_PLANLINE	☐	/MRSS/T_SGU_CAP_ASG_IN_PLAN	/MRSS/_BOOLEAN	CHAR	1	0	Show Capacitive Assignments in Planning Row
42	CREATE_ASG_DAYB	☐	/MRSS/T_SGU_CREATE_ASG_DAYB	/MRSS/_BOOLEAN	CHAR	1	0	Create New Assignments Day-Based
43	VIEW_ASSIGNMENT	☐	/MRSS/T_SGU_VIEW_ASSIGNMENT	XFELD	CHAR	1	0	Display Assignments
44	VIEW_TIMESPEC	☐	/MRSS/T_SGU_VIEW_TIMESPEC	XFELD	CHAR	1	0	Display Time Allocation
45	VIEW_TEAM	☐	/MRSS/T_SGU_VIEW_TEAM	XFELD	CHAR	1	0	Display Teams
46	HIDE_ASG_FOL_DEM	☐	/MRSS/T_SGU_HIDE_ASG_FOL_DEM	/MRSS/_BOOLEAN	CHAR	1	0	Hide Assignment follows demand checkbox
47	OPTIMIZER_PRVENT	☐	/MRSS/T_OPTIMIZER_PREVENT	/MRSS/_BOOLEAN	CHAR	1	0	Hide Optimization Icon in Planning Board
48	HIDE_TEAM_MEM	☐	/MRSS/T_HIDE_LITERAL_TEAM_MEM	/MRSS/_BOOLEAN	CHAR	1	0	Display Team Name Only
49	ASG_AT_DROP_TIME	☐	/MRSS/T_SGU_ASG_ON_DROP_TIME	XFIELD	CHAR	1	0	Create Assignment for the Time Slot onto Which It Is Dropped
50	NUM_PROPOSAL	☐	/MRSS/T_SGU_NUM_PROPOSAL	NUMC2	NUMC	2	0	Number of Proposed Slots for Shifting Demands
51	AVAIL_VIEW_DEFAU	☐	/MRSS/T_SGU_AVAIL_VIEW_DEFAULT	/MRSS/_BOOLEAN	CHAR	1	0	Set Availability View as Default
52	SHOW_ASSOC_RES	☐	/MRSS/T_SGU_SHOW_ASSOC_RES	/MRSS/_SGU_SHOW_ASSOC_RES	CHAR	1	0	Show Resources
53	SHOW_ASSOC_DEM	☐	/MRSS/T_SGU_SHOW_ASSOC_DEM	/MRSS/_SGU_SHOW_ASSOC_DEM	CHAR	1	0	Show Demands
54	SHOW_ASC_DEM_MGR	☐	/MRSS/T_SGU_SHOW_ASSOC_DEM_MGR	/MRSS/_SGU_SHOW_ASSOC_DEM_MGR	CHAR	1	0	Show Demands in Manager Planning Board
55	SHIFT_TIMEZONE	☐	/MRSS/T_SGU_SHIFTTMZN	/MRSS/_SGU_SHIFTTMZN	CHAR	1	0	Activate Alternative Time Zone
56	SHOW_AVAIL_VIEW	☐	/MRSS/T_SGU_SHOW_AVAIL_VIEW	/MRSS/_BOOLEAN	CHAR	1	0	Show Availability View Button in Planning Board
57	CONSIDER_NON_GAN	☐	/MRSS/T_SGU_NON_GANTT_PUSH_BTN	/MRSS/_BOOLEAN	CHAR	1	0	Consider Order and Item Worklists for Status Buttons
58	RET_ONLY_ERR_MSG	☐	/MRSS/T_RETURN_ONLY_ERROR_MSG	/MRSS/_BOOLEAN	CHAR	1	0	Suppress Information and Warning Messages in Planning Board

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/MRSS/V_SGU_PRO	PRF_GRUPPE	TBCG	PRF_GRUPPE
2	/MRSS/V_SGU_PRO	PRF_INDEX	TBCG	PRF_INDEX
3	/MRSS/V_SGU_PRO	PRF_NAME	TBCG	PRF_NAME

History

Last changed by/on	DDIC	20141109
SAP Release Created in