SAP Reports / Programs | Basis Components | Use Subcomponents | Oracle Database Monitors(BC-CCM-MON-ORA) SAP BC
RSORAVDV SAP ABAP Report - V$-Tables (Oracle)
RSORAVDV 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 RSORAVDV 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 RSORAVDV. "Basic submit
SUBMIT RSORAVDV AND RETURN. "Return to original report after report execution complete
SUBMIT RSORAVDV VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: V$-Tables (Oracle)
INCLUDES used within this REPORT RSORAVDV
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:
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING ddic_structure = 'GRP_INFO' retfield = 'TAB_GROUP' * PVALKEY = ' ' * DYNPPROG = ' ' * DYNPNR = ' ' * DYNPROFIELD = ' ' * STEPL = 0 window_title = title * VALUE = ' ' * VALUE_ORG = 'C' * MULTIPLE_CHOICE = ' ' * DISPLAY = ' ' * CALLBACK_PROGRAM = ' ' * CALLBACK_FORM = ' ' * MARK_TAB = TABLES value_tab = tab_group field_tab = field_tab return_tab = return_tab * DYNPFLD_MAPPING = * EXCEPTIONS * PARAMETER_ERROR = 1 * NO_VALUES_FOUND = 2 * OTHERS = 3 .
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING ddic_structure = 'VIEW_INFO' retfield = 'TABLE_NAME' * PVALKEY = ' ' * DYNPPROG = ' ' * DYNPNR = ' ' * DYNPROFIELD = ' ' * STEPL = 0 window_title = title * VALUE = ' ' * VALUE_ORG = 'C' * MULTIPLE_CHOICE = ' ' * DISPLAY = ' ' * CALLBACK_PROGRAM = ' ' * CALLBACK_FORM = ' ' * MARK_TAB = TABLES value_tab = t_tbname field_tab = field_tab return_tab = return_tab * DYNPFLD_MAPPING = * EXCEPTIONS * PARAMETER_ERROR = 1 * NO_VALUES_FOUND = 2 * OTHERS = 3 .
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING ddic_structure = 'FIELD_INFO' retfield = 'COLUMNA' * PVALKEY = ' ' * DYNPPROG = ' ' * DYNPNR = ' ' * DYNPROFIELD = ' ' * STEPL = 0 window_title = title * VALUE = ' ' * VALUE_ORG = 'C' * MULTIPLE_CHOICE = ' ' * DISPLAY = ' ' * CALLBACK_PROGRAM = ' ' * CALLBACK_FORM = ' ' * MARK_TAB = TABLES value_tab = t_tbcolumn field_tab = field_tab return_tab = return_tab * DYNPFLD_MAPPING = * EXCEPTIONS * PARAMETER_ERROR = 1 * NO_VALUES_FOUND = 2 * OTHERS = 3 .
POPUP_MESSAGE * CALL FUNCTION 'POPUP_MESSAGE' * EXPORTING * messagetext1 = 'One of the selected fields' * MESSAGETEXT2 = 'does not exist in the ' * MESSAGETEXT3 = 'selected table ' * titel = 'Selektionsfehler'.
STUO_GET_ORA_SYS_TABLE CALL FUNCTION 'STUO_GET_ORA_SYS_TABLE' DESTINATION rfcdest EXPORTING orasystabn = tab_name wclause = wclause IMPORTING curr_time = curr_time curr_date = curr_date curr_system = curr_system TABLES orasystab = orasystab orasystabhead = orasystabhead tab_sel = tab_sel EXCEPTIONS table_not_found = 1 report_generation_error = 2 statement_not_executable = 3 communication_failure = 11 MESSAGE msg_text system_failure = 12 MESSAGE msg_text OTHERS = 4.
STUO_GET_ORA_SYS_TABLE CALL FUNCTION 'STUO_GET_ORA_SYS_TABLE' DESTINATION rfcdest EXPORTING orasystabn = tab_name wclause = wclause IMPORTING curr_time = curr_time curr_date = curr_date curr_system = curr_system TABLES orasystab = orasystab orasystabhead = orasystabhead EXCEPTIONS table_not_found = 1 report_generation_error = 2 statement_not_executable = 3 communication_failure = 11 MESSAGE msg_text system_failure = 12 MESSAGE msg_text OTHERS = 4.
STUR_WRITE_TABLE CALL FUNCTION 'STUR_WRITE_TABLE' EXPORTING orasystabn = tab_name compress = 'X' menue_default = 'X' linesize = linesize curr_time = curr_time curr_date = curr_date curr_system = curr_system TABLES orasystab = orasystab orasystabhead = orasystabhead EXCEPTIONS OTHERS = 1.
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 RSORAVDV or its description.
RSORAVDV - V$-Tables (Oracle) RSORAVDV - V$-Tables (Oracle) RSORAVCR - Tables and Indexes: Submit ANALYZE TABLE/INDEX RSORAVCR - Tables and Indexes: Submit ANALYZE TABLE/INDEX RSORAV2N - ST04 (Oracle): Display sqlnet.ora, listener.ora, protocol.ora RSORAV2N - ST04 (Oracle): Display sqlnet.ora, listener.ora, protocol.ora