SAP Reports / Programs

comments icon Comments

RSORAISQN SAP ABAP Report - Index Storage Quality Analysis







RSORAISQN is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report performs mass storage analysis and defragmentations of nonpartitioned B*TREE indexes on the local or a remote database...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 RSORAISQN 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 RSORAISQN. "Basic submit
SUBMIT RSORAISQN AND RETURN. "Return to original report after report execution complete
SUBMIT RSORAISQN 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: PACT_STP = Stop Workingset
Selection Text: PAOP_EXA = Exact
Selection Text: PAOP_FST = Fast
Selection Text: PAOP_PAR = Parallel degree
Selection Text: PCOP_DAY = Days to keep
Selection Text: PDEST = Connection Name
Selection Text: PDOP_CHK = Check Locks
Selection Text: PDOP_COA = Coalesce
Selection Text: PDOP_PAR = Parallel degree
Selection Text: PDOP_REB = Rebuild online
Selection Text: PDOP_STA = Compute Statistics (Oracle 9)
Selection Text: PDOP_TSC = Coalesce Tablespace
Selection Text: PID = ID
Selection Text: PINDEX = Index
Selection Text: PMAXQUAL = and
Selection Text: PMAXSIZE = and
Selection Text: PMINQUAL = Storage Quality (%) between
Selection Text: PMINSIZE = Index size (kb) between
Selection Text: PSOP_OLA = Only last Action of each Type
Selection Text: PTABLE = Table
Selection Text: PTSP = Tablespace
Selection Text: PWSENDDT = and
Selection Text: PWSENDTM =
Selection Text: PWSSTRDT = Workingset Start between
Selection Text: PWSSTRTM =
Selection Text: PACT_STA = Start Workingset
Selection Text: PACT_RES = Restart Workingset
Selection Text: PACT_FSS = Set Stop Status for Workingset
Selection Text: PACT_DIW = Show Status of Workingsets
Selection Text: PACT_DIH = Show History
Selection Text: PACT_DEF = Defragment
Selection Text: PACT_CLW = Cleanup Workingset
Selection Text: PACT_CLH = Cleanup History
Selection Text: PACT_ANA = Analyze
Selection Text: PACT_ADD = Increase Workingsetparallelity
Title: Index Storage Quality Analysis
Text Symbol: 001 = Object Selection
Text Symbol: 002 = Action Selection





Text Symbol: 003 = Workingset Selection
Text Symbol: 004 = ATTENTION - ATTENTION - ATTENTION
Text Symbol: 005 = This is an emergency function that should only be used after
Text Symbol: 006 = abnormal termination of workingset processing like:
Text Symbol: 007 = - shutdown of the local or remote database
Text Symbol: 008 = - dump of one of the processes working on the workingset
Text Symbol: 009 = Before pressing 'Continue' be sure that NOT ANY process is
Text Symbol: 010 = working on this workingset anymore, otherwise press 'Cancel'
Text Symbol: 011 = Cancel
Text Symbol: 012 = Continue, I am sure
Text Symbol: 013 = Are you sure?
Text Symbol: 014 = OK
Text Symbol: 015 = Cancel


INCLUDES used within this REPORT RSORAISQN

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
      retfield     = 'ID'
      window_title = 'WORKINGSET SELECTION'
    TABLES
      value_tab    = tselection
      field_tab    = tfields
      return_tab   = treturn.

TH_GET_OWN_WP_NO
  CALL FUNCTION 'TH_GET_OWN_WP_NO'
    IMPORTING
      WP_PID = vpid.

POPUP_TO_CONFIRM
    CALL FUNCTION 'POPUP_TO_CONFIRM'
      EXPORTING
        text_question         = text-013
        TEXT_BUTTON_1         = text-014
        ICON_BUTTON_1         = 'ICON_OK'
        TEXT_BUTTON_2         = text-015
        ICON_BUTTON_2         = 'ICON_CANCEL'
        DEFAULT_BUTTON        = '2'
        DISPLAY_CANCEL_BUTTON = ' '
      IMPORTING
        ANSWER                = vanswer
      EXCEPTIONS                                            "#EC FB_RC
        TEXT_NOT_FOUND        = 1
        OTHERS                = 2.

POPUP_TO_CONFIRM
        CALL FUNCTION 'POPUP_TO_CONFIRM'
          EXPORTING
            TITLEBAR              = 'ATTENTION - ATTENTION'
            TEXT_QUESTION         = vquestion
            TEXT_BUTTON_1         = 'Cancel' ##NO_TEXT
            ICON_BUTTON_1         = 'ICON_CANCEL'
            TEXT_BUTTON_2         = 'Enforce Stop!' ##NO_TEXT
            ICON_BUTTON_2         = 'ICON_BREAKPOINT'
            DEFAULT_BUTTON        = '1'
            DISPLAY_CANCEL_BUTTON = ' '
            POPUP_TYPE            = 'ICON_MESSAGE_CRITICAL'
          IMPORTING
            ANSWER                = vanswer
          EXCEPTIONS
            TEXT_NOT_FOUND        = 1
            OTHERS                = 2.

REUSE_ALV_GRID_DISPLAY
  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
    EXPORTING
      is_layout                = gs_layout
      it_sort                  = gt_header_sort
      it_fieldcat              = gt_header_fc
      I_CALLBACK_PROGRAM       = gv_repid
      I_CALLBACK_TOP_OF_PAGE   = 'HEADER_LIST_HEADER'
      I_CALLBACK_PF_STATUS_SET = 'HEADER_PF_STATUS'
      I_CALLBACK_USER_COMMAND  = 'HEADER_COMMAND'
    TABLES
      t_outtab                 = gt_header.

REUSE_ALV_COMMENTARY_WRITE
  CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
    EXPORTING
      it_list_commentary = gt_listheader.

REUSE_ALV_GRID_DISPLAY
            CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
              EXPORTING
                is_layout                = gs_layout
                it_sort                  = gt_history_sort
                it_fieldcat              = gt_history_fc
                I_CALLBACK_PROGRAM       = gv_repid
                I_CALLBACK_TOP_OF_PAGE   = 'HISTORY_LIST_HEADER'
                I_CALLBACK_PF_STATUS_SET = 'HISTORY_PF_STATUS'
                I_CALLBACK_USER_COMMAND  = 'HISTORY_COMMAND'
              TABLES
                t_outtab                 = gt_history.

REUSE_ALV_GRID_DISPLAY
        CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
          EXPORTING
            is_layout                = gs_layout
            it_sort                  = gt_detail_sort
            it_fieldcat              = gt_detail_fc
            I_CALLBACK_PROGRAM       = gv_repid
            I_CALLBACK_TOP_OF_PAGE   = 'DETAIL_LIST_HEADER'
            I_CALLBACK_PF_STATUS_SET = 'DETAIL_PF_STATUS'
            I_CALLBACK_USER_COMMAND  = 'DETAIL_COMMAND'
          TABLES
            t_outtab                 = gt_detail.

REUSE_ALV_COMMENTARY_WRITE
  CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
    EXPORTING
      it_list_commentary = gt_listheader.

REUSE_ALV_GRID_DISPLAY
  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
    EXPORTING
      is_layout                = gs_layout
      it_sort                  = gt_history_sort
      it_fieldcat              = gt_history_fc
      I_CALLBACK_PROGRAM       = gv_repid
      I_CALLBACK_TOP_OF_PAGE   = 'HISTORY_LIST_HEADER'
      I_CALLBACK_PF_STATUS_SET = 'HISTORY_PF_STATUS'
      I_CALLBACK_USER_COMMAND  = 'HISTORY_COMMAND'
    TABLES
      t_outtab                 = gt_history.

REUSE_ALV_COMMENTARY_WRITE
  CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
    EXPORTING
      it_list_commentary = gt_listheader.

SAPGUI_PROGRESS_INDICATOR
















  CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'
    EXPORTING
      PERCENTAGE = vprogress_percent
      TEXT       = vprogress_text.


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


   
 

RSORAISQN - Index Storage Quality Analysis
RSORAISQN - Index Storage Quality Analysis
RSORAI90 - Database-dependent data definitions
RSORAI81 - Mmodules for DB-dependent screens
RSORAI80 - Write one line of protocol information
RSORAI77 - Database-dependent forms (only called in DB-dependent parts)