SAP ABAP Table /MRSS/T_ASS_KEY_EXT_DET (Assignment Details in WFM Format)
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_DET   Table Relationship Diagram
Short Description Assignment Details in WFM Format    
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 SYSUUID RAW 16   0   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 REMAINING_DURATION INT4 INT4 INT4 10   0   Natural number  
9 PARENT_KEY /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
10 ROOT_KEY /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
11 BOOKING_TYPE CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
12 CONCRETE CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
13 WTIME_BASED CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
14 RULE_BASED CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
15 APPL_STATUS J_STATUS J_STATUS CHAR 5   0   Object status  
16 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
17 PLANNING_TYPE /MRSS/T_PLANNING_TYPE_CODE /MRSS/PLANNING_TYPE_CODE CHAR 1   0   Planning Type Code for Assignment Time Unit  
18 PLANNING_UNIT /MRSS/T_PLANNING_TIME_UNIT MEINS UNIT 3   0   Internal Time Unit *
19 PLAN_NODE_RES /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
20 CREATED_BY SYUNAME SYCHAR12 CHAR 12   0   User Name  
21 CREATED_AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure *
22 CREATED_LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system *
23 CREATED TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
24 CHANGED_BY SYUNAME SYCHAR12 CHAR 12   0   User Name  
25 CHANGED TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
26 CHANGED_AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure *
27 CHANGED_LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system *
28 DESCRIPTION /MRSS/T_ASSIGNMENT_DESC   STRG 0   0   Assignment Description  
29 RES_UTIL_RATIO /MRSS/T_WFM_UTILISATION   FLTP 16   16   Capacity Level  
30 RES_UTIL_RATIO_ORIGIN CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
31 RES_TYPE CHAR2 CHAR2 CHAR 2   0   Version Number Component  
32 .INCLUDE       0   0   Additional Info for Assignment  
33 ASS_PROB /MRSS/T_ASS_PROB NUMC3 NUMC 3   0   Assignment Probability  
34 NO_TRAVEL_COST /MRSS/T_NO_TRAVEL_COST BOOLEAN CHAR 1   0   No Travel Cost Indicator  
35 MOBILE_INDICATOR /MRSS/T_SEND_TO_MOBILE BOOLEAN CHAR 1   0   Send To Mobile Solution  
36 ASS_SUPERVISOR /MRSS/T_ASG_SUPERVISOR /MRSS/_BOOLEAN CHAR 1   0   Site Supervisor of Assignment  
37 RES_UTIL_RAT /MRSS/T_WFM_UTILISATION   FLTP 16   16   Capacity Level  
38 RES_UTIL_RAT_ORG /MRSS/T_UTIL_RAT_ORG CHAR1 CHAR 1   0   Origin of Resource utilization ratio  
39 PART_CONC_ATTR /MRSS/T_ASG_INFX_TAB   TTYP 0   0    
40 TRAVEL_TIME_MODE /MRSS/T_TRV_MODE /MRSS/_TRV_MODE CHAR 1   0   Travel Time Mode  
41 TRV_DISPLAY_TO /MRSS/T_TRV_DISPLAY_TO /MRSS/_BOOLEAN CHAR 1   0   Display Travel Times (Arrival)  
42 TRV_DISPLAY_FROM /MRSS/T_TRV_DISPLAY_FROM /MRSS/_BOOLEAN CHAR 1   0   Display Travel Times (Departure)  
43 IS_RES_FIXED /MRSS/T_SGE_FIX_RESOURCE /MRSS/_BOOLEAN CHAR 1   0   Fix Resource  
44 IS_DATE_FIXED /MRSS/T_SGE_FIX_DATES /MRSS/_BOOLEAN CHAR 1   0   Fix the dates  
45 UTILIZ /MRSS/T_UTILISATION /MRSS/_UITLISATION DEC 3   0   Resource Utilization  
46 PARENT_GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
47 TIME_RULE_ID /MRSS/T_TIME_RULE_ID TEXT25 CHAR 25   0   Time Rule Id  
48 IS_CHILD /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
49 SETTLEMENT_TYPE /MRSS/T_SETTLEMENT_TYPE /MRSS/_SETTLEMENT_TYPE CHAR 1   0   Assignment Settlement Type  
50 SPLIT_NUMBER INT1 INT1 INT1 3   0   Dummy for B20 int1 (Local Everywhere)  
51 MULT_SLOTS /MRSS/T_SGE_MULT_SLOTS /MRSS/_SGE_MULT_SLOTS NUMC 3   0   Multiple Slots For a Demand  
52 ASG_FOLLOWS_DEMAND /MRSS/T_SGE_ASG_FOLLOWS_DEM /MRSS/_BOOLEAN CHAR 1   0   Assignment Follows Demand  
53 .INCLUDE       0   0   Addnl Info fields for Assignment - Customer Include  
54 DUMMY CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
55 .INCLUDE       0   0    
56 .INCLUDE       0   0   Administrative Data for Assignment  
57 ASSIGNMENT_TYPE /MRSS/T_SGE_ASSIGNMENT_TYPE /MRSS/_SGE_ASSIGNMENT_TYPE CHAR 1   0   Assignment category  
58 DEMAND /MRSS/T_SGE_INH_ASS_FROM_DEM   STRU 0   0    
59 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
60 SUPERVISOR /MRSS/T_DEM_SUPERVISOR /MRSS/_DEM_SUPERVISOR CHAR 1   0   Site supervisor indicator of demand  
61 .INCLUDE       0   0   Travel Time for Internal Display  
62 TRV_TO_BEGIN TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
63 TRV_TO_END TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
64 TRV_TO_DURATION /MRSS/T_TRV_TO_DURATION INT4 INT4 10   0   Arrival Duration  
65 TRV_TO_DUR_UNIT /MRSS/T_TRV_TO_DURATION_UNIT MEINS UNIT 3   0   Arrival Duration (Unit) *
66 TRV_TO_DISTANCE /MRSS/T_TRV_TO_DISTANCE GEODIST DEC 15   6   Arrival Distance  
67 TRV_TO_DIS_UNIT /MRSS/T_TRV_TO_DISTANCE_UNIT   UNIT 3   0   Travel-to distance unit  
68 TRV_TO_MANU_SET /MRSS/T_TRV_TO_MANUALLY_SET /MRSS/_BOOLEAN CHAR 1   0   Arrival Set Manually  
69 TRV_TO_PROFILE /MRSS/T_TRV_PROFILE_KEY /MRSS/_TRAVEL_PROFILE CHAR 10   0   Travel-type profile key  
70 TRV_FRM_BEGIN TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
71 TRV_FRM_END TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
72 TRV_FRM_DURATION /MRSS/T_TRV_FROM_DURATION INT4 INT4 10   0   Departure Duration  
73 TRV_FRM_DUR_UNIT /MRSS/T_TRV_FROM_DURATION_UNIT MEINS UNIT 3   0   Departure Duration (Unit) *
74 TRV_FRM_DISTANCE /MRSS/T_TRV_FROM_DISTANCE GEODIST DEC 15   6   Departure Distance  
75 TRV_FRM_DIS_UNIT /MRSS/T_TRV_FROM_DISTANCE_UNIT   UNIT 3   0   Travel-from distance unit  
76 TRV_FRM_MANU_SET /MRSS/T_TRV_FROM_MANUALLY_SET /MRSS/_BOOLEAN CHAR 1   0   Departure Set Manually  
77 TRV_FRM_PROFILE /MRSS/T_TRV_PROFILE_KEY /MRSS/_TRAVEL_PROFILE CHAR 10   0   Travel-type profile key  
78 .INCLUDE       0   0   Process Times (Preparation and Wrap up) for Internal Display  
79 PREP_START /MRSS/T_SGE_TIMESTAMP BCOS_TSTMP DEC 15   0   Timestamp (with conv. routine)  
80 PREP_END /MRSS/T_SGE_TIMESTAMP BCOS_TSTMP DEC 15   0   Timestamp (with conv. routine)  
81 PREP_DURATION /MRSS/T_PREPARATION_DURATION INT4 INT4 10   0   Preparation Duration  
82 WRAP_UP_START /MRSS/T_SGE_TIMESTAMP BCOS_TSTMP DEC 15   0   Timestamp (with conv. routine)  
83 WRAP_UP_END /MRSS/T_SGE_TIMESTAMP BCOS_TSTMP DEC 15   0   Timestamp (with conv. routine)  
84 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