SAP ABAP Table /MRSS/T_ASG_KEY_EXT_WRK (Work structure for assignment)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ CA-MRS (Application Component) SAP Multiresource Scheduling
     ⤷ /MRSS/INTEGRATION (Package) Package for MRS <-> Demand Source System Integration

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_ASG_KEY_EXT_WRK	Table Relationship Diagram
Short Description	Work structure for assignment

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_EXT	☐	/MRSS/T_DEM_KEY_EXT	CHAR60	CHAR	60	0	External Demand Key
4	DEMAND_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
5	RESOURCE_KEY	☐	/MRSS/T_GUID_RES	SYSUUID	RAW	16	0	Resource GUID
6	BEG_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
7	END_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8	DURATION	☐	INT4	INT4	INT4	10	0	Natural number
9	UTIL	☐	/MRSS/T_UTILISATION	/MRSS/_UITLISATION	DEC	3	0	Resource Utilization
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	.INCLUDE	☐				0	0	Additional Info for Assignment
16	ASS_PROB	☐	/MRSS/T_ASS_PROB	NUMC3	NUMC	3	0	Assignment Probability
17	NO_TRAVEL_COST	☐	/MRSS/T_NO_TRAVEL_COST	BOOLEAN	CHAR	1	0	No Travel Cost Indicator
18	MOBILE_INDICATOR	☐	/MRSS/T_SEND_TO_MOBILE	BOOLEAN	CHAR	1	0	Send To Mobile Solution
19	ASS_SUPERVISOR	☐	/MRSS/T_ASG_SUPERVISOR	/MRSS/_BOOLEAN	CHAR	1	0	Site Supervisor of Assignment
20	RES_UTIL_RAT	☐	/MRSS/T_WFM_UTILISATION		FLTP	16	16	Capacity Level
21	RES_UTIL_RAT_ORG	☐	/MRSS/T_UTIL_RAT_ORG	CHAR1	CHAR	1	0	Origin of Resource utilization ratio
22	PART_CONC_ATTR	☐	/MRSS/T_ASG_INFX_TAB		TTYP	0	0
23	TRAVEL_TIME_MODE	☐	/MRSS/T_TRV_MODE	/MRSS/_TRV_MODE	CHAR	1	0	Travel Time Mode
24	TRV_DISPLAY_TO	☐	/MRSS/T_TRV_DISPLAY_TO	/MRSS/_BOOLEAN	CHAR	1	0	Display Travel Times (Arrival)
25	TRV_DISPLAY_FROM	☐	/MRSS/T_TRV_DISPLAY_FROM	/MRSS/_BOOLEAN	CHAR	1	0	Display Travel Times (Departure)
26	IS_RES_FIXED	☐	/MRSS/T_SGE_FIX_RESOURCE	/MRSS/_BOOLEAN	CHAR	1	0	Fix Resource
27	IS_DATE_FIXED	☐	/MRSS/T_SGE_FIX_DATES	/MRSS/_BOOLEAN	CHAR	1	0	Fix the dates
28	UTILIZ	☐	/MRSS/T_UTILISATION	/MRSS/_UITLISATION	DEC	3	0	Resource Utilization
29	PARENT_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
30	TIME_RULE_ID	☐	/MRSS/T_TIME_RULE_ID	TEXT25	CHAR	25	0	Time Rule Id
31	IS_CHILD	☐	/MRSS/T_BOOLEAN	/MRSS/_BOOLEAN	CHAR	1	0	Boolean Variable
32	SETTLEMENT_TYPE	☐	/MRSS/T_SETTLEMENT_TYPE	/MRSS/_SETTLEMENT_TYPE	CHAR	1	0	Assignment Settlement Type
33	SPLIT_NUMBER	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)
34	MULT_SLOTS	☐	/MRSS/T_SGE_MULT_SLOTS	/MRSS/_SGE_MULT_SLOTS	NUMC	3	0	Multiple Slots For a Demand
35	ASG_FOLLOWS_DEMAND	☐	/MRSS/T_SGE_ASG_FOLLOWS_DEM	/MRSS/_BOOLEAN	CHAR	1	0	Assignment Follows Demand
36	.INCLUDE	☐				0	0	Addnl Info fields for Assignment - Customer Include
37	DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
38	.INCLUDE	☐				0	0
39	TEXT	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
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	.INCLUDE	☐				0	0	Travel Time for Internal Display
46	TRV_TO_BEGIN	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
47	TRV_TO_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
48	TRV_TO_DURATION	☐	/MRSS/T_TRV_TO_DURATION	INT4	INT4	10	0	Arrival Duration
49	TRV_TO_DUR_UNIT	☐	/MRSS/T_TRV_TO_DURATION_UNIT	MEINS	UNIT	3	0	Arrival Duration (Unit)	*
50	TRV_TO_DISTANCE	☐	/MRSS/T_TRV_TO_DISTANCE	GEODIST	DEC	15	6	Arrival Distance
51	TRV_TO_DIS_UNIT	☐	/MRSS/T_TRV_TO_DISTANCE_UNIT		UNIT	3	0	Travel-to distance unit
52	TRV_TO_MANU_SET	☐	/MRSS/T_TRV_TO_MANUALLY_SET	/MRSS/_BOOLEAN	CHAR	1	0	Arrival Set Manually
53	TRV_TO_PROFILE	☐	/MRSS/T_TRV_PROFILE_KEY	/MRSS/_TRAVEL_PROFILE	CHAR	10	0	Travel-type profile key
54	TRV_FRM_BEGIN	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
55	TRV_FRM_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
56	TRV_FRM_DURATION	☐	/MRSS/T_TRV_FROM_DURATION	INT4	INT4	10	0	Departure Duration
57	TRV_FRM_DUR_UNIT	☐	/MRSS/T_TRV_FROM_DURATION_UNIT	MEINS	UNIT	3	0	Departure Duration (Unit)	*
58	TRV_FRM_DISTANCE	☐	/MRSS/T_TRV_FROM_DISTANCE	GEODIST	DEC	15	6	Departure Distance
59	TRV_FRM_DIS_UNIT	☐	/MRSS/T_TRV_FROM_DISTANCE_UNIT		UNIT	3	0	Travel-from distance unit
60	TRV_FRM_MANU_SET	☐	/MRSS/T_TRV_FROM_MANUALLY_SET	/MRSS/_BOOLEAN	CHAR	1	0	Departure Set Manually
61	TRV_FRM_PROFILE	☐	/MRSS/T_TRV_PROFILE_KEY	/MRSS/_TRAVEL_PROFILE	CHAR	10	0	Travel-type profile key
62	.INCLUDE	☐				0	0	Process Times (Preparation and Wrap up) for Internal Display
63	PREP_START	☐	/MRSS/T_SGE_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Timestamp (with conv. routine)
64	PREP_END	☐	/MRSS/T_SGE_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Timestamp (with conv. routine)
65	PREP_DURATION	☐	/MRSS/T_PREPARATION_DURATION	INT4	INT4	10	0	Preparation Duration
66	WRAP_UP_START	☐	/MRSS/T_SGE_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Timestamp (with conv. routine)
67	WRAP_UP_END	☐	/MRSS/T_SGE_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Timestamp (with conv. routine)
68	WRAP_UP_DURATION	☐	/MRSS/T_WRAP_UP_DURATION	INT4	INT4	10	0	Wrap up Duration
69	OPERATION	☐	/MRSS/T_INT_OPERATION	/MRSS/_INT_OPERATION	CHAR	1	0	Command Operation

History

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