SAP Reports / Programs | Basis Components | ABAP Workbench, Java IDE and Infrastructure | Workbench Tools: Editors, Painters, Modelers(BC-DWB-TOO) SAP BC

SWLT_START SAP ABAP Report - SQL Performance Tuning Worklist: Selection Screen







SWLT_START is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The SQL Performance Tuning Worklist tool (transaction SWLT ) enables you to find ABAP SQL code that has potential for performance improvement in productive business processes...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter SWLT_START into the relevant SAP transactions such as SE38 or SE80


Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

SWLT - SQL Performance Tuning Worklist


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT SWLT_START. "Basic submit
SUBMIT SWLT_START AND RETURN. "Return to original report after report execution complete
SUBMIT SWLT_START VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: P_ATDEST = D .
Selection Text: P_BADI = D .
Selection Text: P_CIDEST = D .
Selection Text: P_IS_ATC = ABAP Test Cockpit
Selection Text: P_IS_CI = Code Inspector
Selection Text: P_IS_NON = None
Selection Text: P_MINEXC = Minimum Number of Executions
Selection Text: P_SCVACT = Use Coverage Analyzer
Selection Text: P_SCVRFC = RFC Destination
Selection Text: P_SC_AGG = Aggregate Findings in Overview
Selection Text: P_SC_FRC = Suppress Records w/o Findings
Selection Text: P_SNAPS1 = Overall Latest Snapshot
Selection Text: SO_ROOY = Request Type
Selection Text: SO_ROOT = Request Entry Point
Selection Text: SO_PACK = D .
Selection Text: SO_OBJTP = D .
Selection Text: SO_OBJNM = D .
Selection Text: P_TMTIME = Show Top n Execution Times
Selection Text: P_TMNONE = Show All Results
Selection Text: P_TMEXEC = Show Top n Executions
Selection Text: P_SQLMAX = Top n Limit Count
Selection Text: P_SNAPS3 = Individual Snapshot
Selection Text: P_SNAPS2 = Latest Snapshot by System
Title: SQL Performance Tuning Worklist: Selection Screen
Text Symbol: S46 = Successfully deleted &1 ATC cache entries
Text Symbol: S45 = Successfully deleted 1 ATC cache entry
Text Symbol: S44 = ATC cache contains no expired entries
Text Symbol: S43 = ATC cache is already empty
Text Symbol: S32 = @0S@Latest result of specified Code Inspection will be used
Text Symbol: S30 = Additional Options
Text Symbol: S20 = @0S@Retrieves number of processing block executions
Text Symbol: S19 = Specify a valid selection for SQL Monitor snapshot data
Text Symbol: S18 = System &1, created on &2 by &3
Text Symbol: S17 = Latest SQL Monitor Snapshots per System
Text Symbol: S16 = All SQL Monitor Snapshots
Text Symbol: AT2 = ATC Run Series &1 (&2)
Text Symbol: AT3 = Select ATC Result
Text Symbol: ATC = Select an ATC run series configuration





Text Symbol: ATH = ATC Results (&1)
Text Symbol: B00 = Failed to retrieve BAdI implementations: &1
Text Symbol: B01 = Failed to load BAdI implementation: &1
Text Symbol: B02 = Result Ranking
Text Symbol: B03 = Order by executions, total time
Text Symbol: C00 = Owner / Scope
Text Symbol: C01 = Scheduled On
Text Symbol: C02 = Description
Text Symbol: C03 = Cached
Text Symbol: CI4 = Select Inspection
Text Symbol: CIG = global
Text Symbol: CIH = Code Inspections (&1)
Text Symbol: CIT = Inspection &1 (&2)
Text Symbol: CIU = of User &1
Text Symbol: E00 = No Code Inspections found
Text Symbol: E01 = Code Inspection data access not possible for destination &1
Text Symbol: E02 = No ATC results found
Text Symbol: E04 = ATC data access not possible for destination &1
Text Symbol: E05 = No ATC run series matching the selection criteria found
Text Symbol: RFC = RFC Destination
Text Symbol: S00 = Object Set
Text Symbol: S01 = SQL Monitor Settings
Text Symbol: S02 = Static Check Settings
Text Symbol: S03 = SQL Monitor Snapshot Selection
Text Symbol: S05 = Code Coverage Settings
Text Symbol: S07 = Manage Snapshots
Text Symbol: S09 = Selection screen has been reset
Text Symbol: S12 = @0S@Static checks may return findings outside the object set
Text Symbol: S13 = Select Snapshot
Text Symbol: S14 = No snapshot selected or available
Text Symbol: S15 = No snapshots currently available


INCLUDES used within this REPORT SWLT_START

No INCLUDES are used within this REPORT code!


TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

SWLT_UI_START CALL FUNCTION 'SWLT_UI_START' EXPORTING i_selection_filter = me->selection_filter i_display_strategy = l_display_strategy EXCEPTIONS failure = 1 OTHERS = 2.

RS_SET_SELSCREEN_STATUS CALL FUNCTION 'RS_SET_SELSCREEN_STATUS' EXPORTING p_status = 'INIT' TABLES p_exclude = l_tab.

ICON_CREATE





CALL FUNCTION 'ICON_CREATE' EXPORTING name = 'ICON_CHANGE' text = 'Select Snapshot'(s13) add_stdinf = '' IMPORTING result = snch_btn EXCEPTIONS icon_not_found = 0 outputfield_too_short = 0 OTHERS = 0.

ICON_CREATE CALL FUNCTION 'ICON_CREATE' EXPORTING name = 'ICON_CHANGE' text = 'Select Snapshot'(s13) add_stdinf = '' IMPORTING result = snch_btn EXCEPTIONS icon_not_found = 0 outputfield_too_short = 0 OTHERS = 0.

ICON_CREATE CALL FUNCTION 'ICON_CREATE' EXPORTING name = 'ICON_CANCEL' info = '' add_stdinf = '' IMPORTING result = l_icon EXCEPTIONS icon_not_found = 1 outputfield_too_short = 2 OTHERS = 3.

ICON_CREATE CALL FUNCTION 'ICON_CREATE' EXPORTING name = 'ICON_ACTIVATE' info = '' add_stdinf = '' IMPORTING result = l_icon EXCEPTIONS icon_not_found = 1 outputfield_too_short = 2 OTHERS = 3.

ICON_CREATE CALL FUNCTION 'ICON_CREATE' EXPORTING name = 'ICON_CREATE' text = text-ci4 add_stdinf = '' " 'X': Qinfo. ' ': No Qinfo, no std. Qinfo

ICON_CREATE CALL FUNCTION 'ICON_CREATE' EXPORTING name = 'ICON_CHANGE' text = text-ci4 add_stdinf = '' " 'X': Qinfo. ' ': No Qinfo, no std. Qinfo

ICON_CREATE CALL FUNCTION 'ICON_CREATE' EXPORTING name = 'ICON_CHANGE' text = text-at3 add_stdinf = '' " 'X': Qinfo. ' ': No Qinfo, no std. Qinfo

VRM_SET_VALUES CALL FUNCTION 'VRM_SET_VALUES' EXPORTING id = 'P_BADI' values = l_values EXCEPTIONS id_illegal_name = 1 OTHERS = 2.

REUSE_ALV_GRID_DISPLAY CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_callback_program = 'SWLT_START' i_callback_pf_status_set = 'SNF4_CALLBACK_SET_PF_STATUS' i_callback_user_command = 'SNF4_CALLBACK_USER_COMMAND' i_structure_name = 'SWLT_S_SNAPSHOT_F4' is_layout = l_str_layout it_fieldcat = l_tab_fcat is_variant = l_str_variant i_screen_start_column = 5 i_screen_start_line = 8 i_screen_end_column = 100 i_screen_end_line = 15 TABLES t_outtab = s_tab_snapshots_f4 EXCEPTIONS program_error = 1 OTHERS = 2.

REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_structure_name = 'SWLT_S_SNAPSHOT_F4' i_client_never_display = 'X' CHANGING ct_fieldcat = r_tab_fieldcat.

RFC_GET_SYSTEM_INFO CALL FUNCTION 'RFC_GET_SYSTEM_INFO' EXPORTING destination = l_rfc_dest IMPORTING rfcsi_export = l_rfc_info dest_communication_message = l_comm_message EXCEPTIONS authority_not_available = 1 OTHERS = 2.

VALIDATE_CI_KEY_REMOTE CALL FUNCTION 'VALIDATE_CI_KEY_REMOTE' DESTINATION p_cidest EXPORTING iv_ci_inspection_name = p_ciname iv_ci_inspection_user = p_ciresp IMPORTING " ev_system_name = l_sysid es_result = l_str_result EXCEPTIONS communication_failure = 2 MESSAGE l_rfc_error system_failure = 2 MESSAGE l_rfc_error no_code_inspection_specified = 1 code_inspection_not_found = 1 OTHERS = 1.

VALIDATE_CI_KEY_REMOTE CALL FUNCTION 'VALIDATE_CI_KEY_REMOTE' EXPORTING iv_ci_inspection_name = p_ciname iv_ci_inspection_user = p_ciresp IMPORTING es_result = l_str_result EXCEPTIONS no_code_inspection_specified = 1 code_inspection_not_found = 1 OTHERS = 1.

RFC_GET_SYSTEM_INFO CALL FUNCTION 'RFC_GET_SYSTEM_INFO' EXPORTING destination = l_rfc_dest IMPORTING rfcsi_export = l_rfc_info dest_communication_message = l_comm_message EXCEPTIONS authority_not_available = 1 OTHERS = 2.

SATC_CI_GET_RESULT_CATALOG CALL FUNCTION 'SATC_CI_GET_RESULT_CATALOG' DESTINATION p_atdest EXPORTING i_run_series = run_series_ranges IMPORTING e_result_catalog = atc_results EXCEPTIONS communication_failure = 1 MESSAGE l_rfc_error system_failure = 1 MESSAGE l_rfc_error not_authorized = 2 OTHERS = 2.

SATC_CI_GET_RESULT_CATALOG CALL FUNCTION 'SATC_CI_GET_RESULT_CATALOG' EXPORTING i_run_series = run_series_ranges IMPORTING e_result_catalog = atc_results EXCEPTIONS not_authorized = 1 OTHERS = 1.

GET_CI_NAME_REMOTE CALL FUNCTION 'GET_CI_NAME_REMOTE' EXPORTING iv_max_number_records = max_number_records it_range_ci_inspection_name = l_tab_rng_name IMPORTING ev_system_name = l_sysid TABLES et_result = s_tab_inspections.

GET_CI_NAME_REMOTE CALL FUNCTION 'GET_CI_NAME_REMOTE' DESTINATION p_cidest EXPORTING iv_max_number_records = max_number_records it_range_ci_inspection_name = l_tab_rng_name IMPORTING ev_system_name = l_sysid TABLES et_result = s_tab_inspections EXCEPTIONS communication_failure = 1 MESSAGE l_errortext system_failure = 1 MESSAGE l_errortext.

REUSE_ALV_GRID_DISPLAY CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_callback_program = 'SWLT_START' i_callback_pf_status_set = 'CIF4_CALLBACK_SET_PF_STATUS' i_callback_user_command = 'CIF4_CALLBACK_USER_COMMAND' i_structure_name = 'SWLT_S_NAME_SEARCH_RESULT' is_layout = l_str_layout it_fieldcat = l_tab_fcat is_variant = l_str_variant i_screen_start_column = 5 i_screen_start_line = 8 i_screen_end_column = 100 i_screen_end_line = 15 TABLES t_outtab = l_tab_lines EXCEPTIONS program_error = 1 OTHERS = 2.

SATC_CI_GET_RESULT_CATALOG CALL FUNCTION 'SATC_CI_GET_RESULT_CATALOG' DESTINATION p_atdest IMPORTING e_result_catalog = s_tab_atc_results EXCEPTIONS OTHERS = 1.




RFC_GET_SYSTEM_INFO CALL FUNCTION 'RFC_GET_SYSTEM_INFO' EXPORTING destination = l_rfc_dest IMPORTING rfcsi_export = l_rfc_info EXCEPTIONS OTHERS = 1.

REUSE_ALV_GRID_DISPLAY CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_callback_program = 'SWLT_START' i_callback_pf_status_set = 'ATF4_CALLBACK_SET_PF_STATUS' i_callback_user_command = 'ATF4_CALLBACK_USER_COMMAND' i_structure_name = 'SWLT_S_ATC_SEARCH_RESULT' is_layout = l_str_layout it_fieldcat = l_tab_fcat is_variant = l_str_variant i_screen_start_column = 5 i_screen_start_line = 8 i_screen_end_column = 100 i_screen_end_line = 15 TABLES t_outtab = l_tab_lines EXCEPTIONS program_error = 1 OTHERS = 2.

REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_structure_name = 'SWLT_S_NAME_SEARCH_RESULT' i_client_never_display = 'X' CHANGING ct_fieldcat = r_tab_fieldcat.

REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_structure_name = 'SWLT_S_ATC_SEARCH_RESULT' i_client_never_display = 'X' CHANGING ct_fieldcat = r_tab_fieldcat.



Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name SWLT_START or its description.