SAP ABAP Class /MRSS/CL_BASIS_RES_DB (DB Access to Resource related data)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC (Application Component) Maintenance Processing
     ⤷ /MRSS/BASIS_RES (Package) Resource related Data and Functions

Properties

Class	/MRSS/CL_BASIS_RES_DB
Short Description	DB Access to Resource related data
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	/MRSS/BASIS_RES	Resource related Data and Functions
Created	20080108	SAP
Last change	20141109
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class /MRSS/CL_BASIS_RES_DB has no forward declaration.

Interfaces

Class /MRSS/CL_BASIS_RES_DB has no interface implemented.

Friends

Class /MRSS/CL_BASIS_RES_DB has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GT_RESOURCES	Static Attribute	Private	☐	See coding				20080108
2	GT_RES_QUALIFICATIONS	Static Attribute	Private	☐	See coding			Resource Qualifications data	20080108
3	GT_RES_ZIPAREAS	Static Attribute	Private	☐	Type reference (TYPE)	/MRSS/T_BASIS_RES_ZIPA_TAB		Postleitzahlengebiete	20080221
4	GT_TA_INTERVALS	Static Attribute	Private	☐	See coding				20080109
5	GT_TIME_ALLOCATIONS	Static Attribute	Private	☐	See coding				20080109

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	GET_CAPACITY_INFO	Static method	Public	Method	Get capacity Information (Overbooking, Limits, Period etc)	20101229
2	GET_CHANGED_TIMESPECS	Static method	Public	Method	Get Changed time specs	20100302
3	GET_OVERBOOK_INFO	Static method	Public	Method	Get overbook Information	20101229
4	REFRESH	Static method	Public	Method	Refresh the Buffers	20080109
5	RESOURCE_BY_ZIPCODE_SELECT	Static method	Public	Method	Select resources be ZIP Code	20080221
6	RESOURCE_QUALIF_SELECT	Static method	Public	Method	Select Resource qualifications data	20080108
7	RESOURCE_SELECT	Static method	Public	Method	Select Resources	20080108
8	RESOURCE_ZIPAREA_GET	Static method	Public	Method	Select Resource ziparea data	20080221
9	SAVE	Static method	Public	Method	Save the entries into DB	20080108
10	TIME_ALLOCATIONS_SELECT	Static method	Public	Method	Select the Time allocations	20080108
11	TIME_INTERVALS_SELECT	Static method	Public	Method	Select time intervals of Time allocations	20080108
12	ZIPAREA_BY_ZIP_SELECT	Static method	Public	Method	Read ZIP Areas for ZIP Code from Customizing	20080222

Events

Class /MRSS/CL_BASIS_RES_DB has no event.

Types

Class /MRSS/CL_BASIS_RES_DB has no local type.

Method Signatures

Method GET_CAPACITY_INFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CAPACITY_INFO	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SGE_RES_CAP_INFO_TAB		Table type: Order Limit	20101229
2	Exporting	ET_FROZEN_PERIOD	Call by reference	☐	Type reference (TYPE)	/MRSS/T_RES_FRZN_PRD_TAB		Table type: Frozen Period	20101229
3	Exporting	ET_MESSAGES	Call by reference	☐	Type reference (TYPE)	/MRSS/T_MESSAGE_TAB		Message Table	20101229
4	Exporting	EV_FAILED	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BOOLEAN		Boolean Variable	20101229
5	Importing	IT_RESOURCE_GUIDS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		List of GUIDs	20101229
6	Importing	IV_BEG_TSTMP	Call by reference	☐	Type reference (TYPE)	/MRSS/T_TIMESTAMP		Time Stamp (Date and Time)	20101229
7	Importing	IV_END_TSTMP	Call by reference	☐	Type reference (TYPE)	/MRSS/T_TIMESTAMP		Time Stamp (Date and Time)	20101229

Method GET_CAPACITY_INFO on class /MRSS/CL_BASIS_RES_DB has no exception.

Method GET_CHANGED_TIMESPECS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CHANGED_TIMESPECS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_RES_TIMESPEC_TAB		Resource Time Specifications	20100302
2	Exporting	ET_DELETED_TIMESPECS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_RES_TIMESPEC_TAB		Resource Time Specifications	20100302
3	Exporting	ET_RESOURCE_GUIDS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		List of GUIDs	20100302
4	Importing	IS_INTERVAL	Call by reference	☐	Type reference (TYPE)	/MRSS/T_TIMESTAMP_INTERVAL		Time Interval	20100302
5	Importing	IT_RESOURCE_GUIDS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		List of GUIDs	20100302

Method GET_CHANGED_TIMESPECS on class /MRSS/CL_BASIS_RES_DB has no exception.

Method GET_OVERBOOK_INFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_OVERBOOK_INFO	Call by reference	☐	Type reference (TYPE)	/MRSS/T_RES_OVERBOOK_INFO_TAB		Table type: Order Limit	20101229
2	Importing	IT_RESOURCE_GUIDS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		List of GUIDs	20101229
3	Importing	IV_BEG_TSTMP	Call by reference	☐	Type reference (TYPE)	/MRSS/T_TIMESTAMP		Time Stamp (Date and Time)	20101229
4	Importing	IV_END_TSTMP	Call by reference	☐	Type reference (TYPE)	/MRSS/T_TIMESTAMP		Time Stamp (Date and Time)	20101229

Method GET_OVERBOOK_INFO on class /MRSS/CL_BASIS_RES_DB has no exception.

Method REFRESH Signature

Method REFRESH on class /MRSS/CL_BASIS_RES_DB has no parameter.
Method REFRESH on class /MRSS/CL_BASIS_RES_DB has no exception.

Method RESOURCE_BY_ZIPCODE_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_ZIPAREA_RESOURCES	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BASIS_ZIPA_RES_TAB		Postleitzahlen + PLZ-Gebiete und Resourcen	20080221
2	Importing	IV_COUNTRY	Call by reference	☐	Type reference (TYPE)	LAND1		Länderschlüssel	20080221
3	Importing	IV_ZIPCODE	Call by reference	☐	Type reference (TYPE)	AD_PSTCD1		Postleitzahl des Orts	20080221

Method RESOURCE_BY_ZIPCODE_SELECT on class /MRSS/CL_BASIS_RES_DB has no exception.

Method RESOURCE_QUALIF_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_RES_QUALIFICATIONS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BASIS_RES_QUALIF_TAB		Resource Qualifications tab	20080108
2	Importing	IS_ADMIN_DATA	Call by reference	☑	Type reference (TYPE)	/MRSS/T_WFM_ADMIN_RECORD		Administrative Data for Communication with WFM Core System	20080108
3	Importing	IT_RES_KEYS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		List of GUIDs	20080108

Method RESOURCE_QUALIF_SELECT on class /MRSS/CL_BASIS_RES_DB has no exception.

Method RESOURCE_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_RESOURCES	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BASIS_RES_DATA_TAB		Resource Data	20080108
2	Exporting	ET_RES_ADD_INFO	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SGE_RESOURCE_INFO_TAB		Resource information table	20090810
3	Importing	IS_ADMIN_DATA	Call by reference	☑	Type reference (TYPE)	/MRSS/T_WFM_ADMIN_RECORD		Administrative Data for Communication with WFM Core System	20080108
4	Importing	IT_GUID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		List of GUIDs	20080108

Method RESOURCE_SELECT on class /MRSS/CL_BASIS_RES_DB has no exception.

Method RESOURCE_ZIPAREA_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ZIPAREAS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BASIS_RES_ZIPA_TAB		Postleitzahlengebiete	20080221
2	Importing	IS_ADMIN_DATA	Call by reference	☐	Type reference (TYPE)	/MRSS/T_WFM_ADMIN_RECORD		Administrative Daten für Kommunikation mit LRP System	20080221
3	Importing	IT_RES_KEYS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		Liste mit Guids	20080221

Method RESOURCE_ZIPAREA_GET on class /MRSS/CL_BASIS_RES_DB has no exception.

Method SAVE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_RES_DEL	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TAB		Resource details table	20080108
2	Importing	IT_RES_INS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TAB		Resource details table	20080108
3	Importing	IT_RES_QUAL_DEL	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_QUAL_TAB		Resource Qualifications data	20080108
4	Importing	IT_RES_QUAL_INS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_QUAL_TAB		Resource Qualifications data	20080108
5	Importing	IT_RES_UPD	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TAB		Resource details table	20080108
6	Importing	IT_RES_ZIPA_DEL	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		Liste mit Guids	20080222
7	Importing	IT_RES_ZIPA_INS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BASIS_RES_ZIPA_TAB		Postleitzahlengebiete	20080222
8	Importing	IT_TA_DEL	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TA_TAB		Time allocations data	20080108
9	Importing	IT_TA_INS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TA_TAB		Time allocations data	20080108
10	Importing	IT_TA_INT_DEL	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TA_INT_TAB		Intervals of time allocations	20080108
11	Importing	IT_TA_INT_INS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TA_INT_TAB		Intervals of time allocations	20080108
12	Importing	IT_TA_UPD	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TA_TAB		Time allocations data	20080108

Method SAVE on class /MRSS/CL_BASIS_RES_DB has no exception.

Method TIME_ALLOCATIONS_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_TA_DETAILS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BASIS_TA_TAB		Table of Time allocations	20080108
2	Importing	IT_RES_INTERVALS	Call by reference	☑	Type reference (TYPE)	/MRSS/T_GUID_TSP_INT_TAB		List of GUIDs	20080110
3	Importing	IT_TA_GUID	Call by reference	☑	Type reference (TYPE)	/MRSS/T_GUID_TAB		List of GUIDs	20080108
4	Importing	IV_EXCEPTIONS_ONLY	Call by reference	☑	Type reference (TYPE)	/MRSS/T_BOOLEAN		Boolesche Variable	20120131

Method TIME_ALLOCATIONS_SELECT on class /MRSS/CL_BASIS_RES_DB has no exception.

Method TIME_INTERVALS_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_TA_INTERVALS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_BAS_RES_TA_INT_TAB		Time allocation intervals	20080108
2	Importing	IT_TA_GUID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_GUID_TAB		List of GUIDs	20080108

Method TIME_INTERVALS_SELECT on class /MRSS/CL_BASIS_RES_DB has no exception.

Method ZIPAREA_BY_ZIP_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ZIPAREAS_FOR_ZIPCODE	Call by reference	☐	Type reference (TYPE)	/MRSS/T_ZIPA_DT_TAB		Postleitzahlengebiete (Customizing)	20080222
2	Importing	IV_COUNTRY	Call by reference	☐	Type reference (TYPE)	LAND1		Länderschlüssel	20080222
3	Importing	IV_ZIPCODE	Call by reference	☐	Type reference (TYPE)	AD_PSTCD1		Postleitzahl des Orts	20080222

Method ZIPAREA_BY_ZIP_SELECT on class /MRSS/CL_BASIS_RES_DB has no exception.

History

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