SAP Reports / Programs
RSXPLADA SAP ABAP Report - ADABAS-Specific Module for Explain SQL
RSXPLADA 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 RSXPLADA 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 RSXPLADA. "Basic submit
SUBMIT RSXPLADA AND RETURN. "Return to original report after report execution complete
SUBMIT RSXPLADA VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: ADABAS-Specific Module for Explain SQL
INCLUDES used within this REPORT RSXPLADA
INCLUDE RSTRCI01.
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_TREE_CONSTRUCT CALL FUNCTION 'RS_TREE_CONSTRUCT' TABLES nodetab = query_tree EXCEPTIONS OTHERS = 1.
RS_TREE_LIST_DISPLAY CALL FUNCTION 'RS_TREE_LIST_DISPLAY' EXPORTING callback_program = 'RSXPLADA' callback_user_command = 'CALLBACK_USER_COMMAND' callback_text_display = 'DISPLAY_STATEMENT_AND_PLAN' * screen_start_line = start_line * screen_start_column = 10 * screen_end_line = end_line * screen_end_column = 80 IMPORTING f15 = f15.
ADA_POPUP_GET_HINT CALL FUNCTION 'ADA_POPUP_GET_HINT' IMPORTING p_hint = g_cm_hint CHANGING statement = stmt_str EXCEPTIONS profile_parameter_inactive = 1 OTHERS = 2.
DB_EXPLAIN_PLAN CALL FUNCTION 'DB_EXPLAIN_PLAN' EXPORTING statement = stmt_str * NO_DISPLAY = ' ' * STMT_LG = 0 con_name = save_con_name TABLES values = save_values * PLAN = * ORA_PAR = EXCEPTIONS explain_failed = 1 OTHERS = 2.
DB_EXPLAIN_PLAN CALL FUNCTION 'DB_EXPLAIN_PLAN' EXPORTING statement = stmt_str no_display = 'X' con_name = save_con_name TABLES values = save_values plan = plan_tab[] EXCEPTIONS explain_failed = 1 OTHERS = 2.
TRANSFORM_EXPLAIN_SDB CALL FUNCTION 'TRANSFORM_EXPLAIN_SDB' EXPORTING explain_table = plan_tab[] TABLES explain_text = lt_data[].
ADA_POPUP_WITH_TABLE CALL FUNCTION 'ADA_POPUP_WITH_TABLE' EXPORTING startpos_col = 10 startpos_row = 10 TABLES valuetab = lt_data EXCEPTIONS OTHERS = 0.
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 RSXPLADA or its description.