SAP Reports / Programs

RSORAMDB SAP ABAP Report - Test Program for Creating a Second Database Connection







RSORAMDB 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 RSORAMDB 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 RSORAMDB. "Basic submit
SUBMIT RSORAMDB AND RETURN. "Return to original report after report execution complete
SUBMIT RSORAMDB VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Test Program for Creating a Second Database Connection


INCLUDES used within this REPORT RSORAMDB

INCLUDE RSTRCI01.
INCLUDE RSORAT0T.


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:

DB_ORA_GET_RELEASE * CALL FUNCTION 'DB_ORA_GET_RELEASE' * IMPORTING * ora_release = ora_release.

DB_ORA_MAIN_LIST CALL FUNCTION 'DB_ORA_MAIN_LIST' EXPORTING ora_release = ora_rel IMPORTING dbora = tst04.

GET_DB_ORA_RELEASE CALL FUNCTION 'GET_DB_ORA_RELEASE' IMPORTING oracle_release = ora_rel.

DB_ORA_MAIN_LIST CALL FUNCTION 'DB_ORA_MAIN_LIST' EXPORTING ora_release = ora_rel IMPORTING dbora = tst04.

DB_ORA_GET_RELEASE * CALL FUNCTION 'DB_ORA_GET_RELEASE' * IMPORTING * ora_release = ora_release.

DB_ORA_MAIN_LIST * CALL FUNCTION 'DB_ORA_MAIN_LIST' * EXPORTING * ora_release = ora_release * IMPORTING * dbora = tst04 .

ORA_SQL_SESSION_CONTROL * call function 'ORA_SQL_SESSION_CONTROL' .

ORA_SQL_SESSION_CONTROL CALL FUNCTION 'ORA_SQL_SESSION_CONTROL' EXPORTING SKIP_SELC = 'X'.

DB_ORA_READ_FILE CALL FUNCTION 'DB_ORA_READ_FILE' EXPORTING directory = path filename = filename IMPORTING file_tab = filetab EXCEPTIONS open_file_failed = 1 read_line_failed = 2 sql_error = 3 OTHERS = 4.

GET_DB_ORA_RELEASE CALL FUNCTION 'GET_DB_ORA_RELEASE' IMPORTING oracle_release = ora_rel.

DB_ORA_MAIN_LIST CALL FUNCTION 'DB_ORA_MAIN_LIST' EXPORTING ora_release = ora_rel IMPORTING dbora = tst04.

STUO_GET_ORA_SYS_TABLE_2 CALL FUNCTION 'STUO_GET_ORA_SYS_TABLE_2' * 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_2 CALL FUNCTION 'STUO_GET_ORA_SYS_TABLE_2' * 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.

DB_ORA_FILESYSTEM_REQUESTS CALL FUNCTION 'DB_ORA_FILESYSTEM_REQUESTS' EXPORTING ora_release = ora_rel * read_filenames = 'Y' * calculate_avg_times = 'Y' TABLES flsrequests = p_flsrequests oraiopath = oraiopath oraiosum = oraiosum.

ORA_SQL_REQUEST_CONTROL CALL FUNCTION 'ORA_SQL_REQUEST_CONTROL' EXPORTING fieldcat_gen = 'X' sortfield = 'DISK_READS' CHANGING abap_rest = abap_rest EXCEPTIONS alv_hlp_error = 1 OTHERS = 2.

ORA_GET_DB_OS CALL FUNCTION 'ORA_GET_DB_OS' IMPORTING db_operatingsystem = p_dbos.

TH_GET_OWN_WP_NO * CALL FUNCTION 'TH_GET_OWN_WP_NO' * IMPORTING ** SUBRC = * wp_no = wp_no * wp_pid = wp_pid ** WP_INDEX = * .

STUO_GET_WAIT_EVENTS





CALL FUNCTION 'STUO_GET_WAIT_EVENTS' EXPORTING analysis = 'S' TABLES session_tab = sessions event_tab = events EXCEPTIONS wrong_database = 1 OTHERS = 2.

DB_ORA_INSTANCE_INFO CALL FUNCTION 'DB_ORA_INSTANCE_INFO' IMPORTING local_dbinstance = dbinstance EXCEPTIONS wrong_database = 1 instance_information_not_found = 2 OTHERS = 3.



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 RSORAMDB or its description.