SAP ABAP Table /MRSS/T_ASS_WRK (Work Structure for Assignment Operations)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ /MRSS/SGE (Package) Multiresource Planning: Scheduling Engine

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_ASS_WRK	Table Relationship Diagram
Short Description	Work Structure for Assignment Operations

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	OPERATION	☐	/MRSS/T_SGE_OPERATION	/MRSS/_SGE_OPERATION	CHAR	1	0	Command Operation
2	RESOURCE	☐	/MRSS/CL_SGE_SINGLE_RESOURCE		REF	0	0
3	DEMAND	☐	/MRSS/IF_SGE_SINGLE_DEMAND		REF	0	0
4	DATA	☐	/MRSS/T_ASSIGNMENT_INT		STRU	0	0
5	ASSIGNMENT_KEY	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
6	DEMAND_KEY	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
7	RESOURCE_KEY	☐	/MRSS/T_GUID_RES	SYSUUID	RAW	16	0	Resource GUID
8	BEG_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	END_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	DURATION	☐	INT4	INT4	INT4	10	0	Natural number
11	UTIL	☐	/MRSS/T_UTILISATION	/MRSS/_UITLISATION	DEC	3	0	Resource Utilization
12	NOTE	☐	/MRSS/T_ASSIGNMENT_NOTE	/MRSS/_SGE_SSTRING	SSTR	255	0	Assignment Note
13	APPL_STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status
14	STATUS_TAB	☐	/MRSS/T_STATUS_TAB		TTYP	0	0
15	PLANNING_TYPE	☐	/MRSS/T_PLANNING_TYPE_CODE	/MRSS/PLANNING_TYPE_CODE	CHAR	1	0	Planning Type Code for Assignment Time Unit
16	PLANNING_UNIT	☐	/MRSS/T_PLANNING_TIME_UNIT	MEINS	UNIT	3	0	Internal Time Unit
17	DESCRIPTION	☐	TEXT120	TEXT120	CHAR	120	0	Text (Length 120)
18	ASG_FROM_AUT_SCHED	☐	/MRSS/T_SGE_ASG_FROM_AUT_SCHED	BOOL	CHAR	3	0	Flags an Automatically Scheduled Assignment
19	.INCLUDE	☐				0	0	Additional Info for Assignment
20	ASS_PROB	☐	/MRSS/T_ASS_PROB	NUMC3	NUMC	3	0	Assignment Probability
21	NO_TRAVEL_COST	☐	/MRSS/T_NO_TRAVEL_COST	BOOLEAN	CHAR	1	0	No Travel Cost Indicator
22	MOBILE_INDICATOR	☐	/MRSS/T_SEND_TO_MOBILE	BOOLEAN	CHAR	1	0	Send To Mobile Solution
23	ASS_SUPERVISOR	☐	/MRSS/T_ASG_SUPERVISOR	/MRSS/_BOOLEAN	CHAR	1	0	Site Supervisor of Assignment
24	RES_UTIL_RAT	☐	/MRSS/T_WFM_UTILISATION		FLTP	16	16	Capacity Level
25	RES_UTIL_RAT_ORG	☐	/MRSS/T_UTIL_RAT_ORG	CHAR1	CHAR	1	0	Origin of Resource utilization ratio
26	PART_CONC_ATTR	☐	/MRSS/T_ASG_INFX_TAB		TTYP	0	0
27	TRAVEL_TIME_MODE	☐	/MRSS/T_TRV_MODE	/MRSS/_TRV_MODE	CHAR	1	0	Travel Time Mode
28	TRV_DISPLAY_TO	☐	/MRSS/T_TRV_DISPLAY_TO	/MRSS/_BOOLEAN	CHAR	1	0	Display Travel Times (Arrival)
29	TRV_DISPLAY_FROM	☐	/MRSS/T_TRV_DISPLAY_FROM	/MRSS/_BOOLEAN	CHAR	1	0	Display Travel Times (Departure)
30	IS_RES_FIXED	☐	/MRSS/T_SGE_FIX_RESOURCE	/MRSS/_BOOLEAN	CHAR	1	0	Fix Resource
31	IS_DATE_FIXED	☐	/MRSS/T_SGE_FIX_DATES	/MRSS/_BOOLEAN	CHAR	1	0	Fix the dates
32	UTILIZ	☐	/MRSS/T_UTILISATION	/MRSS/_UITLISATION	DEC	3	0	Resource Utilization
33	PARENT_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
34	TIME_RULE_ID	☐	/MRSS/T_TIME_RULE_ID	TEXT25	CHAR	25	0	Time Rule Id
35	IS_CHILD	☐	/MRSS/T_BOOLEAN	/MRSS/_BOOLEAN	CHAR	1	0	Boolean Variable
36	SETTLEMENT_TYPE	☐	/MRSS/T_SETTLEMENT_TYPE	/MRSS/_SETTLEMENT_TYPE	CHAR	1	0	Assignment Settlement Type
37	SPLIT_NUMBER	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)
38	MULT_SLOTS	☐	/MRSS/T_SGE_MULT_SLOTS	/MRSS/_SGE_MULT_SLOTS	NUMC	3	0	Multiple Slots For a Demand
39	ASG_FOLLOWS_DEMAND	☐	/MRSS/T_SGE_ASG_FOLLOWS_DEM	/MRSS/_BOOLEAN	CHAR	1	0	Assignment Follows Demand
40	.INCLUDE	☐				0	0	Addnl Info fields for Assignment - Customer Include
41	DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
42	.INCLUDE	☐				0	0
43	.INCLUDE	☐				0	0	Administrative Data for Assignment
44	ASSIGNMENT_TYPE	☐	/MRSS/T_SGE_ASSIGNMENT_TYPE	/MRSS/_SGE_ASSIGNMENT_TYPE	CHAR	1	0	Assignment category
45	DEMAND	☐	/MRSS/T_SGE_INH_ASS_FROM_DEM		STRU	0	0
46	STATUS_TAB	☐	/MRSS/T_STATUS_TAB		TTYP	0	0
47	SUPERVISOR	☐	/MRSS/T_DEM_SUPERVISOR	/MRSS/_DEM_SUPERVISOR	CHAR	1	0	Site supervisor indicator of demand
48	MOBILE_STATUS	☐	/MRSS/T_MOBILE_STATUS	CHAR4	CHAR	4	0	Assignment Status for Mobile Device
49	.INCLUDE	☐				0	0	Travel Time for Internal Display
50	TRV_TO_BEGIN	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
51	TRV_TO_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
52	TRV_TO_DURATION	☐	/MRSS/T_TRV_TO_DURATION	INT4	INT4	10	0	Arrival Duration
53	TRV_TO_DUR_UNIT	☐	/MRSS/T_TRV_TO_DURATION_UNIT	MEINS	UNIT	3	0	Arrival Duration (Unit)
54	TRV_TO_DISTANCE	☐	/MRSS/T_TRV_TO_DISTANCE	GEODIST	DEC	15	6	Arrival Distance
55	TRV_TO_DIS_UNIT	☐	/MRSS/T_TRV_TO_DISTANCE_UNIT		UNIT	3	0	Travel-to distance unit
56	TRV_TO_MANU_SET	☐	/MRSS/T_TRV_TO_MANUALLY_SET	/MRSS/_BOOLEAN	CHAR	1	0	Arrival Set Manually
57	TRV_TO_PROFILE	☐	/MRSS/T_TRV_PROFILE_KEY	/MRSS/_TRAVEL_PROFILE	CHAR	10	0	Travel-type profile key
58	TRV_FRM_BEGIN	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
59	TRV_FRM_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
60	TRV_FRM_DURATION	☐	/MRSS/T_TRV_FROM_DURATION	INT4	INT4	10	0	Departure Duration
61	TRV_FRM_DUR_UNIT	☐	/MRSS/T_TRV_FROM_DURATION_UNIT	MEINS	UNIT	3	0	Departure Duration (Unit)
62	TRV_FRM_DISTANCE	☐	/MRSS/T_TRV_FROM_DISTANCE	GEODIST	DEC	15	6	Departure Distance
63	TRV_FRM_DIS_UNIT	☐	/MRSS/T_TRV_FROM_DISTANCE_UNIT		UNIT	3	0	Travel-from distance unit
64	TRV_FRM_MANU_SET	☐	/MRSS/T_TRV_FROM_MANUALLY_SET	/MRSS/_BOOLEAN	CHAR	1	0	Departure Set Manually
65	TRV_FRM_PROFILE	☐	/MRSS/T_TRV_PROFILE_KEY	/MRSS/_TRAVEL_PROFILE	CHAR	10	0	Travel-type profile key
66	.INCLUDE	☐				0	0	Process Times (Preparation and Wrap up) for Internal Display
67	PREP_START	☐	/MRSS/T_SGE_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Timestamp (with conv. routine)
68	PREP_END	☐	/MRSS/T_SGE_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Timestamp (with conv. routine)
69	PREP_DURATION	☐	/MRSS/T_PREPARATION_DURATION	INT4	INT4	10	0	Preparation Duration
70	WRAP_UP_START	☐	/MRSS/T_SGE_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Timestamp (with conv. routine)
71	WRAP_UP_END	☐	/MRSS/T_SGE_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Timestamp (with conv. routine)
72	WRAP_UP_DURATION	☐	/MRSS/T_WRAP_UP_DURATION	INT4	INT4	10	0	Wrap up Duration

History

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