SAP ABAP Class CL_MSS_ACTION_STMT_HIST (SQL Statement History)

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	20100804

Properties

Class	CL_MSS_ACTION_STMT_HIST
Short Description	SQL Statement History
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	20100804	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_STMT_HIST has no interface implemented.

Friends

Class CL_MSS_ACTION_STMT_HIST has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ALV_STMTHIST	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV3			20100804
2	ALV_STMTHISTDET	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV3			20100804
3	CMD_BASIC_VIEW	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'BSCVW'	Basic view	20100816
4	CMD_DETAILED_VIEW	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'DETVW'	Detailed view	20100816
5	CMD_DETAILS_FOR_SELECTION	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'SELR'	Show details for selection	20110105
6	CTRL	Instance attribute	Private	☐	Attribute reference (LIKE)				20100804
7	IT_STMT_HISTORY	Instance attribute	Private	☐	See coding				20100804
8	IT_STMT_HISTORY_DET	Instance attribute	Private	☐	See coding				20100804
9	MAJOR	Instance attribute	Private	☐	Type reference (TYPE)	I			20110824
10	NAV_REF	Instance attribute	Private	☐	Attribute reference (LIKE)				20100804
11	SP_PARAMS	Instance attribute	Private	☐	See coding				20100806
12	SQLHIST_CONTAINER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER			20100804
13	SQLHIST_SPLITTER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_EASY_SPLITTER_CONTAINER			20100804
14	VIEW_DATA	Instance attribute	Private	☐	Type reference (TYPE)	MSSCC_ACTION_STMT_HIST		Screen data	20110310

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	DISPLAY_SELECTION	Instance method	Private	Method	Display details for all selected rows	20101025
2	DISPLAY_TABLE_DETAILS	Instance method	Private	Method	If there is a table name known, then drill into tabledetail	20100806
3	GET_SQL_CODE_FROM_CACHE	Instance method	Private	Method	Get SQL Code from the cache using the sql handle	20100812
4	HANDLE_DOUBLE_CLICK	Instance method	Private	Event handling method	Handle double click in overview	20100804
5	HANDLE_DOUBLE_CLICK_DET	Instance method	Private	Event handling method	Handle double click in detail list	20100809
6	SET_BASIC_VIEW	Instance method	Private	Method	Show just the load percentages and the SQL Statement	20100816
7	SET_DETAILED_VIEW	Instance method	Private	Method	Show almost all detail columns	20100816
8	SET_GRID_ATTRIBUTES	Instance method	Private	Method	Grid attributes of alvs for statement lists	20100804
9	SHOW_ABAP_CODE	Instance method	Private	Method	Display the abap code for the current statement	20100806
10	SHOW_CURRENT_PLAN	Instance method	Private	Method	Display plan in query analyzer from current cache	20100809
11	SHOW_SQL_CODE	Instance method	Private	Method	Display sql statement in query analyzer for saved statement	20100806

Events

Class CL_MSS_ACTION_STMT_HIST has no event.

Types

Class CL_MSS_ACTION_STMT_HIST has no local type.

Method Signatures

Method DISPLAY_SELECTION Signature

Method DISPLAY_SELECTION on class CL_MSS_ACTION_STMT_HIST has no parameter.
Method DISPLAY_SELECTION on class CL_MSS_ACTION_STMT_HIST has no exception.

Method DISPLAY_TABLE_DETAILS Signature

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

Method GET_SQL_CODE_FROM_CACHE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	REQ	Call by reference	☐	Type reference (TYPE)	MSSCC_MSS_STMTHISTDET		Statistical information related to CPU time/memory for query	20100812
2	Changing	SQLTEXT	Call by reference	☐	Type reference (TYPE)	STRING			20100812

Method GET_SQL_CODE_FROM_CACHE on class CL_MSS_ACTION_STMT_HIST has no exception.

Method HANDLE_DOUBLE_CLICK Signature

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

Method HANDLE_DOUBLE_CLICK_DET Signature

Method HANDLE_DOUBLE_CLICK_DET on class CL_MSS_ACTION_STMT_HIST has no parameter.
Method HANDLE_DOUBLE_CLICK_DET on class CL_MSS_ACTION_STMT_HIST has no exception.

Method SET_BASIC_VIEW Signature

Method SET_BASIC_VIEW on class CL_MSS_ACTION_STMT_HIST has no parameter.
Method SET_BASIC_VIEW on class CL_MSS_ACTION_STMT_HIST has no exception.

Method SET_DETAILED_VIEW Signature

Method SET_DETAILED_VIEW on class CL_MSS_ACTION_STMT_HIST has no parameter.
Method SET_DETAILED_VIEW on class CL_MSS_ACTION_STMT_HIST has no exception.

Method SET_GRID_ATTRIBUTES Signature

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

Method SHOW_ABAP_CODE Signature

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

Method SHOW_CURRENT_PLAN Signature

Method SHOW_CURRENT_PLAN on class CL_MSS_ACTION_STMT_HIST has no parameter.
Method SHOW_CURRENT_PLAN on class CL_MSS_ACTION_STMT_HIST 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	20100806

Method SHOW_SQL_CODE on class CL_MSS_ACTION_STMT_HIST has no exception.

History

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