RSORAAJV is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Display joins of v$-, gv$- and dba-views...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 RSORAAJV into the relevant SAP transactions such as SE38 or SE80
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.
Selection Text: P_STMTID = D .
Selection Text: P_RSTAT = List runtime statistics
Selection Text: P_DBCON = D .
Selection Text: P_CONTNT = List content
Title: Display joins of V$-, GV$- and DBA-Views (Owner SYS)
Text Symbol: M99 = Execution stopped due to errors
Text Symbol: M73 = Unknown internal error, see log and trace files
Text Symbol: M72 = SQL message:
Text Symbol: M71 = SQL error code:
Text Symbol: M70 = DB-Error occured while getting data
Text Symbol: M60 = Statement could not be found in the database
Text Symbol: M54 = Please enter an existing statement ID
Text Symbol: M53 = Statement does not exist:
Text Symbol: M52 = Data base system is not Oracle:
Text Symbol: M51 = Please enter a valid DB connection ID
Text Symbol: M50 = DB connection does not exist (table DBCON)
Text Symbol: M12 = (Details see following message)
Text Symbol: M01 = Error in parsing SQL statement:
Text Symbol: M00 = Following texts are used as error messages
Text Symbol: 111 = Value
Text Symbol: 110 = Statistics name
Text Symbol: 109 = File / Block combinations:
Text Symbol: 107 = You find the SQL statement (query) at the end of this list
Text Symbol: 106 = Time Waited
Text Symbol: 105 = Tot.Timeouts
Text Symbol: 104 = Total Waits
Text Symbol: 103 = Event Name
Text Symbol: 101 = SQL statement (query) is:
No INCLUDES are used within this REPORT code!
No SAP DATABASE tables are accessed within this REPORT code!
C_SCAN_ORA_SELECT_STATEMENT CALL FUNCTION 'C_SCAN_ORA_SELECT_STATEMENT' EXPORTING statement = p_sql_statement dbcon = p_dbcon * IMPORTING * operation =
CHANGING ptables = pt_tables pcolumns = pt_columns EXCEPTIONS no_statement = 1 no_operation_found = 2 invalid_sql_operation = 3 error_in_hint = 4 error_in_parsing_select_list = 5 error_in_table_references = 6 columns_not_matching_with_tabs = 7 error_reducing_distinct = 8 error_in_set_operator = 9 no_from_found = 10 OTHERS = 11.
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.