SAP ABAP Table /MRSS/T_SGX_WD_ASSIGN_DETAIL (Assignment Details)
Hierarchy
☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ CA-MRS (Application Component) SAP Multiresource Scheduling
     ⤷ /MRSS/SGX (Package) MRS Planning Board Extended Web Interface
Basic Data
Table Category INTTAB    Structure 
Structure /MRSS/T_SGX_WD_ASSIGN_DETAIL   Table Relationship Diagram
Short Description Assignment Details    
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   Communication Table for Data Display  
2 DEMAND_GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
3 DEMAND_ID /MRSS/T_DEM_I_ID CHAR25 CHAR 25   0   Demand Item ID  
4 ASSIGNMENT_GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
5 RESOURCE_GUID /MRSS/T_GUID_RES SYSUUID RAW 16   0   Resource GUID  
6 ASSIGNMENT_NAME TEXT40 TEXT40 CHAR 40   0   Text, 40 Characters Long  
7 RESOURCE_NAME /MRSS/T_SGU_RESOURCENAME TEXT40 CHAR 40   0   Resource Name  
8 BEGDA /MRSS/T_SGU_BEGDA DATUM DATS 8   0   Start date  
9 BEG_UZEIT /MRSS/T_SGU_BEG_UZEIT UZEIT TIMS 6   0   Start Time  
10 ENDDA /MRSS/T_SGU_ENDDA DATUM DATS 8   0   End date  
11 END_UZEIT /MRSS/T_SGU_END_UZEIT UZEIT TIMS 6   0   End Time  
12 DURATION /MRSS/T_SGE_DURAT   DEC 13   3   Duration for staffing table  
13 DURATION_UNIT /MRSS/T_SGU_DURATION_UNIT /MRSS/_SGU_DURATION_UNIT CHAR 3   0   Time Unit  
14 STATUS /MRSS/T_SGU_DATA_LIST_STATUS /MRSS/_SGU_DATA_LIST_STATUS CHAR 80   0   Entry Status  
15 ASSGN_STATUS /MRSS/T_SGU_ASSIGNMENT_STAT CHAR132 CHAR 132   0   Assignment status  
16 ASSIGNMENT_TYPE /MRSS/T_SGE_ASSIGNMENT_TYPE /MRSS/_SGE_ASSIGNMENT_TYPE CHAR 1   0   Assignment category  
17 UTILIZ /MRSS/T_UTILISATION /MRSS/_UITLISATION DEC 3   0   Resource Utilization  
18 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
19 TEAM_MEMBERS /MRSS/T_SGU_COMM_TEAM_TAB   TTYP 0   0    
20 NEW_STAT /MRSS/T_STATUSES   STRU 0   0    
21 CLIENT MANDT MANDT CLNT 3   0   Client *
22 TABNO /MRSS/T_TABNO /MRSS/_TABNO NUMC 2   0   Tab Page Number  
23 BUTTON /MRSS/T_BUTTON /MRSS/T_BUTTON CHAR 20   0   Status  
24 STATUS_ORIGIN /MRSS/T_SGE_STATUS_ORIGIN /MRSS/_SGE_STATUS_ORIGIN CHAR 1   0   Status: origin  
25 STATUS_TYPE /MRSS/T_STATUS_TYPE /MRSS/_STATUS_TYPE CHAR 10   0   Type of Abstract MRS Status *
26 ICON /MRSS/T_ICON_D ICON CHAR 4   0   Display on Pushbuttons *
27 ON_CONTEXT_MENU /MRSS/T_ON_CONTEXT /MRSS/_BOOLEAN CHAR 1   0   Display status in context menu  
28 MENU_ID /MRSS/T_MENU_ID /MRSS/_MENU_ID CHAR 8   0   Menu ID for context menu  
29 SAVE_PLB /MRSS/T_SAVE_PLB /MRSS/_BOOLEAN CHAR 1   0   Save the planning board after the status is set  
30 RELEVANCE /MRSS/T_STAT_RELEVANCE /MRSS/_DEM_TYPE CHAR 4   0   Assignment Status Relevance - Based on Demand Type  
31 ON_APP_TOOLBAR /MRSS/ON_APP /MRSS/_BOOLEAN CHAR 1   0   Display status button on application toolbar  
32 CHANGE_ICON ICON_D ICON CHAR 4   0   Icon in text fields (substitute display, alias) *
33 DELETE_ICON ICON_D ICON CHAR 4   0   Icon in text fields (substitute display, alias) *
34 ASSIGNMENT_TYP_DESC     STRG 0   0    
35 DEM1_MULT_SLOTS /MRSS/T_SGE_MULT_SLOTS /MRSS/_SGE_MULT_SLOTS NUMC 3   0   Multiple Slots For a Demand  
36 RESOURCES /MRSS/T_GUID_TAB   TTYP 0   0    
37 NOTE /MRSS/T_ASSIGNMENT_NOTE /MRSS/_SGE_SSTRING SSTR 255   0   Assignment Note  
38 IS_RES_FIXED /MRSS/T_SGX_FIX_RESOURCE /MRSS/_BOOLEAN CHAR 1   0   Fixed Resource  
39 IS_DATE_FIXED /MRSS/T_SGX_FIX_DATES /MRSS/_BOOLEAN CHAR 1   0   Fixed Dates  
40 ASG_FOLLOWS_DEMAND /MRSS/T_SGX_ASG_FOLLOWS_DEM /MRSS/_BOOLEAN CHAR 1   0   Assignment Follows Demand  
41 .INCLUDE       0   0   Travel time  
42 TRV_TO_BEGIN_DATE /MRSS/T_TRV_TO_BEGIN_DATE DATS DATS 8   0   Start of Arrival (Date)  
43 TRV_TO_BEGIN_TIME /MRSS/T_TRV_TO_BEGIN_TIME   TIMS 6   0   Start of Arrival (Time)  
44 TRV_TO_END_DATE /MRSS/T_TRV_TO_END_DATE DATS DATS 8   0   End of Arrival (Date)  
45 TRV_TO_END_TIME /MRSS/T_TRV_TO_END_TIME   TIMS 6   0   End of Arrival (Time)  
46 TRV_TO_DURATION /MRSS/T_SGX_TRV_TO_DURATION   DEC 10   2   Travel Time Duration  
47 TRV_TO_DURATION_UNIT /MRSS/T_SGX_TRV_TO_DURA_UNIT /MRSS/_SGX_DURATION_UNIT CHAR 3   0   Time Unit  
48 TRV_TO_DISTANCE /MRSS/T_SGX_TRV_TO_DISTANCE   DEC 10   2   Travel Distance  
49 TRV_TO_DIS_UNIT /MRSS/T_SGX_TRV_TO_DIST_UNIT /MRSS/_SGX_TRV_DISTANCE_UNIT CHAR 3   0   Travel Distance Unit  
50 TRV_TO_AUTOMATIC /MRSS/T_SGX_TRV_TO_AUTOMATIC /MRSS/_BOOLEAN CHAR 1   0   Calculate Arrival Time Automatically  
51 TRV_TO_PROFILE /MRSS/T_TRV_PROFILE_KEY /MRSS/_TRAVEL_PROFILE CHAR 10   0   Travel-type profile key  
52 TRAVEL_TIME_MODE /MRSS/T_TRV_MODE /MRSS/_TRV_MODE CHAR 1   0   Travel Time Mode  
53 TRV_FROM_BEGIN_DATE /MRSS/T_TRV_FROM_BEGIN_DATE DATS DATS 8   0   Start of Departure (Date)  
54 TRV_FROM_BEGIN_TIME /MRSS/T_TRV_FROM_BEGIN_TIME   TIMS 6   0   Start of Departure (Time)  
55 TRV_FROM_END_DATE /MRSS/T_TRV_FROM_END_DATE DATS DATS 8   0   End of Departure (Date)  
56 TRV_FROM_END_TIME /MRSS/T_TRV_FROM_END_TIME   TIMS 6   0   End of Departure (Time)  
57 TRV_FROM_DURATION /MRSS/T_SGX_TRV_FROM_DURATION   DEC 10   2   Travel Duration  
58 TRV_FROM_DURATION_UNIT /MRSS/T_SGX_TRV_FROM_DURA_UNIT /MRSS/_SGX_DURATION_UNIT CHAR 3   0   Travel Duration Unit  
59 TRV_FROM_DISTANCE /MRSS/T_SGX_TRV_FROM_DISTANCE   DEC 10   2   Travel Distance  
60 TRV_FROM_DIS_UNIT /MRSS/T_SGX_TRV_FROM_DIST_UNIT /MRSS/_SGX_TRV_DISTANCE_UNIT CHAR 3   0   Travel Distance Unit  
61 TRV_FROM_AUTOMATIC /MRSS/T_SGX_TRV_FROM_AUTOMATIC /MRSS/_BOOLEAN CHAR 1   0   Calculate Departure Time Automatically  
62 TRV_FROM_PROFILE /MRSS/T_TRV_PROFILE_KEY /MRSS/_TRAVEL_PROFILE CHAR 10   0   Travel-type profile key  
63 .INCLUDE       0   0   Process Time (Preparation and Wrap-up) for External Display  
64 PREP_START_DATE /MRSS/T_PREP_START_DATE DATS DATS 8   0   Start of Preparation Phase  
65 PREP_START_TIME /MRSS/T_PREP_START_TIME   TIMS 6   0   Start Time of Preparation  
66 PREP_END_DATE /MRSS/T_PREP_END_DATE DATS DATS 8   0   End of Preparation Phase  
67 PREP_END_TIME /MRSS/T_PREP_END_TIME   TIMS 6   0   End Time of Preparation  
68 PREP_DURATION /MRSS/T_SGE_PREP_DURATION /MRSS/_SGE_PREP_DURATION DEC 10   2   Duration of Preparation Phase  
69 PREP_DURATION_UNIT /MRSS/T_SGU_DURATION_UNIT /MRSS/_SGU_DURATION_UNIT CHAR 3   0   Time Unit  
70 WRAP_UP_START_DATE /MRSS/T_WRAP_UP_START_DATE DATS DATS 8   0   Start of Wrap-Up Phase  
71 WRAP_UP_START_TIME /MRSS/T_WRAP_UP_START_TIME   TIMS 6   0   Start Time of Wrap-up  
72 WRAP_UP_END_DATE /MRSS/T_WRAP_UP_END_DATE DATS DATS 8   0   End of Wrap-Up Phase  
73 WRAP_UP_END_TIME /MRSS/T_WRAP_UP_END_TIME   TIMS 6   0   End Time of Wrap-up  
74 WRAP_UP_DURATION /MRSS/T_SGE_WRAP_UP_DURATION /MRSS/_SGE_WRAP_UP_DURATION DEC 10   2   Duration of Wrap-Up Phase  
75 WRAP_UP_DURATION_UNIT /MRSS/T_SGU_DURATION_UNIT /MRSS/_SGU_DURATION_UNIT CHAR 3   0   Time Unit  
76 PERNR /MRSS/T_SGW_PERSNO /MRSS/_SGW_PERSNO NUMC 8   0   Personnel Number  
77 BP /MRSS/T_SGW_PERSNO /MRSS/_SGW_PERSNO NUMC 8   0   Personnel Number  
History
Last changed by/on SAP  20141109 
SAP Release Created in 700