SAP ABAP Table /MRSS/T_SGX_SORT_RESOURCES (Structure to srot resources)

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_SORT_RESOURCES	Table Relationship Diagram
Short Description	Structure to srot resources

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	Resource with Data for the User Interface
2	.INCLUDE	☐				0	0	Resource Data for the Interface
3	ID	☐	/MRSS/T_GUID_RES	SYSUUID	RAW	16	0	Resource GUID
4	TEXT	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
5	TYPE	☐	/MRSS/T_RESOURCE_TYPE	/MRSS/_RESOURCE_TYPE	CHAR	2	0	Type of Resource
6	REL	☐	/MRSS/T_RESOURCE_REL	/MRSS/_RESOURCE_REL	CHAR	1	0	Relevance of a Resource for the Planning Board
7	EDIT_MODE	☐	/MRSS/T_EDIT_MODE	/MRSS/_EDIT_MODE	CHAR	1	0	Processing Mode
8	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
9	BEGDA	☐	DATS	DATS	DATS	8	0	Field of type DATS
10	BEG_UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
11	ENDDA	☐	DATS	DATS	DATS	8	0	Field of type DATS
12	END_UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
13	TIMESPEC	☐	/MRSS/T_TIMESPEC_TAB		TTYP	0	0
14	ASSIGNMENT	☐	/MRSS/T_ASSIGNMENT_EXT_TAB		TTYP	0	0
15	BASIC_AVAIL	☐	/MRSS/T_DATE_INTERVAL_TAB		TTYP	0	0
16	BASIC_NON_AVAIL	☐	/MRSS/T_DATE_INTERVAL_TAB		TTYP	0	0
17	NOT_VALID	☐	/MRSS/T_DATE_INTERVAL_TAB		TTYP	0	0
18	COLLISION	☐	/MRSS/T_SGE_COLLISION_OBJ_TAB		TTYP	0	0
19	ORG_UNIT	☐	OBJEC		STRU	0	0
20	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
21	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
22	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
23	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
24	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
25	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	*
26	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
27	SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
28	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
29	REALO	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
30	.INCLUDE	☐				0	0	Summarized Availability
31	AVAIL_RELATIVE	☐	/MRSS/T_AVAIL_REL		DEC	11	3	Relative Utilization
32	AVAIL_ABSOLUTE	☐	/MRSS/T_AVAIL_ABS		DEC	11	2	Absolute Availability
33	UTIL_RELATIVE	☐	/MRSS/T_UTIL_REL		DEC	11	2	Relative Utilization
34	BASIC_AVAIL_COMPLEX	☐	/MRSS/T_SGE_AVAIL_RES_EXT_TAB		TTYP	0	0
35	BASIC_NONE_AVAIL_COMPLEX	☐	/MRSS/T_SGE_AVAIL_RES_EXT_TAB		TTYP	0	0
36	STATUS	☐	/MRSS/T_RES_STAT_S		STRU	0	0
37	STATUS	☐	/MRSS/T_RESOURCE_STATUS	/MRSS/_RESOURCE_STATUS	CHAR	5	0	Status Of The Resource	*
38	STEXT	☐	/MRSS/T_RES_STAT_STEXT	/MRSS/_RES_STAT_STEXT	CHAR	10	0	Resource Status Short Text
39	LTEXT	☐	/MRSS/T_RES_STAT_LTEXT	/MRSS/_RES_STAT_LTEXT	CHAR	30	0	Resource Status Long Text
40	CHANGED_AT	☐	/MRSS/T_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp (Date and Time)
41	STATUS_CHG	☐	/MRSS/T_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp (Date and Time)
42	UNIQUE_SEQUENCE	☐	INT4	INT4	INT4	10	0	Natural number
43	SOURCE_TYPE	☐	/MRSS/T_SGE_RES_SOURCE_TYPE	/MRSS/_SGE_RES_SOURCE_TYPE	CHAR	1	0	Internal / External Resource
44	CAPACITY_INFO	☐	/MRSS/T_RES_CAP_INFO_TAB		TTYP	0	0
45	AGR_CAPA_INFO	☐	/MRSS/T_SGU_RES_CAPA_INFO		STRU	0	0
46	CAPACITY_LIMIT	☐	/MRSS/T_CAP_LIMIT	INT4	INT4	10	0	Capacity Limit
47	OVERBOOK_LIMIT	☐	/MRSS/T_CAP_OVR_BKNG_LMT	INT4	INT4	10	0	Overbooking Limit
48	CONSUMED_CAP	☐	/MRSS/T_RES_CONSUMED_CAPACITY	INT4	INT4	10	0	Consumed capacity of Resource
49	.INCLUDE	☐				0	0	Extending Resource List in Gantt
50	XDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
51	.INCLUDE	☐				0	0
52	NON_AVAIL_DAYS	☐	/MRSS/T_SGE_AVAIL_RES_EXT_TAB		TTYP	0	0
53	DATE_OF_CREATION	☐	DATS	DATS	DATS	8	0	Field of type DATS
54	EQUIPMENT_NO	☐	CC_EQUNR	CC_EQUNR	CHAR	18	0	Equipment number

History

Last changed by/on	SAP	20141109
SAP Release Created in	900