SAP ABAP Class CL_MSS_ACTION_SQLREQUESTS (SQL Requests from dm views or syscacheobjects)

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	20060828

Properties

Class	CL_MSS_ACTION_SQLREQUESTS
Short Description	SQL Requests from dm views or syscacheobjects
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	20060828	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

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

Interfaces

Class CL_MSS_ACTION_SQLREQUESTS has no interface implemented.

Friends

Class CL_MSS_ACTION_SQLREQUESTS 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	20060828
2	CTRL	Instance attribute	Private	☐	Attribute reference (LIKE)				20060828
3	CURRENT_VIEW	Instance attribute	Private	☐	Type reference (TYPE)	I		Current "view" 1-restricted 2-ALL	20061206
4	DEFAULTSORT	Constant	Private	☐	Type reference (TYPE)	STRING	'TTL_ELAPSED_TIME'		20061214
5	DO_SET_GRID_ATTRIBUTES	Instance attribute	Private	☐	Type reference (TYPE)	C	SPACE		20110622
6	INFO_OBJECT_9	Constant	Private	☐	Type reference (TYPE)	DOKHL-OBJECT	'BC-DB-MSS-SQLREQUESTS_DMV'	Documentation Object	20060831
7	IS_ON	Instance attribute	Private	☐	Type reference (TYPE)	I	0	1 if sql2000 cacheprofile is on.	20060905
8	IT_FROM_RESET	Instance attribute	Private	☐	See coding				20081029
9	IT_QUERYSTATS2005	Instance attribute	Private	☐	See coding				20080313
10	KEYVALTABLE	Instance attribute	Private	☐	See coding				20061213
11	MAJOR	Instance attribute	Private	☐	Type reference (TYPE)	I			20110818
12	NAV_REF	Instance attribute	Private	☐	Attribute reference (LIKE)				20060828
13	NO_FETCH	Instance attribute	Private	☐	Type reference (TYPE)	C	SPACE		20080312
14	NUMBER_OF_VIEWS	Constant	Private	☐	Type reference (TYPE)	I	3		20061206
15	PLAN_ATTRIBUTES	Instance attribute	Private	☐	See coding				20060906
16	POPUP_ALV	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_MSS_POPUP_ALV		Popup window for plan attributes	20060906
17	POPUP_SUMMARY_ALV	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_MSS_POPUP_ALV			20061213
18	RESET_REQUESTED	Instance attribute	Private	☐	Type reference (TYPE)	C	SPACE		20081031
19	SINCE_RESET	Instance attribute	Private	☐	Type reference (TYPE)	C	SPACE		20081029
20	SORT_TITLE	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20060830
21	SP_PARAMS	Instance attribute	Private	☐	See coding				20061116
22	SV_NUMROWS	Instance attribute	Private	☐	Type reference (TYPE)	I		save number of rows to check if it changed	20060830
23	VIEW_DATA	Instance attribute	Public	☑	Type reference (TYPE)	MSSCC_ACTION_SQLREQUESTS		Data fields on main dynpro	20060828

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CALCULATE_DIFF	Instance method	Private	Method	Recreate the alv data based on last reset snapshot	20081029
2	DISPLAY_TABLE_DETAILS	Instance method	Private	Method	If there is a table name known, then drill into tabledetail	20060901
3	DO_RESET	Instance method	Private	Method	Save the current data to compare with later selection	20081029
4	DROP_PLAN	Instance method	Private	Method	Drop current plan from the cache	20120618
5	FIELDNAME_IN_VIEW	Instance method	Private	Method	Return true if input fieldname is a "basic" field	20061206
6	FREE_PROCCACHE	Instance method	Private	Method	Reset SQL Server cache	20060901
7	GET_SQL_CODE	Instance method	Private	Method	Get SQL Code for SQL 2005	20060831
8	HANDLE_CLOSE_POPUP	Instance method	Private	Event handling method	Make the container invisible when user clicks on close	20060906
9	HANDLE_DOUBLE_CLICK	Instance method	Private	Event handling method	Go to sql statement on double click	20061213
10	INIT_DROPDOWN_TABLE	Instance method	Private	Method	Initialize dropdown for sort options	20060828
11	SET_DEFAULTSORT	Instance method	Private	Method	Initialize dropdown for sort options	20061212
12	SET_GRID_AND_GROUP_BY	Instance method	Private	Method	Set grid and sort for grouping commands	20080312
13	SET_GRID_ATTRIBUTES	Instance method	Private	Method	Set grid attributes	20060828
14	SHOW_ABAP_CODE	Instance method	Private	Method	Display the abap code for the current statement	20060831
15	SHOW_PLAN_ATTRIBUTES	Instance method	Private	Method	Display plan attributes in a popup window	20060901
16	SHOW_SQL_CODE	Instance method	Private	Method	Display sql statement in query analyzer for current statemen	20060831
17	SHOW_STATS_SUMMARY	Instance method	Private	Method	Display plan attributes in a popup window	20061213

Events

Class CL_MSS_ACTION_SQLREQUESTS has no event.

Types

Class CL_MSS_ACTION_SQLREQUESTS has no local type.

Method Signatures

Method CALCULATE_DIFF Signature

Method CALCULATE_DIFF on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method CALCULATE_DIFF on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method DISPLAY_TABLE_DETAILS Signature

Method DISPLAY_TABLE_DETAILS on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method DISPLAY_TABLE_DETAILS on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method DO_RESET Signature

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

Method DROP_PLAN Signature

Method DROP_PLAN on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method DROP_PLAN on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method FIELDNAME_IN_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FIELDNAME	Call by reference	☐	Type reference (TYPE)	C			20061206
2	Returning	FIELDNAME_IN_VIEW	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20061206
3	Importing	VIEW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20061206

Method FIELDNAME_IN_VIEW on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method FREE_PROCCACHE Signature

Method FREE_PROCCACHE on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method FREE_PROCCACHE on class CL_MSS_ACTION_SQLREQUESTS 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	20060831
2	Importing	REQ	Call by reference	☐	Type reference (TYPE)	MSSQUERYSTATSOUT		Statistical information related to CPU time/memory for query	20060831
3	Changing	SQLTEXT	Call by reference	☐	Type reference (TYPE)	STRING			20060831

Method GET_SQL_CODE on class CL_MSS_ACTION_SQLREQUESTS 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)				20060906

Method HANDLE_CLOSE_POPUP on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method HANDLE_DOUBLE_CLICK Signature

Method HANDLE_DOUBLE_CLICK on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method HANDLE_DOUBLE_CLICK on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method INIT_DROPDOWN_TABLE Signature

Method INIT_DROPDOWN_TABLE on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method INIT_DROPDOWN_TABLE on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method SET_DEFAULTSORT Signature

Method SET_DEFAULTSORT on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method SET_DEFAULTSORT on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method SET_GRID_AND_GROUP_BY Signature

Method SET_GRID_AND_GROUP_BY on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method SET_GRID_AND_GROUP_BY on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method SET_GRID_ATTRIBUTES Signature

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

Method SHOW_ABAP_CODE Signature

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

Method SHOW_PLAN_ATTRIBUTES Signature

Method SHOW_PLAN_ATTRIBUTES on class CL_MSS_ACTION_SQLREQUESTS has no parameter.
Method SHOW_PLAN_ATTRIBUTES on class CL_MSS_ACTION_SQLREQUESTS 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	20060831

Method SHOW_SQL_CODE on class CL_MSS_ACTION_SQLREQUESTS has no exception.

Method SHOW_STATS_SUMMARY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DO_DISPLAY	Value transfer	☐	Type reference (TYPE)	C			20080213

Method SHOW_STATS_SUMMARY on class CL_MSS_ACTION_SQLREQUESTS has no exception.

History

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