SAP ABAP Table /MRSS/T_NW_ASSIGNMENT_DATA (Assignment data from MRS)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ /MRSS/NW_INTERACTION (Package) Interaction Layer for MRS NW Add on

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_NW_ASSIGNMENT_DATA	Table Relationship Diagram
Short Description	Assignment data from MRS

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

History

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