SAP ABAP Table /MRSS/T_ASS_KEY_EXT (Internal Format of Assignment)

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