RSORA00E SAP ABAP Report - DB-ORA-Monitor: New Entry Design

RSORA00E is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Entry view of oracle database monitor...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 RSORA00E 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.

Text pool values

INCLUDES used within this REPORT RSORA00E

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:

GET_DB_ORA_RELEASE
  CALL FUNCTION 'GET_DB_ORA_RELEASE'
    IMPORTING
      oracle_release = g_ora_rel.

REUSE_ALV_FIELDCATALOG_MERGE
  CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
    EXPORTING
      i_program_name         = l_repid
      i_internal_tabname     = 'GT_STAT'
      i_structure_name       = 'ST04N_DATA'
    CHANGING
      ct_fieldcat            = lt_fieldcat
    EXCEPTIONS
      inconsistent_interface = 1
      program_error          = 2
      OTHERS                 = 3.

REUSE_ALV_GRID_DISPLAY
  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
    EXPORTING
      i_grid_title          = l_alv_title
      is_layout             = ls_layout
      it_fieldcat           = lt_fieldcat
      i_screen_start_column = 30
      i_screen_start_line   = 6
      i_screen_end_column   = 80
      i_screen_end_line     = 20
    TABLES
      t_outtab              = gt_stat.

K_KKB_FIELDCAT_MERGE
  CALL FUNCTION 'K_KKB_FIELDCAT_MERGE'
    EXPORTING
      i_callback_program = l_repid
      i_strucname        = 'ST04N_DATA'
    CHANGING
      ct_fieldcat        = lt_fcat.

K_KKB_LIST_DISPLAY
  CALL FUNCTION 'K_KKB_LIST_DISPLAY'
    EXPORTING
      i_callback_program                   = l_repid
      i_export                             = 'X'
      i_tabname                            = 'GT_STAT'
      is_layout                            = ls_layout
      it_fieldcat                          = lt_fcat
*     i_fctype                             = 'R'
    TABLES
      t_outtab                             = gt_stat.

ALV_DOWNLOAD
* alternative, but ugly download results: CALL FUNCTION 'ALV_DOWNLOAD'
ENDFORM.                    "download_mainmoni_data

POPUP_TO_CONFIRM
  CALL FUNCTION 'POPUP_TO_CONFIRM'
    EXPORTING
      titlebar                    = text-300
*     diagnose_object             = ' '
      text_question               = text-301
      text_button_1               = text-302
      icon_button_1               = 'ICON_EXECUTE_OBJECT'
      text_button_2               = text-303
      icon_button_2               = 'ICON_BACKGROUND_JOB'
*     'ICON_BOOKING_OK' / 'ICON_STATUS_BOOKED' / ICON_TASK
*     default_button              = '1'
      display_cancel_button       = 'X'
*     userdefined_f1_help         = ' '
*     start_column                = 25
*     start_row                   = 6
*     popup_type                  =
    IMPORTING
      answer                      = l_popup_answer.

SAPGUI_PROGRESS_INDICATOR
      CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'
        EXPORTING
          percentage = 1
          text       = text-304.

ORA_CREATE_SNAPSHOT
      CALL FUNCTION 'ORA_CREATE_SNAPSHOT'
        EXPORTING
          i_snapshot_type = '2'     " Manual snapshot
          i_save_errlog   = 'X'.    " save error log physically

ORA_CREATE_SNAPSHOT
*     old logic - problem: timeout: CALL FUNCTION 'ORA_CREATE_SNAPSHOT'
*     .. STARTING NEW TASK 'SNAP' / IN BACKGROUND TASK AS SEPARATE UNIT

JOB_OPEN
      CALL FUNCTION 'JOB_OPEN'
        EXPORTING
          jobname          = l_jobname
        IMPORTING
          jobcount         = l_jobnr
        EXCEPTIONS
          cant_create_job  = 1
          invalid_job_data = 2
          jobname_missing  = 3
          OTHERS           = 4.

JOB_CLOSE
      CALL FUNCTION 'JOB_CLOSE'
        EXPORTING
          jobcount             = l_jobnr
          jobname              = l_jobname
          strtimmed            = 'X'
        EXCEPTIONS
          cant_start_immediate = 1
          invalid_startdate    = 2
          jobname_missing      = 3
          job_close_failed     = 4
          job_nosteps          = 5
          job_notex            = 6
          lock_failed          = 7
          invalid_target       = 8
          OTHERS               = 9.