SAP ABAP Table /MRSS/T_SGU_RESOURCE (Assignment: Resource - Bar Chart Element)
Hierarchy
☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ /MRSS/SGU (Package) User Interface for Interactive Planning Board
Basic Data
Table Category INTTAB    Structure 
Structure /MRSS/T_SGU_RESOURCE   Table Relationship Diagram
Short Description Assignment: Resource - Bar Chart Element    
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 BOX_ID BCBOXID BCINT4 INT4 10   0   Identification for box in bar chart  
2 GUID /MRSS/T_GUID_RES SYSUUID RAW 16   0   Resource GUID  
3 ROLE /MRSS/T_SGU_RESOURCE_ROLE /MRSS/_SGU_RESOURCE_ROLE CHAR 1   0   Resource Role  
4 CHART_ID BCOBJID BCINT4 INT4 10   0   Object identification in bar chart  
5 ROW_NO INT4 INT4 INT4 10   0   Natural number  
6 HAS_CHILDREN /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
7 PARENT /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
8 HEADER /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
9 RESOURCEDATA /MRSS/T_RESOURCE_DATA   STRU 0   0    
10 .INCLUDE       0   0   Resource Data for the Interface  
11 ID /MRSS/T_GUID_RES SYSUUID RAW 16   0   Resource GUID  
12 TEXT TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
13 TYPE /MRSS/T_RESOURCE_TYPE /MRSS/_RESOURCE_TYPE CHAR 2   0   Type of Resource  
14 REL /MRSS/T_RESOURCE_REL /MRSS/_RESOURCE_REL CHAR 1   0   Relevance of a Resource for the Planning Board  
15 EDIT_MODE /MRSS/T_EDIT_MODE /MRSS/_EDIT_MODE CHAR 1   0   Processing Mode  
16 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
17 BEGDA DATS DATS DATS 8   0   Field of type DATS  
18 BEG_UZEIT UZEIT UZEIT TIMS 6   0   Time  
19 ENDDA DATS DATS DATS 8   0   Field of type DATS  
20 END_UZEIT UZEIT UZEIT TIMS 6   0   Time  
21 TIMESPEC /MRSS/T_TIMESPEC_TAB   TTYP 0   0    
22 ASSIGNMENT /MRSS/T_ASSIGNMENT_EXT_TAB   TTYP 0   0    
23 BASIC_AVAIL /MRSS/T_DATE_INTERVAL_TAB   TTYP 0   0    
24 BASIC_NON_AVAIL /MRSS/T_DATE_INTERVAL_TAB   TTYP 0   0    
25 NOT_VALID /MRSS/T_DATE_INTERVAL_TAB   TTYP 0   0    
26 COLLISION /MRSS/T_SGE_COLLISION_OBJ_TAB   TTYP 0   0    
27 ORG_UNIT OBJEC   STRU 0   0    
28 PLVAR PLVAR PLVAR CHAR 2   0   Plan Version  
29 OTYPE OTYPE OTYPE CHAR 2   0   Object Type  
30 OBJID PD_OBJID_R NUM08 NUMC 8   0   Object ID  
31 BEGDA BEGDATUM DATUM DATS 8   0   Start Date  
32 ENDDA ENDDATUM DATUM DATS 8   0   End Date  
33 ISTAT ISTAT_D ISTAT CHAR 1   0   Planning Status  
34 HISTO HISTO CHAR1 CHAR 1   0   Historical Record Flag  
35 SHORT SHORT_D TEXT12 CHAR 12   0   Object Abbreviation  
36 STEXT STEXT TEXT40 CHAR 40   0   Object Name  
37 REALO REALO CHAR45 CHAR 45   0   Extended Object ID  
38 .INCLUDE       0   0   Summarized Availability  
39 AVAIL_RELATIVE /MRSS/T_AVAIL_REL   DEC 11   3   Relative Utilization  
40 AVAIL_ABSOLUTE /MRSS/T_AVAIL_ABS   DEC 11   2   Absolute Availability  
41 UTIL_RELATIVE /MRSS/T_UTIL_REL   DEC 11   2   Relative Utilization  
42 BASIC_AVAIL_COMPLEX /MRSS/T_SGE_AVAIL_RES_EXT_TAB   TTYP 0   0    
43 BASIC_NONE_AVAIL_COMPLEX /MRSS/T_SGE_AVAIL_RES_EXT_TAB   TTYP 0   0    
44 STATUS /MRSS/T_RES_STAT_S   STRU 0   0    
45 STATUS /MRSS/T_RESOURCE_STATUS /MRSS/_RESOURCE_STATUS CHAR 5   0   Status Of The Resource  
46 STEXT /MRSS/T_RES_STAT_STEXT /MRSS/_RES_STAT_STEXT CHAR 10   0   Resource Status Short Text  
47 LTEXT /MRSS/T_RES_STAT_LTEXT /MRSS/_RES_STAT_LTEXT CHAR 30   0   Resource Status Long Text  
48 CHANGED_AT /MRSS/T_TIMESTAMP TZNTSTMPS DEC 15   0   Time Stamp (Date and Time)  
49 STATUS_CHG /MRSS/T_TIMESTAMP TZNTSTMPS DEC 15   0   Time Stamp (Date and Time)  
50 UNIQUE_SEQUENCE INT4 INT4 INT4 10   0   Natural number  
51 SOURCE_TYPE /MRSS/T_SGE_RES_SOURCE_TYPE /MRSS/_SGE_RES_SOURCE_TYPE CHAR 1   0   Internal / External Resource  
52 CAPACITY_INFO /MRSS/T_RES_CAP_INFO_TAB   TTYP 0   0    
53 AGR_CAPA_INFO /MRSS/T_SGU_RES_CAPA_INFO   STRU 0   0    
54 CAPACITY_LIMIT /MRSS/T_CAP_LIMIT INT4 INT4 10   0   Capacity Limit  
55 OVERBOOK_LIMIT /MRSS/T_CAP_OVR_BKNG_LMT INT4 INT4 10   0   Overbooking Limit  
56 CONSUMED_CAP /MRSS/T_RES_CONSUMED_CAPACITY INT4 INT4 10   0   Consumed capacity of Resource  
57 .INCLUDE       0   0   Extending Resource List in Gantt  
58 XDUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
59 .INCLUDE       0   0    
60 NON_AVAIL_DAYS /MRSS/T_SGE_AVAIL_RES_EXT_TAB   TTYP 0   0    
61 DEMANDDATA /MRSS/T_SGU_DEMAND   STRU 0   0    
62 .INCLUDE       0   0   Demand for Display on User Interface  
63 .INCLUDE       0   0   Worklist Data  
64 ADM /MRSS/T_WORKLIST_ADM   STRU 0   0    
65 GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
66 HEADER_LEVEL INT1 INT1 INT1 3   0   Dummy for B20 int1 (Local Everywhere)  
67 PARENT /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
68 HEADER /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
69 DISPO_FLG /MRSS/T_DISPO_FLG /MRSS/_BOOLEAN CHAR 1   0   Relevancy for Resource Planning  
70 CAPA_FLG /MRSS/T_SGE_CAPA_FLG /MRSS/_BOOLEAN CHAR 1   0   Relevance for Capacity Planning  
71 ERR_FLG /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
72 STAT_COMPL /MRSS/T_STAT_COMPL /MRSS/_BOOLEAN CHAR 1   0   Processing status  
73 DEMAND_TYPE /MRSS/T_DEMAND_TYPE /MRSS/_DEMAND_TYPE CHAR 2   0   Demand Type  
74 EDIT_MODE /MRSS/T_EDIT_MODE /MRSS/_EDIT_MODE CHAR 1   0   Processing Mode  
75 HEADER_TYPE /MRSS/T_DEM_TYPE /MRSS/_DEM_TYPE CHAR 4   0   Demand Type  
76 RELEVANCE /MRSS/T_WL_ITEM_REL /MRSS/_WL_ITEM_REL CHAR 1   0   Relevance of an Item for the Planning Board  
77 DEMAND_DEBUG CHAR25 CHAR25 CHAR 25   0   User field for cluster PC (national)  
78 ATTRIBUTES /MRSS/T_FIELDNAME_VALUE_TAB   TTYP 0   0    
79 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
80 ASSIGNMENTS /MRSS/T_ASSIGNMENT_EXT_TAB   TTYP 0   0    
81 DEMAND /MRSS/T_DEMAND_DATA_EXT   STRU 0   0    
82 GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
83 HEADER /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
84 BEGDA DATS DATS DATS 8   0   Field of type DATS  
85 BEG_UZEIT UZEIT UZEIT TIMS 6   0   Time  
86 ENDDA DATS DATS DATS 8   0   Field of type DATS  
87 END_UZEIT UZEIT UZEIT TIMS 6   0   Time  
88 SCHED_START_DATE DATS DATS DATS 8   0   Field of type DATS  
89 SCHED_START_TIME UZEIT UZEIT TIMS 6   0   Time  
90 SCHED_END_DATE DATS DATS DATS 8   0   Field of type DATS  
91 SCHED_END_TIME UZEIT UZEIT TIMS 6   0   Time  
92 SCHED_TYPE /MRSS/T_SCHEDULING_TYPE   CHAR 1   0   Scheduling Type for Demand  
93 .INCLUDE       0   0   Object  
94 PLVAR PLVAR PLVAR CHAR 2   0   Plan Version  
95 OTYPE OTYPE OTYPE CHAR 2   0   Object Type  
96 OBJID OBJEKTID NUM08 NUMC 8   0   Object ID  
97 ORIG_ITEM_TYPE /MRSS/T_DEM_TYPE_I   CHAR 4   0   Demand Item Category  
98 STAT_COMPL /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
99 WORKCENTER_ID /MRSS/T_DEM_WORKCENTER_ID NUM08 NUMC 8   0   Work center ID of operation or item  
100 WORKCENTER_TYPE /MRSS/T_DEM_WORKCENTER_TYPE /MRSS/_SGE_CR_OBJTY CHAR 2   0   Work center type of operation or item  
101 WORKCENTER_PLANT /MRSS/T_DEM_WORKCENTER_PLANT WERKS CHAR 4   0   Plant of Work Center  
102 WORKCENTER_GUID /MRSS/T_NODE_GUID SYSUUID RAW 16   0   GUID of Planning Node  
103 SUPERVISOR /MRSS/T_DEM_SUPERVISOR /MRSS/_DEM_SUPERVISOR CHAR 1   0   Site supervisor indicator of demand  
104 SUPERVISOR_NO /MRSS/T_DEM_SUPERVISOR_NO   NUMC 3   0   Number of Site Supervisors for Demand  
105 DURATION /MRSS/T_SGE_DURATION MENG13 QUAN 13   3   Duration  
106 DURATION_UNIT /MRSS/T_SGE_DURATION_UNIT MEINS UNIT 3   0   Unit for the Transaction Duration  
107 TOTAL_WORK /MRSS/T_SGE_TOTAL_WORK MENG13 QUAN 13   3   Total Work  
108 TOTAL_WORK_UNIT /MRSS/T_SGE_TOTAL_WORK_UNIT MEINS UNIT 3   0   Unit of Total Work of Operation  
109 MULT_RES /MRSS/T_SGE_MULT_RES /MRSS/_SGE_MULT_RES NUMC 3   0   Number of Persons  
110 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
111 TIME_CALC_CAPA /MRSS/T_SGE_TIME_CALC_CAPA XFELD CHAR 1   0   Calculation of Demand Duration Active  
112 IS_RES_FIXED /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
113 IS_DATE_FIXED /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
114 RESTR_START_TYPE /MRSS/T_DEM_RESTRICT_START /MRSS/_DEM_RESTRICT_START CHAR 1   0   Demand Start Restriction  
115 RESTR_END_TYPE /MRSS/T_DEM_RESTRICT_END /MRSS/_DEM_RESTRICT_END CHAR 1   0   Demand End Restriction  
116 RESTRICT_START_DAT DATS DATS DATS 8   0   Field of type DATS  
117 RESTRICT_START_TIME UZEIT UZEIT TIMS 6   0   Time  
118 RESTRICT_END_DAT DATS DATS DATS 8   0   Field of type DATS  
119 RESTRICT_END_TIME UZEIT UZEIT TIMS 6   0   Time  
120 DESCRIPTION /MRSS/T_DEM_I_DESCRIPTION TEXT40 CHAR 40   0   Description of Demand Item  
121 DEMAND_PRIORITY /MRSS/T_SGE_PRIORITY /MRSS/_SGE_DEMAND_PRIORITY CHAR 1   0   Priority of an Operation  
122 DEM_NOTES /MRSS/T_SGD_DEMAND_NOTES_TAB   TTYP 0   0    
123 DEM1_MULT_SLOTS /MRSS/T_SGE_MULT_SLOTS /MRSS/_SGE_MULT_SLOTS NUMC 3   0   Multiple Slots For a Demand  
124 REASON /MRSS/T_TIME_SPEC_REASON CHAR4 CHAR 4   0   Time Specification Reason  
125 REASON_DESC /MRSS/T_TIME_SPEC_REASON_DESC TEXT80 CHAR 80   0   Reason description  
126 .INCLUDE       0   0   Addnl Info fields for Demand - Customer Include  
127 DUMMY CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
128 .INCLUDE       0   0    
129 DURATIONS /MRSS/T_DEMAND_DURATIONS_EXT   STRU 0   0    
130 DURATION_ACCR INT4 INT4 INT4 10   0   Natural number  
131 POC /MRSS/T_DEM_POC   DEC 4   1   Ratio of Duration of Recorded Times to Planned Duration  
132 DURATION_PLAN INT4 INT4 INT4 10   0   Natural number  
133 DURATION_ORIG_PLAN INT4 INT4 INT4 10   0   Natural number  
134 HEADER_ATT /MRSS/T_DEM_H   STRU 0   0    
135 HEADER /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
136 PARENT /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
137 DEM_TYPE /MRSS/T_DEM_TYPE /MRSS/_DEM_TYPE CHAR 4   0   Demand Type  
138 ID /MRSS/T_DEM_H_ID CHAR25 CHAR 25   0   Demand ID  
139 DESCRIPTION /MRSS/T_DEM_H_DESC TEXT40 CHAR 40   0   Description of Complex Demand  
140 BASIC_START TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
141 BASIC_END TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
142 SCHED_START TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
143 SCHED_END TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
144 ACTUAL_START TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
145 ACTUAL_END TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
146 .INCLUDE       0   0   Object  
147 PLVAR PLVAR PLVAR CHAR 2   0   Plan Version  
148 OTYPE OTYPE OTYPE CHAR 2   0   Object Type  
149 OBJID OBJEKTID NUM08 NUMC 8   0   Object ID  
150 STAT_ERR /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
151 STAT_COMPL /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
152 PROBABILITY /MRSS/T_DEM_PROBABILITY /MRSS/_DEM_PROBABILITY CHAR 3   0   Demand Probability  
153 ORIG_ORDER_TYPE /MRSS/T_DEM_ORDER_TYPE AUFART CHAR 4   0   Type of underlying order or operation  
154 PLANT /MRSS/T_PM_PLANT WERKS CHAR 4   0   Maintenance planning plant  
155 ACTIVITY_TYPE /MRSS/T_PM_ACTIVITY_TYPE /MRSS/_DEM_PM_ACTIVITY_TYPE CHAR 3   0   Maintenance activity type (header)  
156 CREATED_BY /MRSS/T_DEM_CREATED_BY USNAM CHAR 12   0   Created By  
157 CREATED_AT TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
158 CHANGED_BY /MRSS/T_DEM_CHANGED_BY USNAM CHAR 12   0   Last Changed By  
159 CHANGED_AT TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
160 WORKCENTER_ID /MRSS/T_DEM_WORKCENTER_ID NUM08 NUMC 8   0   Work center ID of operation or item  
161 WORKCENTER_TYPE /MRSS/T_DEM_WORKCENTER_TYPE /MRSS/_SGE_CR_OBJTY CHAR 2   0   Work center type of operation or item  
162 WORKCENTER_PLANT /MRSS/T_DEM_WORKCENTER_PLANT WERKS CHAR 4   0   Plant of Work Center  
163 SCHEDULING_TYPE /MRSS/T_SCHEDULING_TYPE   CHAR 1   0   Scheduling Type for Demand  
164 PLANNING_STATUS /MRSS/T_DEM_PLANNING_STATUS /MRSS/_WL_PLAN_STATUS CHAR 2   0   Planning Status of the Demand  
165 HEADERS /MRSS/T_DEM_H_WRK_TAB   TTYP 0   0    
166 TECH_OBJECT /MRSS/T_TECH_OBJECT   STRU 0   0    
167 GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
168 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system  
169 TYPE /MRSS/T_TECH_OBJECT_TYPE /MRSS/_TECH_OBJECT_TYPE CHAR 1   0   Technical Object Type  
170 .INCLUDE       0   0   Technical Objects Include  
171 TYPE_EXT /MRSS/T_TOBJ_TYPE_EXT /MRSS/_T_TOBJ_TYPE_EXT CHAR 4   0   Technical ObjectType External  
172 INTERNAL_KEY /MRSS/T_TOBJ_KEY_INT   CHAR 60   0   Technical Object Internal Key  
173 EXTERNAL_KEY /MRSS/T_TOBJ_KEY_EXT   CHAR 60   0   Technical Object External Key  
174 DESCRIPTION /MRSS/T_TOBJ_DESC   CHAR 80   0   Technical Object Description  
175 OBJECT_ID /MRSS/T_DEM_H_ID CHAR25 CHAR 25   0   Demand ID  
176 NUMBER_INT /MRSS/T_DEM_I_ID CHAR25 CHAR 25   0   Demand Item ID  
177 HIER_LEVEL     NUMC 2   0    
178 TEXT TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
179 IS_GROUP_HEADER /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
180 GROUP_ATTRIBUTE /MRSS/T_SGE_GROUPING_ATTRIBUTE /MRSS/_GROUPING_ATTRIBUTE CHAR 30   0   Defines on what Attribute is the demand gantt grouped  
181 GROUP_ATTRIBUTE_VALUE TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
History
Last changed by/on SAP  20141109 
SAP Release Created in 401