SAP Reports / Programs | Basis Components | Use Subcomponents | Performance Monitors (TCC)(BC-CCM-MON-TUN) SAP BC

comments icon Comments

RSORAT1I SAP ABAP INCLUDE - DB02 (Oracle): PAI Module RSORA060 (Include)







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


Text pool values


Title: DB02 (Oracle): PAI Module RSORA060 (Include)


INCLUDES used within this REPORT RSORAT1I

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:

CREATE_MISSING_INDEXES
*         CALL FUNCTION 'CREATE_MISSING_INDEXES'
*              EXPORTING
*                        CREATE_TYPE       = SY-UCOMM
*                        MISSINDEX         = MISS_INDEX-NAME
*              EXCEPTIONS
*                        CREATE_FAILED     = 1
*                        INDEX_NOT_ALLOWED = 2
*                        OTHERS            = 3.

CREATE_MISSING_INDEXES
*         CALL FUNCTION 'CREATE_MISSING_INDEXES'
*              EXPORTING
*                        CREATE_TYPE       = SY-UCOMM
*              TABLES    MISS_INDEX        = MISS_INDEX
*              EXCEPTIONS
*                        NO_INDEX_INSERTED = 1
*                        OTHERS            = 2.

DD_DB_CONSISTENCY_CHECK
      CALL FUNCTION 'DD_DB_CONSISTENCY_CHECK'
        EXPORTING
          missing_ind_disp = 'X'
        EXCEPTIONS
          OTHERS           = 1.

CHECK_DB_SAP_CONSISTENCY
      CALL FUNCTION 'CHECK_DB_SAP_CONSISTENCY'
        EXPORTING
          conscheck = 'DB'.

CHECK_DB_SAP_CONSISTENCY
      CALL FUNCTION 'CHECK_DB_SAP_CONSISTENCY'
        EXPORTING
          conscheck = 'SAP'.

POPUP_TO_CONFIRM_STEP
      CALL FUNCTION 'POPUP_TO_CONFIRM_STEP'               "#EC FB_OLDED
        EXPORTING
          titel     = 'Perform analysis'
          textline1 = 'Perform analysis of extent'
          textline2 = 'structure for all tablespaces?'
        IMPORTING
          answer    = answer.                             "#EC FB_OLDED

POPUP_TO_CONFIRM_STEP
    CALL FUNCTION 'POPUP_TO_CONFIRM_STEP'
      EXPORTING
        titel     = 'Refresh database statistics'
        textline1 = 'Starting Report rsorAT0D'
        textline2 = 'Operation may take a few minutes!'
      IMPORTING
        answer    = answer.

POPUP_TO_CONFIRM_STEP
    CALL FUNCTION 'POPUP_TO_CONFIRM_STEP'
      EXPORTING
        titel     = 'Refresh database statistics'
        textline1 = 'Starting Report rsdb_tdb'
        textline2 = 'Operation may take a few minutes!'
      IMPORTING
        answer    = answer.

STUO_GET_ORA_SYS_TABLE
  CALL FUNCTION 'STUO_GET_ORA_SYS_TABLE'
*    DESTINATION rfcdest
    EXPORTING
      orasystabn               = 'DBA_DATA_FILES'
    TABLES
      orasystab                = orasystab_data
      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.

STUO_GET_ORA_SYS_TABLE
  CALL FUNCTION 'STUO_GET_ORA_SYS_TABLE'
*    DESTINATION rfcdest
    EXPORTING
      orasystabn               = 'DBA_TEMP_FILES'
    TABLES
      orasystab                = orasystab_temp
      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    = 'DATA FILES / TEMP FILES'
      compress      = 'X'
      menue_default = 'X'
      linesize      = 250
    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 RSORAT1I or its description.


   
 

RSORAT1I - DB02 (Oracle): PAI Module RSORA060 (Include)
RSORAT1F - to be deleted T.S. 1/97
RSORAT0T - DB02 (Oracle): Global data definitons (include)
RSORAT0O - to be deleted T.S. 1/97
RSORAT0M - prepares minikey
RSORAT0G - Globale Daten für den Report: Detailed Table Analyse