SAP Reports / Programs
RSORAAJV SAP ABAP Report - Display joins of V$-, GV$- and DBA-Views (Owner SYS)
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
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 RSORAAJV. "Basic submit
SUBMIT RSORAAJV AND RETURN. "Return to original report after report execution complete
SUBMIT RSORAAJV VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
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:
INCLUDES used within this REPORT RSORAAJV
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:
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.
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 RSORAAJV or its description.