SAP Reports / Programs
RSXPLORA SAP ABAP Report - Subroutine for ORACLE Explain Functions
RSXPLORA is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter RSXPLORA 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.
SUBMIT RSXPLORA. "Basic submit
SUBMIT RSXPLORA AND RETURN. "Return to original report after report execution complete
SUBMIT RSXPLORA VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: Subroutine for ORACLE Explain Functions
Text Symbol: 001 = Name of SAP table .......
Text Symbol: 002 = Name of SQL table .......
Text Symbol: 003 = Table class..............
Text Symbol: 004 = Min. number of entries ..
Text Symbol: 005 = Max. number of entries ..
Text Symbol: 006 = Av. number of entries ...
Text Symbol: 007 = Table, SAP buffered......
INCLUDES used within this REPORT RSXPLORA
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:
STRING_CONCATENATE CALL FUNCTION 'STRING_CONCATENATE' EXPORTING string1 = plan-line+40 string2 = '(' IMPORTING string = plan-line+40.
STRING_CONCATENATE CALL FUNCTION 'STRING_CONCATENATE' EXPORTING string1 = plan-line+40 string2 = plan_table-object_type IMPORTING string = plan-line+40.
STRING_CONCATENATE CALL FUNCTION 'STRING_CONCATENATE' EXPORTING string1 = plan-line+40 string2 = ')' IMPORTING string = plan-line+40.
RS_TREE_CONSTRUCT CALL FUNCTION 'RS_TREE_CONSTRUCT' TABLES nodetab = query_tree EXCEPTIONS OTHERS = 1.
RS_TREE_EXPAND CALL FUNCTION 'RS_TREE_EXPAND' EXPORTING all = 'X' node_id = 1.
RS_TREE_LIST_DISPLAY CALL FUNCTION 'RS_TREE_LIST_DISPLAY' EXPORTING callback_program = 'RSXPLORA' callback_user_command = 'CALLBACK_USER_COMMAND' callback_text_display = 'DISPLAY_STATEMENT' callback_moreinfo_display = 'MOREINFO_DISPLAY' text_length1 = 75 * screen_start_line = * start_line = start_line * screen_start_column = 10 * screen_end_line = end_line * screen_end_column = 80 IMPORTING f15 = f15.
DB_SQL_PARSE CALL FUNCTION 'DB_SQL_PARSE' EXPORTING stmt_str = g_stmt_literal stmt_len = stmt_literal_len IMPORTING sql_stmt = sql_stmt.
DB_SQL_PARSE CALL FUNCTION 'DB_SQL_PARSE' EXPORTING stmt_str = stmt_str stmt_len = stmt_len IMPORTING sql_stmt = sql_stmt.
DB_SQL_WRITE CALL FUNCTION 'DB_SQL_WRITE' EXPORTING stmt_str = g_stmt_literal stmt_len = stmt_literal_len sql_stmt = sql_stmt start_pos = 1 line_size = 100.
DB_SQL_WRITE CALL FUNCTION 'DB_SQL_WRITE' EXPORTING stmt_str = stmt_str stmt_len = stmt_len sql_stmt = sql_stmt start_pos = 1 line_size = 100.
CONVERSION_EXIT_SDATE_OUTPUT CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT' EXPORTING input = _plan_table_tab-timestamp(8) IMPORTING output = timestamp_date.
CONVERSION_EXIT_SDATE_OUTPUT CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT' EXPORTING input = g_hist_begin_ts(8) IMPORTING output = begin_dc.
CONVERSION_EXIT_SDATE_OUTPUT CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT' EXPORTING input = g_hist_end_ts(8) IMPORTING output = end_dc.
CONVERSION_EXIT_SDATE_OUTPUT CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT' EXPORTING input = _plan_table_tab-timestamp(8) IMPORTING output = timestamp_date.
DB_ORA_POPUP_GET_HINT CALL FUNCTION 'DB_ORA_POPUP_GET_HINT' EXPORTING start_column = 10 start_row = 3 textline1 = textline1 textline2 = textline2 * TEXTLINE3 = ' ' IMPORTING hint = hint.
STUO_OPTIMIZER_TRACE CALL FUNCTION 'STUO_OPTIMIZER_TRACE' EXPORTING statement = stmt_str no_display = 'X' TABLES file_list = trcfile_list EXCEPTIONS explain_failed = 1 wrong_database = 2 file_not_readable = 3 OTHERS = 4.
DB_ORA_EXPLAIN_GET_SESSION_PAR CALL FUNCTION 'DB_ORA_EXPLAIN_GET_SESSION_PAR' CHANGING i_t_altsess_par = g_i_t_altsess_par.
DB_ORA_SHOW_BINDVAR CALL FUNCTION 'DB_ORA_SHOW_BINDVAR' EXPORTING ora_par = bind_ora_par IMPORTING rc = rc.
CALL FUNCTION 'DB_ORA_EXPORT_SQL_TESTCASE' EXPORTING stmt_str = stmt_str sql_id = g_sql_id schema = g_schemaname con_name = g_con_name.
DB_EXPLAIN_PLAN CALL FUNCTION 'DB_EXPLAIN_PLAN' "#EC * EXPORTING statement = l_stmt_str con_name = ora_par-con_name TABLES values = g_values plan = expl_plan ora_par = ora_par EXCEPTIONS explain_failed = 1 OTHERS = 2.
DB_EXPLAIN_PLAN CALL FUNCTION 'DB_EXPLAIN_PLAN' "#EC * EXPORTING statement = l_stmt_str con_name = ora_par-con_name TABLES values = g_values ora_par = ora_par EXCEPTIONS explain_failed = 1 OTHERS = 2.
DB_DBSCHEMA CALL FUNCTION 'DB_DBSCHEMA' IMPORTING dbschema = l_schemaname.
DB_GET_RELEASE CALL FUNCTION 'DB_GET_RELEASE' IMPORTING release = version_string.
DB_SQL_PARSE CALL FUNCTION 'DB_SQL_PARSE' EXPORTING stmt_str = g_stmt_literal stmt_len = stmt_literal_len IMPORTING sql_stmt = sql_stmt.
DB_SQL_PARSE CALL FUNCTION 'DB_SQL_PARSE' EXPORTING stmt_str = stmt_str stmt_len = stmt_len IMPORTING sql_stmt = sql_stmt.
DB_SQL_WRITE_TO_ITAB CALL FUNCTION 'DB_SQL_WRITE_TO_ITAB' EXPORTING stmt_str = g_stmt_literal stmt_len = stmt_literal_len line_size = 100 CHANGING text_tab = t_text_output_stmt.
DB_SQL_WRITE_TO_ITAB CALL FUNCTION 'DB_SQL_WRITE_TO_ITAB' EXPORTING stmt_str = stmt_str stmt_len = stmt_len line_size = 100 CHANGING text_tab = t_text_output_stmt.
DB_ORA_SHOW_DBMS_XPLAN_DISPLAY CALL FUNCTION 'DB_ORA_SHOW_DBMS_XPLAN_DISPLAY' EXPORTING t_text_output = t_text_output IMPORTING rc = rc.
CONVERSION_EXIT_SDATE_OUTPUT CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT' EXPORTING input = wa_plan_hash_value-timestamp(8) IMPORTING output = timestamp_date.
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 RSXPLORA or its description.