SAP ABAP Class CL_DB4_ACTION_STMTS_HIST (DB4: Performance - SQL Statements History)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_DB4_ACTION_CONTROLLER	DB4: Abstract Action Controller	20130311
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_DBA_ACTION_CONTROLLER_ALV	DBA Cockpit: Access to ALV object	20130311

Properties

Class	CL_DB4_ACTION_STMTS_HIST
Short Description	DB4: Performance - SQL Statements History
Super Class	CL_DB4_ACTION_CONTROLLER	DB4: Abstract Action Controller
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class	D4
Program status
Category	0
Package	STU4	CCMS / AS/400
Created	20130311	SAP
Last change	20140121	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	VRM	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_DBA_ACTION_CONTROLLER_ALV	☐	☐	DBA Cockpit: Access to ALV object	20130311

Friends

Class CL_DB4_ACTION_STMTS_HIST has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_BUFFER_LENGTH	Instance attribute	Private	☐	Type reference (TYPE)	I			20131129
2	P_HVARS_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV		DB6: simple ALV abstraction	20130502
3	P_HVARS_FIELDCAT_TAB	Instance attribute	Private	☐	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for List Viewer Control	20130502
4	P_PKG_LIB	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20131129
5	P_PKG_NAME	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20131129
6	P_R_ACCESSOR	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_VIRTUAL_TABLE_ACCESSOR		DB4: Backend virtual table accessor	20130311
7	P_R_HVARS	Instance attribute	Private	☐	Object reference (TYPE REF TO)	DATA			20130503
8	P_R_PERF_HELPER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_ACTION_PERFORMANCE		DB4: Performance Actions Helper	20131104
9	P_R_SQLPLC_HDR	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_SQLPLC_HDR		DB4: General header for SQL plan cache screens	20130418
10	P_R_STMT_EDITOR	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_STMT_EDITOR		DB4: SQL Statement Editor	20130429
11	P_R_SYSINFO	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_SYSINFO		DB4: System Information	20130409
12	P_SELECTED_HOST_ID	Instance attribute	Private	☐	Type reference (TYPE)	I	-1		20130502
13	P_SELECTED_IPL_NUMBER	Instance attribute	Private	☐	Type reference (TYPE)	I	-1		20130502
14	P_SELECTED_QQUCNT	Instance attribute	Private	☐	Type reference (TYPE)	I	-1		20130502
15	P_STMTS_HIST_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV			20130311
16	P_STMTS_HIST_FIELDCAT_TAB	Instance attribute	Private	☐	Type reference (TYPE)	LVC_T_FCAT			20130311
17	P_STMT_TEXT	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20131129
18	VIEW_DATA	Instance attribute	Public	☐	Type reference (TYPE)	DB4_VIEW_STMTS_HIST		DB4: View data for SQL Statements overview	20130311

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADAPT_HVARS_GRID_ATTRIBUTES	Instance method	Private	Method	Hide/unhide available columns in ALV	20130503
2	GET_FIELDS_FOR_ALV	Instance method	Private	Method	Get the fields for the ALV	20131129
3	GET_HVARS_FOR_STMT	Instance method	Private	Method	Get host variables for a statement	20130502
4	GET_VIEW_DATA	Instance method	Private	Method	Get the data to display	20130311
5	HANDLE_ALV_EXPLAIN	Instance method	Private	Method	Handl ALV explain push button	20131104
6	HANDLE_STMTS_ALV_DOUBLE_CLICK	Instance method	Private	Method	Trigger to display host variables of a statement	20130502
7	SET_HVARS_GRID_ATTRIBUTES	Instance method	Private	Method	Set host variables ALV attributes	20130502
8	SET_STMTS_HIST_GRID_ATTRIBUTES	Instance method	Private	Method	Set stms ALV attributes	20130311

Events

Class CL_DB4_ACTION_STMTS_HIST has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TY_HVAR	Private	See coding			20130503	begin of TY_HVAR, POSITION type I , HEXVALUE type STRING , CHARVALUE type STRING , end of TY_HVAR
2	TY_HVARS_TAB	Private	See coding			20130503	TY_HVARS_TAB TYPE STANDARD TABLE OF TY_HVAR WITH KEY POSITION

Method Signatures

Method ADAPT_HVARS_GRID_ATTRIBUTES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ALV	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_ALV		DB6: simple ALV abstraction	20130503

Method ADAPT_HVARS_GRID_ATTRIBUTES on class CL_DB4_ACTION_STMTS_HIST has no exception.

Method GET_FIELDS_FOR_ALV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_FIELDS_LIST	Call by reference	☐	Type reference (TYPE)	STRING			20131129
2	Importing	I_DYNPRO_FIELD	Call by reference	☑	Type reference (TYPE)	CLIKE			20131129

Method GET_FIELDS_FOR_ALV on class CL_DB4_ACTION_STMTS_HIST has no exception.

Method GET_HVARS_FOR_STMT Signature

Method GET_HVARS_FOR_STMT on class CL_DB4_ACTION_STMTS_HIST has no parameter.
Method GET_HVARS_FOR_STMT on class CL_DB4_ACTION_STMTS_HIST has no exception.

Method GET_VIEW_DATA Signature

Method GET_VIEW_DATA on class CL_DB4_ACTION_STMTS_HIST has no parameter.
Method GET_VIEW_DATA on class CL_DB4_ACTION_STMTS_HIST has no exception.

Method HANDLE_ALV_EXPLAIN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CMD	Call by reference	☐	Type reference (TYPE)	SYUCOMM		Function Code that Triggered PAI	20131104

#	Exception	Resumable	Description	Created on
1	CX_DBA_ROOT	☐	DBA Cockpit: Root exception class	20131104

Method HANDLE_STMTS_ALV_DOUBLE_CLICK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CMD	Call by reference	☐	Type reference (TYPE)	SYUCOMM		Function Code that Triggered PAI	20130502

Method HANDLE_STMTS_ALV_DOUBLE_CLICK on class CL_DB4_ACTION_STMTS_HIST has no exception.

Method SET_HVARS_GRID_ATTRIBUTES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ALV	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_ALV		DB6: simple ALV abstraction	20130502

Method SET_HVARS_GRID_ATTRIBUTES on class CL_DB4_ACTION_STMTS_HIST has no exception.

Method SET_STMTS_HIST_GRID_ATTRIBUTES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ALV	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_ALV			20130311

Method SET_STMTS_HIST_GRID_ATTRIBUTES on class CL_DB4_ACTION_STMTS_HIST has no exception.

History

Last changed by/on	SAP	20140121
SAP Release Created in	740