SAP ABAP Table /MRSS/T_ASS_DET_EXT (Details for an 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_DET_EXT   Table Relationship Diagram
Short Description Details for an 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   Assignment Data for Display on User Interface  
2 ASSIGNMENT_KEY /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
3 RESOURCE_KEY /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
4 DEMAND_KEY /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
5 .INCLUDE       0   0   Assignment for Display on User Interface  
6 BEGDA DATS DATS DATS 8   0   Field of type DATS  
7 ENDDA DATS DATS DATS 8   0   Field of type DATS  
8 BEG_UZEIT UZEIT UZEIT TIMS 6   0   Time  
9 END_UZEIT UZEIT UZEIT TIMS 6   0   Time  
10 DURATION INT4 INT4 INT4 10   0   Natural number  
11 UTIL /MRSS/T_UTILISATION /MRSS/_UITLISATION DEC 3   0   Resource Utilization  
12 NOTE /MRSS/T_ASSIGNMENT_NOTE /MRSS/_SGE_SSTRING SSTR 255   0   Assignment Note  
13 STATUS J_ISTAT J_ISTAT CHAR 5   0   System status *
14 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
15 PLANNING_TYPE /MRSS/T_PLANNING_TYPE_CODE /MRSS/PLANNING_TYPE_CODE CHAR 1   0   Planning Type Code for Assignment Time Unit  
16 PLANNING_UNIT /MRSS/T_PLANNING_TIME_UNIT MEINS UNIT 3   0   Internal Time Unit *
17 DESCRIPTION TEXT120 TEXT120 CHAR 120   0   Text (Length 120)  
18 .INCLUDE       0   0   Additional Info for Assignment  
19 ASS_PROB /MRSS/T_ASS_PROB NUMC3 NUMC 3   0   Assignment Probability  
20 NO_TRAVEL_COST /MRSS/T_NO_TRAVEL_COST BOOLEAN CHAR 1   0   No Travel Cost Indicator  
21 MOBILE_INDICATOR /MRSS/T_SEND_TO_MOBILE BOOLEAN CHAR 1   0   Send To Mobile Solution  
22 ASS_SUPERVISOR /MRSS/T_ASG_SUPERVISOR /MRSS/_BOOLEAN CHAR 1   0   Site Supervisor of Assignment  
23 RES_UTIL_RAT /MRSS/T_WFM_UTILISATION   FLTP 16   16   Capacity Level  
24 RES_UTIL_RAT_ORG /MRSS/T_UTIL_RAT_ORG CHAR1 CHAR 1   0   Origin of Resource utilization ratio  
25 PART_CONC_ATTR /MRSS/T_ASG_INFX_TAB   TTYP 0   0    
26 TRAVEL_TIME_MODE /MRSS/T_TRV_MODE /MRSS/_TRV_MODE CHAR 1   0   Travel Time Mode  
27 TRV_DISPLAY_TO /MRSS/T_TRV_DISPLAY_TO /MRSS/_BOOLEAN CHAR 1   0   Display Travel Times (Arrival)  
28 TRV_DISPLAY_FROM /MRSS/T_TRV_DISPLAY_FROM /MRSS/_BOOLEAN CHAR 1   0   Display Travel Times (Departure)  
29 IS_RES_FIXED /MRSS/T_SGE_FIX_RESOURCE /MRSS/_BOOLEAN CHAR 1   0   Fix Resource  
30 IS_DATE_FIXED /MRSS/T_SGE_FIX_DATES /MRSS/_BOOLEAN CHAR 1   0   Fix the dates  
31 UTILIZ /MRSS/T_UTILISATION /MRSS/_UITLISATION DEC 3   0   Resource Utilization  
32 PARENT_GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
33 TIME_RULE_ID /MRSS/T_TIME_RULE_ID TEXT25 CHAR 25   0   Time Rule Id  
34 IS_CHILD /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
35 SETTLEMENT_TYPE /MRSS/T_SETTLEMENT_TYPE /MRSS/_SETTLEMENT_TYPE CHAR 1   0   Assignment Settlement Type  
36 SPLIT_NUMBER INT1 INT1 INT1 3   0   Dummy for B20 int1 (Local Everywhere)  
37 MULT_SLOTS /MRSS/T_SGE_MULT_SLOTS /MRSS/_SGE_MULT_SLOTS NUMC 3   0   Multiple Slots For a Demand  
38 ASG_FOLLOWS_DEMAND /MRSS/T_SGE_ASG_FOLLOWS_DEM /MRSS/_BOOLEAN CHAR 1   0   Assignment Follows Demand  
39 .INCLUDE       0   0   Addnl Info fields for Assignment - Customer Include  
40 DUMMY CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
41 .INCLUDE       0   0    
42 MOBILE_STATUS /MRSS/T_MOBILE_STATUS CHAR4 CHAR 4   0   Assignment Status for Mobile Device  
43 .INCLUDE       0   0   Administrative Data for Assignment  
44 ASSIGNMENT_TYPE /MRSS/T_SGE_ASSIGNMENT_TYPE /MRSS/_SGE_ASSIGNMENT_TYPE CHAR 1   0   Assignment category  
45 .INCLUDE       0   0   Travel Time for External Display  
46 TRV_TO_BEGIN_DATE /MRSS/T_TRV_TO_BEGIN_DATE DATS DATS 8   0   Start of Arrival (Date)  
47 TRV_TO_BEGIN_TIME /MRSS/T_TRV_TO_BEGIN_TIME   TIMS 6   0   Start of Arrival (Time)  
48 TRV_TO_END_DATE /MRSS/T_TRV_TO_END_DATE DATS DATS 8   0   End of Arrival (Date)  
49 TRV_TO_END_TIME /MRSS/T_TRV_TO_END_TIME   TIMS 6   0   End of Arrival (Time)  
50 TRV_TO_DURATION /MRSS/T_TRV_TO_DURATION INT4 INT4 10   0   Arrival Duration  
51 TRV_TO_DURATION_UNIT /MRSS/T_TRV_TO_DURATION_UNIT MEINS UNIT 3   0   Arrival Duration (Unit) *
52 TRV_TO_DISTANCE /MRSS/T_TRV_TO_DISTANCE GEODIST DEC 15   6   Arrival Distance  
53 TRV_TO_DIS_UNIT /MRSS/T_TRV_TO_DURATION_UNIT MEINS UNIT 3   0   Arrival Duration (Unit) *
54 TRV_TO_MANUALLY_SET /MRSS/T_TRV_TO_MANUALLY_SET /MRSS/_BOOLEAN CHAR 1   0   Arrival Set Manually  
55 TRV_TO_PROFILE /MRSS/T_TRV_PROFILE_KEY /MRSS/_TRAVEL_PROFILE CHAR 10   0   Travel-type profile key  
56 TRV_FROM_BEGIN_DATE /MRSS/T_TRV_FROM_BEGIN_DATE DATS DATS 8   0   Start of Departure (Date)  
57 TRV_FROM_BEGIN_TIME /MRSS/T_TRV_FROM_BEGIN_TIME   TIMS 6   0   Start of Departure (Time)  
58 TRV_FROM_END_DATE /MRSS/T_TRV_FROM_END_DATE DATS DATS 8   0   End of Departure (Date)  
59 TRV_FROM_END_TIME /MRSS/T_TRV_FROM_END_TIME   TIMS 6   0   End of Departure (Time)  
60 TRV_FROM_DURATION /MRSS/T_TRV_FROM_DURATION INT4 INT4 10   0   Departure Duration  
61 TRV_FROM_DURATION_UNIT /MRSS/T_TRV_FROM_DURATION_UNIT MEINS UNIT 3   0   Departure Duration (Unit) *
62 TRV_FROM_DISTANCE /MRSS/T_TRV_FROM_DISTANCE GEODIST DEC 15   6   Departure Distance  
63 TRV_FROM_DIS_UNIT /MRSS/T_TRV_FROM_DISTANCE_UNIT   UNIT 3   0   Travel-from distance unit  
64 TRV_FROM_MANUALLY_SET /MRSS/T_TRV_FROM_MANUALLY_SET /MRSS/_BOOLEAN CHAR 1   0   Departure Set Manually  
65 TRV_FROM_PROFILE /MRSS/T_TRV_PROFILE_KEY /MRSS/_TRAVEL_PROFILE CHAR 10   0   Travel-type profile key  
66 .INCLUDE       0   0   Process Time (Preparation and Wrap-up) for External Display  
67 PREP_START_DATE /MRSS/T_PREP_START_DATE DATS DATS 8   0   Start of Preparation Phase  
68 PREP_START_TIME /MRSS/T_PREP_START_TIME   TIMS 6   0   Start Time of Preparation  
69 PREP_END_DATE /MRSS/T_PREP_END_DATE DATS DATS 8   0   End of Preparation Phase  
70 PREP_END_TIME /MRSS/T_PREP_END_TIME   TIMS 6   0   End Time of Preparation  
71 PREP_DURATION /MRSS/T_SGE_PREP_DURATION /MRSS/_SGE_PREP_DURATION DEC 10   2   Duration of Preparation Phase  
72 PREP_DURATION_UNIT /MRSS/T_SGU_DURATION_UNIT /MRSS/_SGU_DURATION_UNIT CHAR 3   0   Time Unit  
73 WRAP_UP_START_DATE /MRSS/T_WRAP_UP_START_DATE DATS DATS 8   0   Start of Wrap-Up Phase  
74 WRAP_UP_START_TIME /MRSS/T_WRAP_UP_START_TIME   TIMS 6   0   Start Time of Wrap-up  
75 WRAP_UP_END_DATE /MRSS/T_WRAP_UP_END_DATE DATS DATS 8   0   End of Wrap-Up Phase  
76 WRAP_UP_END_TIME /MRSS/T_WRAP_UP_END_TIME   TIMS 6   0   End Time of Wrap-up  
77 WRAP_UP_DURATION /MRSS/T_SGE_WRAP_UP_DURATION /MRSS/_SGE_WRAP_UP_DURATION DEC 10   2   Duration of Wrap-Up Phase  
78 WRAP_UP_DURATION_UNIT /MRSS/T_SGU_DURATION_UNIT /MRSS/_SGU_DURATION_UNIT CHAR 3   0   Time Unit  
79 TEXT TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
80 DEMAND /MRSS/T_SGE_INH_ASS_FROM_DEM   STRU 0   0    
81 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
82 SUPERVISOR /MRSS/T_DEM_SUPERVISOR /MRSS/_DEM_SUPERVISOR CHAR 1   0   Site supervisor indicator of demand  
83 DEMAND_DESCRIPTION /MRSS/T_DEM_I_DESCRIPTION TEXT40 CHAR 40   0   Description of Demand Item  
84 CREATED_BY ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
85 CREATED_DATE /MRSS/T_SGU_CREATED_AT_DATE   DATS 8   0   Created On  
86 CREATED_UZEIT /MRSS/T_SGU_CREATED_AT_TIME   TIMS 6   0   Creation Time  
87 CHANGED_BY AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
88 CHANGED_DATE AEDAT DATUM DATS 8   0   Last Changed On  
89 CHANGED_UZEIT /MRSS/T_SGU_AETIME UHRZT TIMS 6   0   Time at which record was changed  
History
Last changed by/on SAP  20141109 
SAP Release Created in 401