SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | Informix(BC-DB-INF) SAP BC
RSXPLINF SAP ABAP Report - INFORMIX-Specific Module for Explain SQL
RSXPLINF 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 RSXPLINF 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 RSXPLINF. "Basic submit
SUBMIT RSXPLINF AND RETURN. "Return to original report after report execution complete
SUBMIT RSXPLINF VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: INFORMIX-Specific Module for Explain SQL
Text Symbol: 007 = High-Medium-None
Text Symbol: 008 = Number of indexes.............
Text Symbol: 009 = Number of columns.............
Text Symbol: 010 = Table is fragmented and
Text Symbol: 011 = Table is not fragmented and
Text Symbol: 012 = has no blob columns
Text Symbol: 001 = Last update statistics........
Text Symbol: 002 = Update statistics method......
Text Symbol: 003 = Number of rows [current]......
Text Symbol: 004 = Number of rows [systables]....
Text Symbol: 005 = Row length....................
Text Symbol: 006 = High-High-None
Text Symbol: 013 = has blob columns
Text Symbol: 020 = Enter the hint without comment signs /*+ ... */.
Text Symbol: 021 = Number of used Pages..........
Text Symbol: 022 = Clustering grade..............
Text Symbol: 023 = For the hint syntax see the Informix Guide to SQL.
Text Symbol: 024 = Viewtext [sysviews]...
Text Symbol: 014 = not in DBSTATTINF
Text Symbol: 015 = Number of Levels / Leaves.....
Text Symbol: 016 = Columns...
Text Symbol: 017 = Number of Unique..............
Text Symbol: 018 = Involved Tables or Views
Text Symbol: 019 = ..........
INCLUDES used within this REPORT RSXPLINF
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 = HOMEDIR STRING2 = FILENAME IMPORTING STRING = OUTFILE.
STRING_CONCATENATE CALL FUNCTION 'STRING_CONCATENATE' EXPORTING STRING1 = HOMEDIR STRING2 = FILENAME IMPORTING STRING = OUTFILE.
RZL_SLEEP call function 'RZL_SLEEP'.
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' * list_scroll = 'X' " ??? NODE_ID = 1.
RS_TREE_LIST_DISPLAY CALL FUNCTION 'RS_TREE_LIST_DISPLAY' EXPORTING CALLBACK_PROGRAM = 'RSXPLINF' CALLBACK_USER_COMMAND = 'USER_COMMAND' CALLBACK_TEXT_DISPLAY = 'DISPLAY_STATEMENT' CALLBACK_MOREINFO_DISPLAY = 'MOREINFO' IMPORTING F15 = F15.
DB_SQL_PARSE * CALL FUNCTION 'DB_SQL_PARSE' * EXPORTING * STMT_STR = stmt_str * STMT_LEN = stmt_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.
RS_TREE_GET_NODE CALL FUNCTION 'RS_TREE_GET_NODE' EXPORTING NODE_ID = NODE-ID IMPORTING NODE_INFO = NODE_INFO EXCEPTIONS ID_NOT_FOUND = 1 OTHERS = 2.
RS_TREE_SET_NODE CALL FUNCTION 'RS_TREE_SET_NODE' EXPORTING NODE_INFO = NODE_INFO EXCEPTIONS ID_NOT_FOUND = 1 OTHERS = 2.
DB_POPUP_GET_HINT CALL FUNCTION 'DB_POPUP_GET_HINT' EXPORTING START_COLUMN = 10 START_ROW = 3 TEXTLINE1 = textline1 TEXTLINE2 = textline2 IMPORTING HINT = hint.
DB_EXPLAIN_PLAN CALL FUNCTION 'DB_EXPLAIN_PLAN' EXPORTING STATEMENT = L_STMT_STR TABLES VALUES = GLOB_EXPL_VALUES PLAN = EXPL_PLAN EXCEPTIONS EXPLAIN_FAILED = 1 OTHERS = 2.
DB_EXPLAIN_PLAN CALL FUNCTION 'DB_EXPLAIN_PLAN' EXPORTING STATEMENT = L_STMT_STR TABLES VALUES = GLOB_EXPL_VALUES PLAN = EXPL_PLAN EXCEPTIONS EXPLAIN_FAILED = 1 OTHERS = 2.
ENQUEUE_ESRDIRE * call function 'ENQUEUE_ESRDIRE' * exporting * name = l_progname * exceptions * foreign_lock = 1.
POPUP_TO_CONFIRM CALL FUNCTION 'POPUP_TO_CONFIRM' EXPORTING TITLEBAR = 'Restart Workprocess' "#EC NOTEXT TEXT_QUESTION = 'Restart Workprocess?' "#EC NOTEXT TEXT_BUTTON_1 = 'Yes' ICON_BUTTON_1 = 'ICON_DELETE' TEXT_BUTTON_2 = 'No' ICON_BUTTON_2 = 'ICON_CANCEL' DISPLAY_CANCEL_BUTTON = ' ' IMPORTING ANSWER = ANSWER EXCEPTIONS TEXT_NOT_FOUND = 1 OTHERS = 2.
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 RSXPLINF or its description.