SAP ABAP Table /MRSS/T_API_ASSMNT_EXP (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_API_ASSMNT_EXP	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	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
3	RESOURCE_KEY	☐	/MRSS/T_GUID_RES	SYSUUID	RAW	16	0	Resource GUID
4	BEG_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
5	END_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
6	DURATION	☐	INT4	INT4	INT4	10	0	Natural number
7	UTIL	☐	/MRSS/T_UTILISATION	/MRSS/_UITLISATION	DEC	3	0	Resource Utilization
8	APPL_STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
9	STATUS_TAB	☐	/MRSS/T_STATUS_TAB		TTYP	0	0
10	DESCRIPTION	☐	TEXT120	TEXT120	CHAR	120	0	Text (Length 120)
11	.INCLUDE	☐				0	0	Additional Info for Assignment
12	ASS_PROB	☐	/MRSS/T_ASS_PROB	NUMC3	NUMC	3	0	Assignment Probability
13	NO_TRAVEL_COST	☐	/MRSS/T_NO_TRAVEL_COST	BOOLEAN	CHAR	1	0	No Travel Cost Indicator
14	MOBILE_INDICATOR	☐	/MRSS/T_SEND_TO_MOBILE	BOOLEAN	CHAR	1	0	Send To Mobile Solution
15	ASS_SUPERVISOR	☐	/MRSS/T_ASG_SUPERVISOR	/MRSS/_BOOLEAN	CHAR	1	0	Site Supervisor of Assignment
16	RES_UTIL_RAT	☐	/MRSS/T_WFM_UTILISATION		FLTP	16	16	Capacity Level
17	RES_UTIL_RAT_ORG	☐	/MRSS/T_UTIL_RAT_ORG	CHAR1	CHAR	1	0	Origin of Resource utilization ratio
18	PART_CONC_ATTR	☐	/MRSS/T_ASG_INFX_TAB		TTYP	0	0
19	TRAVEL_TIME_MODE	☐	/MRSS/T_TRV_MODE	/MRSS/_TRV_MODE	CHAR	1	0	Travel Time Mode
20	TRV_DISPLAY_TO	☐	/MRSS/T_TRV_DISPLAY_TO	/MRSS/_BOOLEAN	CHAR	1	0	Display Travel Times (Arrival)
21	TRV_DISPLAY_FROM	☐	/MRSS/T_TRV_DISPLAY_FROM	/MRSS/_BOOLEAN	CHAR	1	0	Display Travel Times (Departure)
22	IS_RES_FIXED	☐	/MRSS/T_SGE_FIX_RESOURCE	/MRSS/_BOOLEAN	CHAR	1	0	Fix Resource
23	IS_DATE_FIXED	☐	/MRSS/T_SGE_FIX_DATES	/MRSS/_BOOLEAN	CHAR	1	0	Fix the dates
24	UTILIZ	☐	/MRSS/T_UTILISATION	/MRSS/_UITLISATION	DEC	3	0	Resource Utilization
25	PARENT_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
26	TIME_RULE_ID	☐	/MRSS/T_TIME_RULE_ID	TEXT25	CHAR	25	0	Time Rule Id
27	IS_CHILD	☐	/MRSS/T_BOOLEAN	/MRSS/_BOOLEAN	CHAR	1	0	Boolean Variable
28	SETTLEMENT_TYPE	☐	/MRSS/T_SETTLEMENT_TYPE	/MRSS/_SETTLEMENT_TYPE	CHAR	1	0	Assignment Settlement Type
29	SPLIT_NUMBER	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)
30	MULT_SLOTS	☐	/MRSS/T_SGE_MULT_SLOTS	/MRSS/_SGE_MULT_SLOTS	NUMC	3	0	Multiple Slots For a Demand
31	ASG_FOLLOWS_DEMAND	☐	/MRSS/T_SGE_ASG_FOLLOWS_DEM	/MRSS/_BOOLEAN	CHAR	1	0	Assignment Follows Demand
32	.INCLUDE	☐				0	0	Addnl Info fields for Assignment - Customer Include
33	DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
34	.INCLUDE	☐				0	0
35	.INCLUDE	☐				0	0	Administrative Data for Assignment
36	ASSIGNMENT_TYPE	☐	/MRSS/T_SGE_ASSIGNMENT_TYPE	/MRSS/_SGE_ASSIGNMENT_TYPE	CHAR	1	0	Assignment category
37	DEMAND	☐	/MRSS/T_SGE_INH_ASS_FROM_DEM		STRU	0	0
38	STATUS_TAB	☐	/MRSS/T_STATUS_TAB		TTYP	0	0
39	SUPERVISOR	☐	/MRSS/T_DEM_SUPERVISOR	/MRSS/_DEM_SUPERVISOR	CHAR	1	0	Site supervisor indicator of demand
40	MOBILE_STATUS	☐	/MRSS/T_MOBILE_STATUS	CHAR4	CHAR	4	0	Assignment Status for Mobile Device
41	CREATED	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
42	CREATED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
43	CHANGED	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
44	CHANGED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
45	.INCLUDE	☐				0	0	Travel Time for Use in API
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_MANU_SET	☐	/MRSS/T_TRV_TO_MANUALLY_SET	/MRSS/_BOOLEAN	CHAR	1	0	Arrival Set Manually
52	TRV_FRM_BEGIN	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
53	TRV_FRM_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
54	TRV_FRM_DURATION	☐	/MRSS/T_TRV_FROM_DURATION	INT4	INT4	10	0	Departure Duration
55	TRV_FRM_DUR_UNIT	☐	/MRSS/T_TRV_FROM_DURATION_UNIT	MEINS	UNIT	3	0	Departure Duration (Unit)	*
56	TRV_FRM_DISTANCE	☐	/MRSS/T_TRV_FROM_DISTANCE	GEODIST	DEC	15	6	Departure Distance
57	TRV_FRM_MANU_SET	☐	/MRSS/T_TRV_FROM_MANUALLY_SET	/MRSS/_BOOLEAN	CHAR	1	0	Departure Set Manually
58	.INCLUDE	☐				0	0	OBSOLETE DDIC STRCUTURE - NOT IN USE
59	MOB_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
60	MOB_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
61	MOB_DURATION	☐	/MRSS/T_MOB_DURATION	INT4	INT4	10	0	Mobilization Duration
62	DEMOB_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
63	DEMOB_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
64	DEMOB_DURATION	☐	/MRSS/T_DEMOB_DURATION	INT4	INT4	10	0	Demobilization Duration

History

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