SAP ABAP Class /MRSS/CL_SQM_MAT_DB (Qualification matrix - database accesses)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ /MRSS/SQM (Package) MRS Qualifications: Master Data (Matrix, Catalogs)

Properties

Class	/MRSS/CL_SQM_MAT_DB
Short Description	Qualification matrix - database accesses
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	/MRSS/SQM	MRS Qualifications: Master Data (Matrix, Catalogs)
Created	20060328	SAP
Last change	20141109
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class /MRSS/CL_SQM_MAT_DB has no forward declaration.

Interfaces

Class /MRSS/CL_SQM_MAT_DB has no interface implemented.

Friends

Class /MRSS/CL_SQM_MAT_DB has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GT_MEG_DB	Instance attribute	Private	☐	Type reference (TYPE)	/MRSS/T_SQM_MEG_DB_TAB			20070114
2	GT_MEG_DB_BI	Instance attribute	Private	☐	Type reference (TYPE)	/MRSS/T_SQM_MEG_DB_TAB			20070114
3	GT_MH	Instance attribute	Public	☐	Type reference (TYPE)	/MRSS/T_SQM_MAT_TAB		Qualifications Matrixes	20060328
4	GT_MHT_ALL	Instance attribute	Public	☑	Type reference (TYPE)	/MRSS/T_SQM_MHT_DB_STD_TAB		Qualification matrix texts (DB)	20061120
5	GT_MHT_DB	Instance attribute	Private	☐	Type reference (TYPE)	/MRSS/T_SQM_MHT_DB_TAB		Qualifications Matrix Texts (DB)	20060328
6	GT_MHT_DB_BI	Instance attribute	Private	☐	Type reference (TYPE)	/MRSS/T_SQM_MHT_DB_TAB		Qualifications Matrix Texts (DB)	20060328
7	GT_MH_BI	Instance attribute	Public	☑	Type reference (TYPE)	/MRSS/T_SQM_MAT_TAB		Qualifications Matrixes	20060328
8	GT_MH_DB	Instance attribute	Private	☐	Type reference (TYPE)	/MRSS/T_SQM_MH_DB_TAB		Qualifications Matrixes (DB)	20060328
9	GT_MH_DB_BI	Instance attribute	Private	☐	Type reference (TYPE)	/MRSS/T_SQM_MH_DB_TAB		Qualifications Matrixes (DB)	20060328
10	GT_MPL_DB	Instance attribute	Private	☐	Type reference (TYPE)	/MRSS/T_SQM_MPL_DB_TAB			20070114
11	GT_MPL_DB_BI	Instance attribute	Private	☐	Type reference (TYPE)	/MRSS/T_SQM_MPL_DB_TAB			20070114
12	GV_LANGU	Instance attribute	Private	☐	Type reference (TYPE)	SPRAS		Language Key	20060328

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_MATID_EXISTS	Static method	Public	Method	Check Whether Matrix ID Exists	20070321
2	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20060328
3	DB_DATA_GET	Instance method	Private	Method	Read data from DB	20060409
4	DELETE	Instance method	Public	Method	Delete Matrixes	20060328
5	EGROUP_TEXT_GET	Static method	Public	Method		20070117
6	GET_EGROUPS_ALL	Static method	Public	Method		20070127
7	GET_EGROUPS_FOR_MATID	Static method	Public	Method		20070108
8	GET_MATID_FOR_PERNR	Static method	Public	Method		20070108
9	GET_MATID_FOR_PLANT	Static method	Public	Method		20070108
10	GET_PLANTS_ALL	Static method	Public	Method		20070127
11	GET_PLANTS_FOR_MATID	Static method	Public	Method		20070108
12	MAT_TEXT_GET	Static method	Public	Method	Determine text of a matrix	20060508
13	PLANT_TEXT_GET	Static method	Public	Method		20070117
14	SAVE	Instance method	Public	Method	Save matrixes	20060328
15	SELECTIVE_READ	Instance method	Public	Method		20070219
16	WHERE_USED_CATID_GET	Static method	Public	Method	Determine usages of a catalog	20060411

Events

Class /MRSS/CL_SQM_MAT_DB has no event.

Types

Class /MRSS/CL_SQM_MAT_DB has no local type.

Method Signatures

Method CHECK_MATID_EXISTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_EXISTS	Call by reference	☐	Type reference (TYPE)	XFELD		Whether the matrix ID already exists	20070321
2	Importing	IV_MATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MATID		Matrix Number	20070321

Method CHECK_MATID_EXISTS on class /MRSS/CL_SQM_MAT_DB has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ALL_LANGU	Call by reference	☑	Type reference (TYPE)	XFELD		Alle Sprachen lesen	20061120
2	Importing	IV_LANGU	Call by reference	☐	Type reference (TYPE)	SPRAS		Sprachenschlüssel	20060328

Method CONSTRUCTOR on class /MRSS/CL_SQM_MAT_DB has no exception.

Method DB_DATA_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MATID_DELETED	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MATRIXID_TAB		List of matrices that were deleted in another session	20070327
2	Importing	IT_MATID	Call by reference	☑	Type reference (TYPE)	/MRSS/T_SQM_MATRIXID_TAB		List of matrices to be selectively re-read	20070219
3	Importing	IV_ALL_LANGU	Call by reference	☑	Type reference (TYPE)	XFELD		Checkbox	20061120

Method DB_DATA_GET on class /MRSS/CL_SQM_MAT_DB has no exception.

Method DELETE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_MATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MATID		Matrixnummer	20060328

Method DELETE on class /MRSS/CL_SQM_MAT_DB has no exception.

Method EGROUP_TEXT_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_EGROUPS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_EGROUPS_OUT_TAB			20070117

Method EGROUP_TEXT_GET on class /MRSS/CL_SQM_MAT_DB has no exception.

Method GET_EGROUPS_ALL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_EGROUPS_ALL	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_EGROUPS_TAB			20070127

Method GET_EGROUPS_ALL on class /MRSS/CL_SQM_MAT_DB has no exception.

Method GET_EGROUPS_FOR_MATID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_PERSAREAS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_EGROUPS_TAB			20070108
2	Importing	IV_MATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MATID			20070108

Method GET_EGROUPS_FOR_MATID on class /MRSS/CL_SQM_MAT_DB has no exception.

Method GET_MATID_FOR_PERNR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MAT_ID_TAB			20070108
2	Importing	IV_PERNR	Call by reference	☑	Type reference (TYPE)	PERNR_D			20070108
3	Importing	IV_PERS_AREA	Call by reference	☑	Type reference (TYPE)	PERSA		Personnel Area	20090713
4	Importing	IV_SUB_AREA	Call by reference	☑	Type reference (TYPE)	BTRTL		Personnel Subarea	20090713

Method GET_MATID_FOR_PERNR on class /MRSS/CL_SQM_MAT_DB has no exception.

Method GET_MATID_FOR_PLANT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MAT_ID_TAB			20070108
2	Importing	IV_PLANT	Call by reference	☐	Type reference (TYPE)	WERKS_D			20070108

Method GET_MATID_FOR_PLANT on class /MRSS/CL_SQM_MAT_DB has no exception.

Method GET_PLANTS_ALL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_PLANTS_ALL	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_PLANT_TAB			20070127

Method GET_PLANTS_ALL on class /MRSS/CL_SQM_MAT_DB has no exception.

Method GET_PLANTS_FOR_MATID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_PLANTS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_PLANT_TAB			20070108
2	Importing	IV_MATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MATID			20070108

Method GET_PLANTS_FOR_MATID on class /MRSS/CL_SQM_MAT_DB has no exception.

Method MAT_TEXT_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EV_KTEXT	Value transfer	☐	Type reference (TYPE)	/MRSS/T_SQM_MAT-KTEXT		Beschreibung	20060508
2	Importing	IV_LANGU	Call by reference	☐	Type reference (TYPE)	SPRAS	SY-LANGU	Sprachenschlüssel	20060508
3	Importing	IV_MATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MATID		Matrixnummer	20060508

Method MAT_TEXT_GET on class /MRSS/CL_SQM_MAT_DB has no exception.

Method PLANT_TEXT_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_PLANTS	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_PLANTS_OUT_TAB			20070117

Method PLANT_TEXT_GET on class /MRSS/CL_SQM_MAT_DB has no exception.

Method SAVE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_VBMODE	Call by reference	☐	Type reference (TYPE)	VBMODE	'S'	Verbuchungsart	20060511

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

Method SELECTIVE_READ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MATID_DELETED	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MATRIXID_TAB		List of matrices that were deleted in another session	20070327
2	Importing	IT_MATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_MATRIXID_TAB		Matrices to be re-read from the DB	20070219
3	Importing	IV_ALL_LANGU	Call by reference	☑	Type reference (TYPE)	XFELD		Get descriptions in all languages	20070219

Method SELECTIVE_READ on class /MRSS/CL_SQM_MAT_DB has no exception.

Method WHERE_USED_CATID_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_OBJ	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_WHERE_USED_TAB		Vewendungen	20060411
2	Importing	IV_CATID	Call by reference	☐	Type reference (TYPE)	/MRSS/T_SQM_CATID		Qualifikationskatalognummer	20060411

Method WHERE_USED_CATID_GET on class /MRSS/CL_SQM_MAT_DB has no exception.

History

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