RSDB4XPL SAP ABAP Report - DB2/400 Explain

RSDB4XPL is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report displays low-level SQL and query optimizer information for statements monitored by the new memory-based SQL database monitor...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 RSDB4XPL into the relevant SAP transactions such as SE38 or SE80

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.

Text pool values

INCLUDES used within this REPORT RSDB4XPL

INCLUDE RSDB4API.

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:

DB4_EXPLAIN_DATA_ST04
  call function 'DB4_EXPLAIN_DATA_ST04'
    EXPORTING
      qqkey               = qqkey
      ipltime             = ipltime
      system_id           = sysid
    IMPORTING
      sq1000_data         = sq1000_data
      sqtext_data         = sqtext_data
    TABLES
      sqhvar_data         = sqhvar_data
      explain             = explain
    EXCEPTIONS
      statement_not_found = 1
      others              = 2.

RS_TREE_CONSTRUCT
  call function 'RS_TREE_CONSTRUCT'
    TABLES
      nodetab      = info_tree_tab
    EXCEPTIONS
      tree_failure = 1.

RS_TREE_EXPAND
    call function 'RS_TREE_EXPAND'
      EXPORTING
        node_id     = main_level_node
        all         = ' '
        list_scroll = 'X'
      EXCEPTIONS
        not_found   = 1
        others      = 2.

ST04_XPL_TREE_LIST_DISPLAY
  CALL FUNCTION 'ST04_XPL_TREE_LIST_DISPLAY'
    EXPORTING
      p_PFKEY  = ST04_PFKEY
      p_CPROG  = ST04_CPROG
      p_TITLE  = ST04_TITLE
      p_DYNNR  = ST04_DYNNR
    TABLES
      TREE_TAB = info_tree_tab.

DB4_APPEND_INFO_TREE
  call function 'DB4_APPEND_INFO_TREE'
    EXPORTING
      name        = 'Root'                                  "#EC NOTEXT
      tlevel      = 1
      text        = i_text
    TABLES
      access_plan = p_info_tree_tab.

DB4_EXPLAIN_SQL_ST04
  call function 'DB4_EXPLAIN_SQL_ST04'
    EXPORTING
      level         = 2
      sq1000_data   = sq1000_data
    TABLES
      info_tree_tab = p_info_tree_tab
      sqhvar_data   = sqhvar_data.

DB4_EXPLAIN_HEADINGS
    call function 'DB4_EXPLAIN_HEADINGS'
      EXPORTING
        explain       = wa_explain
        is_join       = i_is_join
      TABLES
        info_tree_tab = p_info_tree_tab
      CHANGING
        level         = i_level.

DB4_EXPLAIN_TSC
        call function 'DB4_EXPLAIN_TSC'
          EXPORTING
            explain       = wa_explain
            is_join       = i_is_join
            level         = i_level
          TABLES
            info_tree_tab = p_info_tree_tab.

DB4_EXPLAIN_IDU
        call function 'DB4_EXPLAIN_IDU'
          EXPORTING
            explain       = wa_explain
            is_join       = i_is_join
            level         = i_level
          TABLES
            info_tree_tab = p_info_tree_tab.

DB4_EXPLAIN_IDC
        call function 'DB4_EXPLAIN_IDC'
          EXPORTING
            explain       = wa_explain
            level         = i_level
          TABLES
            info_tree_tab = p_info_tree_tab.

DB4_EXPLAIN_SRT
        call function 'DB4_EXPLAIN_SRT'
          EXPORTING
            explain       = wa_explain
            level         = i_level
          TABLES
            info_tree_tab = p_info_tree_tab.

DB4_EXPLAIN_TMF
        call function 'DB4_EXPLAIN_TMF'
          EXPORTING
            explain       = wa_explain
            level         = i_level
          TABLES
            info_tree_tab = p_info_tree_tab.

DB4_EXPLAIN_SUB
        call function 'DB4_EXPLAIN_SUB'
          EXPORTING
            explain       = wa_explain
            level         = i_level
          TABLES
            info_tree_tab = p_info_tree_tab.

DB_SQL_WRITE_TO_ITAB
  CALL FUNCTION 'DB_SQL_WRITE_TO_ITAB'
    EXPORTING
      STMT_STR  = p_stmt_str
      STMT_LEN  = p_stmt_len
      LINE_SIZE = p_line_size
    CHANGING
      TEXT_TAB  = sql_tab.