SAP Reports / Programs

comments icon Comments

RSORASSM SAP ABAP Report - Program RSORASSM







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


Text pool values


Title: Program RSORASSM


INCLUDES used within this REPORT RSORASSM

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_STATISTIC_NAMES
CALL FUNCTION 'GET_DB_ORA_STATISTIC_NAMES'
  TABLES
    liste = statistic_list.

GET_DB_ORA_SEGSTAT
  CALL FUNCTION 'GET_DB_ORA_SEGSTAT'
       EXPORTING
*           The TAB_NB isn't used in the case of SDBS
*            STATISTIC = statistic
            N_ROWS = 50
            PROCESS = curr_processing_type
            INST_ID =''
            TAB_NB = '1'
       IMPORTING
         RESET_TIME = reset_time
         RESET_DATE = reset_date
       TABLES
            SEGSTAT            = segstat
       EXCEPTIONS
            WRONG_DATABASE = 1
            WRONG_ORACLE_RELEASE = 2
            COLLECTOR_NOT_SET_IN_TCOLL = 3
            RESET_OLDER_THAN_STARTUP = 4.

GET_DB_ORA_INSTANCE_INFO
  CALL FUNCTION 'GET_DB_ORA_INSTANCE_INFO'
    EXPORTING
      INST     = 'L'
    TABLES
      inst_ora = inst_ora.

GET_DB_ORA_SEGSTAT
  CALL FUNCTION 'GET_DB_ORA_SEGSTAT'
       EXPORTING
*           The TAB_NB isn't used in the case of SDBS
*            STATISTIC = statistic
            N_ROWS = 50
            PROCESS = 'R'
            INST_ID =''
            TAB_NB = '1'
       TABLES
            SEGSTAT            = segstat
       EXCEPTIONS
            WRONG_DATABASE = 1
            WRONG_ORACLE_RELEASE = 2
            COLLECTOR_NOT_SET_IN_TCOLL = 3
            RESET_OLDER_THAN_STARTUP = 4.

POPUP_WITH_TABLE
      CALL FUNCTION 'POPUP_WITH_TABLE'
        EXPORTING
          ENDPOS_COL   = 70
          ENDPOS_ROW   = 21
          STARTPOS_COL = 6
          STARTPOS_ROW = 10
          TITLETEXT    = 'Statistic'                        "#EC NOTEXT
        IMPORTING
          CHOICE       = choice
        TABLES
          VALUETAB     = statistic_list
        EXCEPTIONS
          BREAK_OFF    = 1
          OTHERS       = 2.

GET_DB_ORA_SEGSTAT
      CALL FUNCTION 'GET_DB_ORA_SEGSTAT'
        EXPORTING
          PROCESS              = 'C'
          INST_ID
          =''
          TAB_NB               = tab_nb
        EXCEPTIONS
          WRONG_DATABASE       = 1
          WRONG_ORACLE_RELEASE = 2.

POPUP_WITH_TABLE
  CALL FUNCTION 'POPUP_WITH_TABLE'
    EXPORTING
      ENDPOS_COL   = 70
      ENDPOS_ROW   = 21
      STARTPOS_COL = 6
      STARTPOS_ROW = 10
      TITLETEXT    = 'Select schedule'                      "#EC NOTEXT
    IMPORTING
      CHOICE       = choice
    TABLES
      VALUETAB     = schedule_options
    EXCEPTIONS
      BREAK_OFF    = 1
      OTHERS       = 2.

GET_DB_ORA_SEGSTAT
    CALL FUNCTION 'GET_DB_ORA_SEGSTAT'
      EXPORTING
        PROCESS                    = 'R'
        INST_ID
        =''
        TAB_NB                     = '2'
      EXCEPTIONS
        WRONG_DATABASE             = 1
        WRONG_ORACLE_RELEASE       = 2
        COLLECTOR_NOT_SET_IN_TCOLL = 3
        RESET_OLDER_THAN_STARTUP   = 7.

GET_DB_ORA_SEGSTAT
    CALL FUNCTION 'GET_DB_ORA_SEGSTAT'
      EXPORTING
        PROCESS                    = 'R'
        INST_ID
        =''
        TAB_NB                     = '3'
      EXCEPTIONS
        WRONG_DATABASE             = 1
        WRONG_ORACLE_RELEASE       = 2
        COLLECTOR_NOT_SET_IN_TCOLL = 3
        RESET_OLDER_THAN_STARTUP   = 7.

GET_DB_RELEASE_ORA
  CALL FUNCTION 'GET_DB_RELEASE_ORA'
    IMPORTING
      ORA_RELEASE        = ora_rel
    EXCEPTIONS
      DB_RELEASE_UNKNOWN = 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 RSORASSM or its description.


   
 

RSORASSM - Program RSORASSM
RSORASSM - Program RSORASSM
RSORASSC - V$SEGSTAT monitor in collector mode
RSORASSC - V$SEGSTAT monitor in collector mode
RSORASQLCX2 - Report RSORASQLCX
RSORASQLCX2 - Report RSORASQLCX