SAP ABAP Table /MRSS/T_SGW_COMM_DATA_LIST (Communication Table for Data Display)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC (Application Component) Maintenance Processing
     ⤷ /MRSS/SGW (Package) MRS Planning Board Web Interface

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_SGW_COMM_DATA_LIST	Table Relationship Diagram
Short Description	Communication Table for Data Display

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	DEMAND_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
2	DEMAND_ID	☐	/MRSS/T_DEM_I_ID	CHAR25	CHAR	25	0	Demand Item ID
3	ASSIGNMENT_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
4	RESOURCE_GUID	☐	/MRSS/T_GUID_RES	SYSUUID	RAW	16	0	Resource GUID
5	ASSIGNMENT_NAME	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
6	RESOURCE_NAME	☐	/MRSS/T_SGU_RESOURCENAME	TEXT40	CHAR	40	0	Resource Name
7	BEGDA	☐	/MRSS/T_SGU_BEGDA	DATUM	DATS	8	0	Start date
8	BEG_UZEIT	☐	/MRSS/T_SGU_BEG_UZEIT	UZEIT	TIMS	6	0	Start Time
9	ENDDA	☐	/MRSS/T_SGU_ENDDA	DATUM	DATS	8	0	End date
10	END_UZEIT	☐	/MRSS/T_SGU_END_UZEIT	UZEIT	TIMS	6	0	End Time
11	DURATION	☐	/MRSS/T_SGE_DURAT		DEC	13	3	Duration for staffing table
12	DURATION_UNIT	☐	/MRSS/T_SGU_DURATION_UNIT	/MRSS/_SGU_DURATION_UNIT	CHAR	3	0	Time Unit
13	STATUS	☐	/MRSS/T_SGU_DATA_LIST_STATUS	/MRSS/_SGU_DATA_LIST_STATUS	CHAR	80	0	Entry Status
14	ASSGN_STATUS	☐	/MRSS/T_SGU_ASSIGNMENT_STAT	CHAR132	CHAR	132	0	Assignment status
15	ASSIGNMENT_TYPE	☐	/MRSS/T_SGE_ASSIGNMENT_TYPE	/MRSS/_SGE_ASSIGNMENT_TYPE	CHAR	1	0	Assignment category
16	UTILIZ	☐	/MRSS/T_UTILISATION	/MRSS/_UITLISATION	DEC	3	0	Resource Utilization
17	STATUS_TAB	☐	/MRSS/T_STATUS_TAB		TTYP	0	0
18	TEAM_MEMBERS	☐	/MRSS/T_SGU_COMM_TEAM_TAB		TTYP	0	0
19	NEW_STAT	☐	/MRSS/T_STATUSES		STRU	0	0
20	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
21	TABNO	☐	/MRSS/T_TABNO	/MRSS/_TABNO	NUMC	2	0	Tab Page Number
22	BUTTON	☐	/MRSS/T_BUTTON	/MRSS/T_BUTTON	CHAR	20	0	Status
23	STATUS_ORIGIN	☐	/MRSS/T_SGE_STATUS_ORIGIN	/MRSS/_SGE_STATUS_ORIGIN	CHAR	1	0	Status: origin
24	STATUS_TYPE	☐	/MRSS/T_STATUS_TYPE	/MRSS/_STATUS_TYPE	CHAR	10	0	Type of Abstract MRS Status
25	ICON	☐	/MRSS/T_ICON_D	ICON	CHAR	4	0	Display on Pushbuttons
26	ON_CONTEXT_MENU	☐	/MRSS/T_ON_CONTEXT	/MRSS/_BOOLEAN	CHAR	1	0	Display status in context menu
27	MENU_ID	☐	/MRSS/T_MENU_ID	/MRSS/_MENU_ID	CHAR	8	0	Menu ID for context menu
28	SAVE_PLB	☐	/MRSS/T_SAVE_PLB	/MRSS/_BOOLEAN	CHAR	1	0	Save the planning board after the status is set
29	RELEVANCE	☐	/MRSS/T_STAT_RELEVANCE	/MRSS/_DEM_TYPE	CHAR	4	0	Assignment Status Relevance - Based on Demand Type
30	ON_APP_TOOLBAR	☐	/MRSS/ON_APP	/MRSS/_BOOLEAN	CHAR	1	0	Display status button on application toolbar
31	CHANGE_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
32	DELETE_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
33	ASSIGNMENT_TYP_DESC	☐			STRG	0	0
34	DEM1_MULT_SLOTS	☐	/MRSS/T_SGE_MULT_SLOTS	/MRSS/_SGE_MULT_SLOTS	NUMC	3	0	Multiple Slots For a Demand
35	RESOURCES	☐	/MRSS/T_GUID_TAB		TTYP	0	0
36	NOTE	☐	/MRSS/T_ASSIGNMENT_NOTE	/MRSS/_SGE_SSTRING	SSTR	255	0	Assignment Note
37	IS_RES_FIXED	☐	/MRSS/T_SGX_FIX_RESOURCE	/MRSS/_BOOLEAN	CHAR	1	0	Fixed Resource
38	IS_DATE_FIXED	☐	/MRSS/T_SGX_FIX_DATES	/MRSS/_BOOLEAN	CHAR	1	0	Fixed Dates
39	ASG_FOLLOWS_DEMAND	☐	/MRSS/T_SGX_ASG_FOLLOWS_DEM	/MRSS/_BOOLEAN	CHAR	1	0	Assignment Follows Demand
40	.INCLUDE	☐				0	0	Travel time
41	TRV_TO_BEGIN_DATE	☐	/MRSS/T_TRV_TO_BEGIN_DATE	DATS	DATS	8	0	Start of Arrival (Date)
42	TRV_TO_BEGIN_TIME	☐	/MRSS/T_TRV_TO_BEGIN_TIME		TIMS	6	0	Start of Arrival (Time)
43	TRV_TO_END_DATE	☐	/MRSS/T_TRV_TO_END_DATE	DATS	DATS	8	0	End of Arrival (Date)
44	TRV_TO_END_TIME	☐	/MRSS/T_TRV_TO_END_TIME		TIMS	6	0	End of Arrival (Time)
45	TRV_TO_DURATION	☐	/MRSS/T_SGX_TRV_TO_DURATION		DEC	10	2	Travel Time Duration
46	TRV_TO_DURATION_UNIT	☐	/MRSS/T_SGX_TRV_TO_DURA_UNIT	/MRSS/_SGX_DURATION_UNIT	CHAR	3	0	Time Unit
47	TRV_TO_DISTANCE	☐	/MRSS/T_SGX_TRV_TO_DISTANCE		DEC	10	2	Travel Distance
48	TRV_TO_DIS_UNIT	☐	/MRSS/T_SGX_TRV_TO_DIST_UNIT	/MRSS/_SGX_TRV_DISTANCE_UNIT	CHAR	3	0	Travel Distance Unit
49	TRV_TO_AUTOMATIC	☐	/MRSS/T_SGX_TRV_TO_AUTOMATIC	/MRSS/_BOOLEAN	CHAR	1	0	Calculate Arrival Time Automatically
50	TRV_TO_PROFILE	☐	/MRSS/T_TRV_PROFILE_KEY	/MRSS/_TRAVEL_PROFILE	CHAR	10	0	Travel-type profile key
51	TRAVEL_TIME_MODE	☐	/MRSS/T_TRV_MODE	/MRSS/_TRV_MODE	CHAR	1	0	Travel Time Mode
52	TRV_FROM_BEGIN_DATE	☐	/MRSS/T_TRV_FROM_BEGIN_DATE	DATS	DATS	8	0	Start of Departure (Date)
53	TRV_FROM_BEGIN_TIME	☐	/MRSS/T_TRV_FROM_BEGIN_TIME		TIMS	6	0	Start of Departure (Time)
54	TRV_FROM_END_DATE	☐	/MRSS/T_TRV_FROM_END_DATE	DATS	DATS	8	0	End of Departure (Date)
55	TRV_FROM_END_TIME	☐	/MRSS/T_TRV_FROM_END_TIME		TIMS	6	0	End of Departure (Time)
56	TRV_FROM_DURATION	☐	/MRSS/T_SGX_TRV_FROM_DURATION		DEC	10	2	Travel Duration
57	TRV_FROM_DURATION_UNIT	☐	/MRSS/T_SGX_TRV_FROM_DURA_UNIT	/MRSS/_SGX_DURATION_UNIT	CHAR	3	0	Travel Duration Unit
58	TRV_FROM_DISTANCE	☐	/MRSS/T_SGX_TRV_FROM_DISTANCE		DEC	10	2	Travel Distance
59	TRV_FROM_DIS_UNIT	☐	/MRSS/T_SGX_TRV_FROM_DIST_UNIT	/MRSS/_SGX_TRV_DISTANCE_UNIT	CHAR	3	0	Travel Distance Unit
60	TRV_FROM_AUTOMATIC	☐	/MRSS/T_SGX_TRV_FROM_AUTOMATIC	/MRSS/_BOOLEAN	CHAR	1	0	Calculate Departure Time Automatically
61	TRV_FROM_PROFILE	☐	/MRSS/T_TRV_PROFILE_KEY	/MRSS/_TRAVEL_PROFILE	CHAR	10	0	Travel-type profile key
62	.INCLUDE	☐				0	0	Process Time (Preparation and Wrap-up) for External Display
63	PREP_START_DATE	☐	/MRSS/T_PREP_START_DATE	DATS	DATS	8	0	Start of Preparation Phase
64	PREP_START_TIME	☐	/MRSS/T_PREP_START_TIME		TIMS	6	0	Start Time of Preparation
65	PREP_END_DATE	☐	/MRSS/T_PREP_END_DATE	DATS	DATS	8	0	End of Preparation Phase
66	PREP_END_TIME	☐	/MRSS/T_PREP_END_TIME		TIMS	6	0	End Time of Preparation
67	PREP_DURATION	☐	/MRSS/T_SGE_PREP_DURATION	/MRSS/_SGE_PREP_DURATION	DEC	10	2	Duration of Preparation Phase
68	PREP_DURATION_UNIT	☐	/MRSS/T_SGU_DURATION_UNIT	/MRSS/_SGU_DURATION_UNIT	CHAR	3	0	Time Unit
69	WRAP_UP_START_DATE	☐	/MRSS/T_WRAP_UP_START_DATE	DATS	DATS	8	0	Start of Wrap-Up Phase
70	WRAP_UP_START_TIME	☐	/MRSS/T_WRAP_UP_START_TIME		TIMS	6	0	Start Time of Wrap-up
71	WRAP_UP_END_DATE	☐	/MRSS/T_WRAP_UP_END_DATE	DATS	DATS	8	0	End of Wrap-Up Phase
72	WRAP_UP_END_TIME	☐	/MRSS/T_WRAP_UP_END_TIME		TIMS	6	0	End Time of Wrap-up
73	WRAP_UP_DURATION	☐	/MRSS/T_SGE_WRAP_UP_DURATION	/MRSS/_SGE_WRAP_UP_DURATION	DEC	10	2	Duration of Wrap-Up Phase
74	WRAP_UP_DURATION_UNIT	☐	/MRSS/T_SGU_DURATION_UNIT	/MRSS/_SGU_DURATION_UNIT	CHAR	3	0	Time Unit

History

Last changed by/on	SAP	20141109
SAP Release Created in	610