SAP ABAP Class CL_MSS_ACTION_SQLPROCESSES (SQL processes)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_MSS_ACTION_CONTROLLER	MSS: Abstract Action Controller	20060914

Properties

Class	CL_MSS_ACTION_SQLPROCESSES
Short Description	SQL processes
Super Class	CL_MSS_ACTION_CONTROLLER	MSS: Abstract Action Controller
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STUN_MSS	Package for new SQL Server monitoring objects
Created	20060914	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	MSSCC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_MSS_ACTION_SQLPROCESSES has no interface implemented.

Friends

Class CL_MSS_ACTION_SQLPROCESSES has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ALV	Instance attribute	Public	☑	Object reference (TYPE REF TO)	CL_DB6_ALV		DB6: simple ALV abstraction	20060914
2	CTRL	Instance attribute	Private	☐	Attribute reference (LIKE)				20060914
3	CURRENT_VIEW	Instance attribute	Private	☐	Type reference (TYPE)	I			20070116
4	INFO_OBJECT_8	Constant	Private	☐	Type reference (TYPE)	DOKHL-OBJECT	'BC-DB-MSS-SQLPROCESSES'	Documentation Object	20060914
5	INFO_OBJECT_9	Constant	Private	☐	Type reference (TYPE)	DOKHL-OBJECT	'BC-DB-MSS-SQLPROCESSES_DMV'	Documentation Object	20060914
6	MAJOR	Instance attribute	Private	☐	Type reference (TYPE)	I		Numeric sql release	20060914
7	NAV_REF	Instance attribute	Private	☐	Attribute reference (LIKE)				20060914
8	PROC_SNAPSHOT	Instance attribute	Private	☐	See coding			Important fields from sessions/connections/requests	20070117
9	PROC_SNAPSHOT2K	Instance attribute	Private	☐	See coding				20070126
10	SP_PARAMS	Instance attribute	Private	☐	See coding				20061116
11	VIEW_DATA	Instance attribute	Public	☑	Type reference (TYPE)	MSSCC_ACTION_SQLPROCESSES		Data fields on main dynpro	20060914

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CLASS_CONSTRUCTOR	Static method	Public	Constructor	CLASS_CONSTRUCTOR	20060914
2	DO_RESET	Instance method	Private	Method	Do reset	20070118
3	DO_SINCE_RESET	Instance method	Private	Method	Do since reset	20070118
4	FIND_APPSERVERS	Instance method	Private	Method	Find application servers	20070110
5	FIND_DBLOGINS	Instance method	Private	Method	Find Database logins	20061116
6	FIND_WPNAMES	Instance method	Private	Method	Find Work processes names	20070110
7	GET_SESCONREQ	Instance method	Private	Method		20100526
8	GET_SQL_CODE	Instance method	Private	Method	Get SQL Code for SQL 2005	20060914
9	GET_SQL_CODE2000	Instance method	Private	Method	Get SQL Code for SQL 2005	20061117
10	HANDLE_CLOSE_POPUP	Instance method	Private	Event handling method	Make the container invisible when user clicks on close	20060914
11	SET_GRID_ATTRIBUTES	Instance method	Private	Method	Set grid attributes	20060914
12	SET_LAYOUT_ATTRIBUTES	Instance method	Private	Method	Set grid attributes	20070123
13	SET_SORT_ATTRIBUTES	Instance method	Private	Method	Set grid attributes	20061109
14	SHOW_ABAP_CODE	Instance method	Private	Method	Display the abap code for the current statement	20060914
15	SHOW_SQL_CODE	Instance method	Private	Method	Display sql statement in query analyzer for current statemen	20060914
16	UPDATE_SAPUSER	Instance method	Private	Method	Update SAP user	20061114
17	UPDATE_SQLTEXT_FOR_MRSH	Instance method	Private	Method	Update sqltext for most recently used sqlhandle	20061113

Events

Class CL_MSS_ACTION_SQLPROCESSES has no event.

Types

Class CL_MSS_ACTION_SQLPROCESSES has no local type.

Method Signatures

Method CLASS_CONSTRUCTOR Signature

Method CLASS_CONSTRUCTOR on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method CLASS_CONSTRUCTOR on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method DO_RESET Signature

Method DO_RESET on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method DO_RESET on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method DO_SINCE_RESET Signature

Method DO_SINCE_RESET on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method DO_SINCE_RESET on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method FIND_APPSERVERS Signature

Method FIND_APPSERVERS on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method FIND_APPSERVERS on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method FIND_DBLOGINS Signature

Method FIND_DBLOGINS on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method FIND_DBLOGINS on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method FIND_WPNAMES Signature

Method FIND_WPNAMES on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method FIND_WPNAMES on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method GET_SESCONREQ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ACT_REQS_ONLY	Call by reference	☐	Type reference (TYPE)	CHAR1	'N'	Single-Character Flag	20100526
2	Importing	DO_RESET	Call by reference	☐	Type reference (TYPE)	CHAR1	'N'	Single-Character Flag	20100526
3	Importing	ENG_CONS_INCLUDED	Call by reference	☐	Type reference (TYPE)	CHAR1	'N'	Single-Character Flag	20100526
4	Importing	ONE_HOST	Call by reference	☐	Type reference (TYPE)	MSS_ACTIVE_REQUEST-HOSTNAME	'N'	Hostname of the application server logged into SQL Server.	20100526
5	Importing	ONE_LOGIN	Call by reference	☐	Type reference (TYPE)	MSSSCHEMA	'N'	Schema name	20100526
6	Importing	ONE_WP	Call by reference	☐	Type reference (TYPE)	MSS_ACTIVE_REQUEST-PROGNAME	'N'	Name of the application program which owns the connection.	20100526

Method GET_SESCONREQ on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method GET_SQL_CODE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	PARAMS	Call by reference	☐	Type reference (TYPE)	MSS_T_MSQSPPARAM		MS SQL server stored procedure parameter structure	20060914
2	Importing	REQ	Call by reference	☐	Type reference (TYPE)	MSS_ACTIVE_REQUEST		Statistical information related to CPU time/memory for query	20060914
3	Changing	SQLTEXT	Call by reference	☐	Type reference (TYPE)	STRING			20060914

Method GET_SQL_CODE on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method GET_SQL_CODE2000 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	PARAMS	Call by reference	☐	Type reference (TYPE)	MSS_T_MSQSPPARAM		MS SQL server stored procedure parameter structure	20061117
2	Importing	REQ	Call by reference	☐	Type reference (TYPE)	MSSPRCINF7		Statistical information related to CPU time/memory for query	20061117
3	Changing	SQLTEXT	Call by reference	☐	Type reference (TYPE)	STRING			20061117

Method GET_SQL_CODE2000 on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method HANDLE_CLOSE_POPUP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SENDER	Value transfer	☐	Attribute reference (LIKE)				20060914

Method HANDLE_CLOSE_POPUP on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method SET_GRID_ATTRIBUTES Signature

Method SET_GRID_ATTRIBUTES on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method SET_GRID_ATTRIBUTES on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method SET_LAYOUT_ATTRIBUTES Signature

Method SET_LAYOUT_ATTRIBUTES on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method SET_LAYOUT_ATTRIBUTES on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method SET_SORT_ATTRIBUTES Signature

Method SET_SORT_ATTRIBUTES on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method SET_SORT_ATTRIBUTES on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method SHOW_ABAP_CODE Signature

Method SHOW_ABAP_CODE on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method SHOW_ABAP_CODE on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method SHOW_SQL_CODE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TAB	Call by reference	☐	Type reference (TYPE)	I		Which tab to show on the tabcontrol	20060914

Method SHOW_SQL_CODE on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method UPDATE_SAPUSER Signature

Method UPDATE_SAPUSER on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method UPDATE_SAPUSER on class CL_MSS_ACTION_SQLPROCESSES has no exception.

Method UPDATE_SQLTEXT_FOR_MRSH Signature

Method UPDATE_SQLTEXT_FOR_MRSH on class CL_MSS_ACTION_SQLPROCESSES has no parameter.
Method UPDATE_SQLTEXT_FOR_MRSH on class CL_MSS_ACTION_SQLPROCESSES has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	710