SAP ABAP Table /MRSS/T_SGE_RES_ASSGN_LIST (Resource Assignment list)
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_SGE_RES_ASSGN_LIST   Table Relationship Diagram
Short Description Resource Assignment list    
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 APPL_STATUS J_ISTAT J_ISTAT CHAR 5   0   System status *
10 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
11 DESCRIPTION TEXT120 TEXT120 CHAR 120   0   Text (Length 120)  
12 .INCLUDE       0   0   Additional Info for Assignment  
13 ASS_PROB /MRSS/T_ASS_PROB NUMC3 NUMC 3   0   Assignment Probability  
14 NO_TRAVEL_COST /MRSS/T_NO_TRAVEL_COST BOOLEAN CHAR 1   0   No Travel Cost Indicator  
15 MOBILE_INDICATOR /MRSS/T_SEND_TO_MOBILE BOOLEAN CHAR 1   0   Send To Mobile Solution  
16 ASS_SUPERVISOR /MRSS/T_ASG_SUPERVISOR /MRSS/_BOOLEAN CHAR 1   0   Site Supervisor of Assignment  
17 RES_UTIL_RAT /MRSS/T_WFM_UTILISATION   FLTP 16   16   Capacity Level  
18 RES_UTIL_RAT_ORG /MRSS/T_UTIL_RAT_ORG CHAR1 CHAR 1   0   Origin of Resource utilization ratio  
19 PART_CONC_ATTR /MRSS/T_ASG_INFX_TAB   TTYP 0   0    
20 TRAVEL_TIME_MODE /MRSS/T_TRV_MODE /MRSS/_TRV_MODE CHAR 1   0   Travel Time Mode  
21 TRV_DISPLAY_TO /MRSS/T_TRV_DISPLAY_TO /MRSS/_BOOLEAN CHAR 1   0   Display Travel Times (Arrival)  
22 TRV_DISPLAY_FROM /MRSS/T_TRV_DISPLAY_FROM /MRSS/_BOOLEAN CHAR 1   0   Display Travel Times (Departure)  
23 IS_RES_FIXED /MRSS/T_SGE_FIX_RESOURCE /MRSS/_BOOLEAN CHAR 1   0   Fix Resource  
24 IS_DATE_FIXED /MRSS/T_SGE_FIX_DATES /MRSS/_BOOLEAN CHAR 1   0   Fix the dates  
25 UTILIZ /MRSS/T_UTILISATION /MRSS/_UITLISATION DEC 3   0   Resource Utilization  
26 PARENT_GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
27 TIME_RULE_ID /MRSS/T_TIME_RULE_ID TEXT25 CHAR 25   0   Time Rule Id  
28 IS_CHILD /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
29 SETTLEMENT_TYPE /MRSS/T_SETTLEMENT_TYPE /MRSS/_SETTLEMENT_TYPE CHAR 1   0   Assignment Settlement Type  
30 SPLIT_NUMBER INT1 INT1 INT1 3   0   Dummy for B20 int1 (Local Everywhere)  
31 MULT_SLOTS /MRSS/T_SGE_MULT_SLOTS /MRSS/_SGE_MULT_SLOTS NUMC 3   0   Multiple Slots For a Demand  
32 ASG_FOLLOWS_DEMAND /MRSS/T_SGE_ASG_FOLLOWS_DEM /MRSS/_BOOLEAN CHAR 1   0   Assignment Follows Demand  
33 .INCLUDE       0   0   Addnl Info fields for Assignment - Customer Include  
34 DUMMY CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
35 .INCLUDE       0   0    
36 .INCLUDE       0   0   Administrative Data for Assignment  
37 ASSIGNMENT_TYPE /MRSS/T_SGE_ASSIGNMENT_TYPE /MRSS/_SGE_ASSIGNMENT_TYPE CHAR 1   0   Assignment category  
38 DEMAND /MRSS/T_SGE_INH_ASS_FROM_DEM   STRU 0   0    
39 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
40 SUPERVISOR /MRSS/T_DEM_SUPERVISOR /MRSS/_DEM_SUPERVISOR CHAR 1   0   Site supervisor indicator of demand  
41 MOBILE_STATUS /MRSS/T_MOBILE_STATUS CHAR4 CHAR 4   0   Assignment Status for Mobile Device  
42 CREATED TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
43 CREATED_BY SYUNAME SYCHAR12 CHAR 12   0   User Name  
44 CHANGED TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
45 CHANGED_BY SYUNAME SYCHAR12 CHAR 12   0   User Name  
46 .INCLUDE       0   0   Travel Time for Use in API  
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_MANU_SET /MRSS/T_TRV_TO_MANUALLY_SET /MRSS/_BOOLEAN CHAR 1   0   Arrival Set Manually  
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_MANU_SET /MRSS/T_TRV_FROM_MANUALLY_SET /MRSS/_BOOLEAN CHAR 1   0   Departure Set Manually  
59 .INCLUDE       0   0   OBSOLETE DDIC STRCUTURE - NOT IN USE  
60 MOB_START TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
61 MOB_END TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
62 MOB_DURATION /MRSS/T_MOB_DURATION INT4 INT4 10   0   Mobilization Duration  
63 DEMOB_START TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
64 DEMOB_END TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
65 DEMOB_DURATION /MRSS/T_DEMOB_DURATION INT4 INT4 10   0   Demobilization Duration  
66 BEGDA /MRSS/T_SGU_BEGDA DATUM DATS 8   0   Start date  
67 BEG_UZEIT /MRSS/T_SGU_BEG_UZEIT UZEIT TIMS 6   0   Start Time  
68 ENDDA /MRSS/T_SGU_ENDDA DATUM DATS 8   0   End date  
69 END_UZEIT /MRSS/T_SGU_END_UZEIT UZEIT TIMS 6   0   End Time  
70 DURAT /MRSS/T_SGE_DURAT   DEC 13   3   Duration for staffing table  
71 DURAT_UNIT /MRSS/T_SGU_DURATION_UNIT /MRSS/_SGU_DURATION_UNIT CHAR 3   0   Time Unit  
72 STATUS /MRSS/T_SGU_DATA_LIST_STATUS /MRSS/_SGU_DATA_LIST_STATUS CHAR 80   0   Entry Status  
73 ASSGN_STATUS /MRSS/T_SGU_ASSIGNMENT_STAT CHAR132 CHAR 132   0   Assignment status  
History
Last changed by/on SAP  20141109 
SAP Release Created in 610