SAP ABAP Class CL_DB4_ACTION_STMTS_OVERVIEW (DB4: Performance - SQL Statements)

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	20120723
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_DBA_ACTION_CONTROLLER_ALV	DBA Cockpit: Access to ALV object	20120723

Properties

Class	CL_DB4_ACTION_STMTS_OVERVIEW
Short Description	DB4: Performance - SQL Statements
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	20120723	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	20120723

Friends

Class CL_DB4_ACTION_STMTS_OVERVIEW 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	20120723
2	P_FIELDCAT_TAB	Instance attribute	Private	☐	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for List Viewer Control	20120723
3	P_LIMIT_ROWS_TAB	Instance attribute	Private	☐	Type reference (TYPE)	DBAKEYVAL_TAB		DBA Cockpit: Table of DBAKEYVAL	20130226
4	P_R_ACCESSOR	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_VIRTUAL_TABLE_ACCESSOR		DB4: Backend virtual table accessor	20121001
5	P_R_SQLPLC_HDR	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_SQLPLC_HDR		DB4: General header for SQL plan cache screens	20130226
6	P_R_SQLPLC_TAB	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_SQLPLC_TABLES		DB4: Filter tables header for SQL plan cache screens	20130226
7	P_R_SQLPLC_TIME	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_SQLPLC_TIME		DB4: Filter tables header for SQL plan cache screens	20130226
8	P_R_SRC_JUMPER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_SOURCE_CODE_JUMP_POINT		DB4: Jump point into source code	20130211
9	P_R_SYSINFO	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB4_SYSINFO		DB4: System Information	20130409
10	P_SORT_CRITERIAS	Instance attribute	Private	☐	Type reference (TYPE)	DBAKEYVAL_TAB		DBA Cockpit: Table of DBAKEYVAL	20120723
11	VIEW_DATA	Instance attribute	Public	☐	Type reference (TYPE)	DB4_VIEW_STMTS_OVERVIEW			20120723

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	FILL_LIMIT_ROWS	Instance method	Private	Method	Fill the list of number of rows	20130226
2	FILL_SORT_CRITERIAS	Instance method	Private	Method	Fill the list of sort criterias	20121001
3	GET_FIELDS_FOR_ALV	Instance method	Private	Method	Get the fields for the ALV	20131129
4	GET_STATEMENT_TEXT_LONG	Instance method	Private	Method	Get the long statement text	20130408
5	HANDLE_ALV_DOUBLE_CLICK	Instance method	Private	Method		20120723
6	HANDLE_ALV_EXPLAIN	Instance method	Private	Method		20130730
7	HANDLE_ALV_SNAPSHOT_INFO	Instance method	Private	Method		20130715
8	HANDLE_ALV_SOURCE_CODE	Instance method	Private	Method		20130211
9	SET_GRID_ATTRIBUTES	Instance method	Private	Method	Define the attributes of the ALV	20120723

Events

Class CL_DB4_ACTION_STMTS_OVERVIEW has no event.

Types

Class CL_DB4_ACTION_STMTS_OVERVIEW has no local type.

Method Signatures

Method FILL_LIMIT_ROWS Signature

Method FILL_LIMIT_ROWS on class CL_DB4_ACTION_STMTS_OVERVIEW has no parameter.
Method FILL_LIMIT_ROWS on class CL_DB4_ACTION_STMTS_OVERVIEW has no exception.

Method FILL_SORT_CRITERIAS Signature

Method FILL_SORT_CRITERIAS on class CL_DB4_ACTION_STMTS_OVERVIEW has no parameter.
Method FILL_SORT_CRITERIAS on class CL_DB4_ACTION_STMTS_OVERVIEW 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_OVERVIEW has no exception.

Method GET_STATEMENT_TEXT_LONG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_ROW	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20130408
2	Returning	R_STMT_TEXT_LONG	Value transfer	☐	Type reference (TYPE)	STRING			20130408

#	Exception	Resumable	Description	Created on
1	CX_DBA_ROOT	☐	DB4: Backend exception class	20130601

Method HANDLE_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	20120723

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

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	20130730

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

Method HANDLE_ALV_SNAPSHOT_INFO 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	20130715

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

Method HANDLE_ALV_SOURCE_CODE 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	20130211

Method HANDLE_ALV_SOURCE_CODE on class CL_DB4_ACTION_STMTS_OVERVIEW has no exception.

Method SET_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	20120723

Method SET_GRID_ATTRIBUTES on class CL_DB4_ACTION_STMTS_OVERVIEW has no exception.

History

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