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
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
Below is a list of transaction codes which are relevant to this SAP report
SWLT - SQL Performance Tuning Worklist
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.
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
No INCLUDES are used within this REPORT code!
No SAP DATABASE tables are accessed within this REPORT code!
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.
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.
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.
SWLT_START - SQL Performance Tuning Worklist: Selection Screen SWLT_START - SQL Performance Tuning Worklist: Selection Screen SWLT_SQLM_CREATE_SNAPSHOT - Create Snapshot of SQL Monitor Data (Remote or Local) SWLT_SQLM_CREATE_SNAPSHOT - Create Snapshot of SQL Monitor Data (Remote or Local) SWLT_MERGE_TEST - Program SWLT_MERGE_TEST SWLT_MERGE_TEST - Program SWLT_MERGE_TEST