SAP Reports / Programs
SQLM_DISPLAY_DATA SAP ABAP Report - SQL Monitor: Data Display
SQLM_DISPLAY_DATA 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 SQLM_DISPLAY_DATA 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
SQLMD - Display SQL Monitor Data
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 SQLM_DISPLAY_DATA. "Basic submit
SUBMIT SQLM_DISPLAY_DATA AND RETURN. "Return to original report after report execution complete
SUBMIT SQLM_DISPLAY_DATA 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: SO_TABLE = D .
Selection Text: SO_RTYPE = D .
Selection Text: SO_RNAME = D .
Selection Text: SO_PACK = D .
Selection Text: SO_OBJTP = D .
Selection Text: SO_OBJNM = D .
Selection Text: P_UPTO = Maximal Number of Records
Selection Text: P_RTSUM = Total Time
Selection Text: P_RTCNT = Executions
Selection Text: P_NONE = None
Selection Text: P_AGGSRC = By Source Position
Selection Text: P_AGGROO = By Request
Title: SQL Monitor: Data Display
Text Symbol: TAB = Tables
Text Symbol: T01 = Records updated
Text Symbol: ROO = Requests
Text Symbol: OBY = Order by
Text Symbol: INF = Application Help for SQL Monitor
Text Symbol: E00 = No navigation data assigned
Text Symbol: DEV = Objects
Text Symbol: AGG = Aggregation
Text Symbol: 006 = @0S@Application Help
Text Symbol: 005 = Include Line
Text Symbol: 004 = Include Name
Text Symbol: 002 = Records for Src. Pos. &1 &2(&3), &4
Text Symbol: 001 = Records for Request &1 &2
INCLUDES used within this REPORT SQLM_DISPLAY_DATA
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:
RS_SET_SELSCREEN_STATUS call function 'RS_SET_SELSCREEN_STATUS' exporting p_status = 'INIT' tables p_exclude = l_tab.
REUSE_ALV_GRID_DISPLAY call function 'REUSE_ALV_GRID_DISPLAY' exporting i_callback_program = c_this_prog i_callback_pf_status_set = 'CALLBACK_SET_PF_STATUS_X' i_callback_user_command = 'CALLBACK_USER_COMMAND_DETAILS' i_structure_name = 'SQLM_STR_DISPLAY_RECORD' is_variant = l_str_variant is_layout = l_str_layout it_fieldcat = l_tab_fcat it_sort = l_tab_sort * i_screen_start_column = 5 * i_screen_start_line = 8 * i_screen_end_column = 190 * i_screen_end_line = 38 tables t_outtab = me->tab_details exceptions program_error = 1 others = 2.
REUSE_ALV_GRID_DISPLAY call function 'REUSE_ALV_GRID_DISPLAY' exporting i_callback_program = c_this_prog i_callback_pf_status_set = 'CALLBACK_SET_PF_STATUS_X' i_callback_user_command = 'CALLBACK_USER_COMMAND_DETAILS' i_structure_name = 'SQLM_STR_DISPLAY_RECORD' is_layout = l_str_layout it_fieldcat = l_tab_fcat it_sort = l_tab_sort * i_screen_start_column = 5 * i_screen_start_line = 8 * i_screen_end_column = 190 * i_screen_end_line = 38 tables t_outtab = me->tab_details exceptions program_error = 1 others = 2.
REUSE_ALV_GRID_DISPLAY call function 'REUSE_ALV_GRID_DISPLAY' exporting i_callback_program = c_this_prog i_callback_pf_status_set = 'CALLBACK_SET_PF_STATUS' i_callback_user_command = 'CALLBACK_USER_COMMAND' i_structure_name = 'SQLM_STR_DISPLAY_RECORD' is_layout = l_str_layout it_fieldcat = l_tab_fcat is_variant = l_str_variant it_sort = l_tab_sort tables t_outtab = me->tab_records exceptions program_error = 1 others = 2.
REUSE_ALV_FIELDCATALOG_MERGE call function 'REUSE_ALV_FIELDCATALOG_MERGE' exporting i_structure_name = 'SQLM_STR_DISPLAY_RECORD' i_client_never_display = 'X' changing ct_fieldcat = r_tab_fieldcat.
DDIF_DOMA_GET call function 'DDIF_DOMA_GET' exporting name = 'SQLMROOTTYPE' langu = sy-langu tables dd07v_tab = me->tab_roottypes exceptions others = 0.
DDIF_DOMA_GET call function 'DDIF_DOMA_GET' exporting name = 'SQLMRUNLEVEL' langu = sy-langu tables dd07v_tab = me->tab_runlevels exceptions others = 0.
DDIF_DOMA_GET call function 'DDIF_DOMA_GET' exporting name = 'SQLMSTMTKIND' langu = sy-langu tables dd07v_tab = me->tab_stmtkinds exceptions others = 0.
RS_TOOL_ACCESS call function 'RS_TOOL_ACCESS' exporting operation = 'SHOW' object_name = l_include object_type = 'PROG' position = i_str_record-line include = l_include in_new_window = '' exceptions not_executed = 1 invalid_object_type = 2 others = 3.
HELP_OBJECT_SHOW call function 'HELP_OBJECT_SHOW' exporting dokclass = 'RE' doklangu = sy-langu dokname = 'SQLM_DISPLAY_DATA' doktitle = l_title short_text = abap_true tables links = l_tab_links exceptions object_not_found = 1 sapscript_error = 2 others = 3.
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 SQLM_DISPLAY_DATA or its description.