RSDB4EXP SAP ABAP Report - DB2/400: Explain

RSDB4EXP 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 about a selected query...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 RSDB4EXP 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 RSDB4EXP

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:

DB4_EXPLAIN_DATA_ST05
      call function 'DB4_EXPLAIN_DATA_ST05'
        tables
          explain = explain
        changing
          stmt_text = long_stmttext.

DB4_EXPLAIN_DATA_ST05
      call function 'DB4_EXPLAIN_DATA_ST05'
        tables
          explain = explain
        changing
          stmt_text = long_stmttext.

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.

RS_TREE_EXPAND
    call function 'RS_TREE_EXPAND'
      exporting
        node_id     = '000001'
        all         = 'X'
        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_STMT_INFO_ST05
  call function 'DB4_EXPLAIN_STMT_INFO_ST05'
    exporting
      level         = 2
    tables
      info_tree_tab = p_info_tree_tab
      explain       = explain.

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_LOC
        call function 'DB4_EXPLAIN_LOC'
          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.