SAP ABAP Interface IF_SWLT_SQLM_DATA_PROVIDER (Provider for runtime data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-TOO (Application Component) Workbench Tools: Editors, Painters, Modelers
     ⤷ SWLT (Package) SQL Performance Tuning Worklist

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	CL_SWLT_SQLM_DATA_PROVIDER	Data provider for .... guess what !	20121128

Properties

Interface	IF_SWLT_SQLM_DATA_PROVIDER
Short Description	Provider for runtime data

General Data

Package	SWLT	SQL Performance Tuning Worklist
Created	20121123	SAP
Last changed	20140121	SAP
Unicode checks active	☑

Forward declarations

Interface IF_SWLT_SQLM_DATA_PROVIDER has no forward declaration.

Interfaces

Interface IF_SWLT_SQLM_DATA_PROVIDER has no interface.

Friends

Interface IF_SWLT_SQLM_DATA_PROVIDER has no friend.

Attributes

Interface IF_SWLT_SQLM_DATA_PROVIDER has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	GET_AGGR_RESULTS	Instance method	Public	Method		20121128
2	GET_AGGR_RESULT_FOR_CODE_LINES	Instance method	Public	Method		20130117
3	GET_NUMBER_OF_RECORDS	Instance method	Public	Method		20121211
4	GET_RESULTS_FOR_CODE_LINE	Instance method	Public	Method		20121128

Events

Interface IF_SWLT_SQLM_DATA_PROVIDER has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TYP_S_AGGR_RESULTS	Public	See coding			20121128	BEGIN OF typ_s_aggr_results. INCLUDE TYPE swlt_s_code_line_key AS code_line_key. TYPES: include_name TYPE sy-repid, include_line TYPE i, total_time TYPE sqlmruntimesum, executions_num TYPE sqlmexecnt, table_names TYPE sqlmtablenames, stmntkind TYPE sqlmstmtkind, max_time TYPE sqlmruntimemax, min_time TYPE sqlmruntimemin, avg_time TYPE sqlmruntimeavg, time_sqs TYPE sqlmruntimesqs, time_dev TYPE sqlmruntimedev, db_count TYPE sqlmdbcountsum, db_count_min TYPE sqlmdbcountmin, db_count_max TYPE sqlmdbcountmax, db_count_avg TYPE sqlmdbcountavg, db_count_sqs TYPE sqlmdbcountsqs, db_count_dev TYPE sqlmdbcountdev, int_sessions TYPE sqlmrollareacnt, int_sessions_quot TYPE sqlmexecntrollareacnt, table_class TYPE swlt_d_md_table_class, size_category TYPE swlt_d_md_size_category, is_buffered TYPE swlt_d_md_is_buffered, buffering_kind TYPE swlt_d_md_buffering_kind, row_or_col_store TYPE swlt_d_md_store_type, column_num TYPE swlt_d_md_column_num, key_column_num TYPE swlt_d_md_key_col_num, width_in_bytes TYPE i, fragment TYPE sqlmfragment, package_name TYPE devclass, contains_outdated TYPE sqlmoutdated, obj_name TYPE sobj_name, obj_type TYPE trobjtype, END OF typ_s_aggr_results
2	TYP_S_RESULT	Public	See coding			20121128	BEGIN OF typ_s_result, roottype TYPE sqlmroottype, rootid TYPE sqlmrootname, stmtkind TYPE sqlmstmtkind, table_names TYPE sqlmtablenames, total_time TYPE sqlmruntimesum, executions_num TYPE sqlmexecnt, max_time TYPE sqlmruntimemax, min_time TYPE sqlmruntimemin, avg_time TYPE sqlmruntimeavg, time_sqs TYPE sqlmruntimesqs, time_dev TYPE sqlmruntimedev, db_count TYPE sqlmdbcountsum, db_count_min TYPE sqlmdbcountmin, db_count_max TYPE sqlmdbcountmax, db_count_avg TYPE sqlmdbcountavg, db_count_sqs TYPE sqlmdbcountsqs, db_count_dev TYPE sqlmdbcountdev, int_sessions TYPE sqlmrollareacnt, int_sessions_quot TYPE sqlmexecntrollareacnt, fragment TYPE sqlmfragment, outdated TYPE sqlmoutdated, END OF typ_s_result
3	TYP_T_AGGR_RESULTS	Public	See coding			20121128	typ_t_aggr_results TYPE STANDARD TABLE OF typ_s_aggr_results WITH NON-UNIQUE KEY code_line_key
4	TYP_T_CODE_LINE_KEYS	Public	See coding			20130117	typ_t_code_line_keys TYPE HASHED TABLE OF swlt_s_code_line_key WITH UNIQUE KEY progname progkind proctype procname procline
5	TYP_T_RESULTS	Public	See coding			20121128	typ_t_results TYPE STANDARD TABLE OF typ_s_result WITH DEFAULT KEY

Method Signatures

Method GET_AGGR_RESULTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_AGGR_RESULTS	Call by reference	☐	Type reference (TYPE)	IF_SWLT_SQLM_DATA_PROVIDER=>TYP_T_AGGR_RESULTS			20121128
2	Importing	I_SELECTION_FILTER	Call by reference	☐	Object reference (TYPE REF TO)	IF_SWLT_SQLM_SEL_FILTER			20121128

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130103

Method GET_AGGR_RESULT_FOR_CODE_LINES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_AGGR_RESULTS	Call by reference	☐	Type reference (TYPE)	IF_SWLT_SQLM_DATA_PROVIDER=>TYP_T_AGGR_RESULTS			20130117
2	Importing	I_CODE_LINE_KEYS	Call by reference	☐	Type reference (TYPE)	TYP_T_CODE_LINE_KEYS			20130117
3	Importing	I_SELECTION_FILTER	Call by reference	☐	Object reference (TYPE REF TO)	IF_SWLT_SQLM_SEL_FILTER			20130117

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130117

Method GET_NUMBER_OF_RECORDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_NUM_RECS	Value transfer	☐	Type reference (TYPE)	I			20121211

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130103

Method GET_RESULTS_FOR_CODE_LINE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_RESULTS	Call by reference	☐	Type reference (TYPE)	TYP_T_RESULTS			20121128
2	Importing	I_CODE_LINE_KEY	Call by reference	☐	Type reference (TYPE)	SWLT_S_CODE_LINE_KEY			20121128
3	Importing	I_SELECTION_FILTER	Call by reference	☐	Object reference (TYPE REF TO)	IF_SWLT_SQLM_SEL_FILTER			20121129

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130103

History

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