SAP Reports / Programs | SAP Business Information Warehouse | Warehouse Management | Data Staging(BW-WHM-DST) SAP BW

comments icon Comments

RSAGGR1 SAP ABAP Report - Execute InfoCube aggregation







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


Text pool values


Title: Execute InfoCube aggregation
Text Symbol: 001 = Roll up run
Text Symbol: 002 = Rollup
Text Symbol: 003 = Data load


INCLUDES used within this REPORT RSAGGR1

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:

RSSM_RSMDATASTATE_MAINTAIN
call function 'RSSM_RSMDATASTATE_MAINTAIN'
  exporting
    i_infocube       = i_cube
    i_mode           = 'R'
    i_transport      = ' '
  importing
    e_type           = l_type
  changing
    c_s_rsmdatastate = rsmdatastate_s.

RSSM_SLEEP_DEBUG
call function 'RSSM_SLEEP_DEBUG'
*    EXPORTING
*         I_SECONDS = 20
          .

GET_JOB_RUNTIME_INFO
call function 'GET_JOB_RUNTIME_INFO'
  importing
    jobcount        = l_jobcount
    jobname         = l_jobname
  exceptions
    no_runtime_info = 1
    others          = 2.

RSSM_GET_JOBS
call function 'RSSM_GET_JOBS'
  exporting
    i_prefix      = l_prefix
  tables
    e_t_joblist   = l_t_joblist
  exceptions
    no_jobs_found = 1
    others        = 2.

ENQUEUE_ERSICENQ
  call function 'ENQUEUE_ERSICENQ'
    exceptions
      foreign_lock   = 1
      system_failure = 2
      others         = 3.

DEQUEUE_ERSICENQ
  call function 'DEQUEUE_ERSICENQ'
    exceptions
      others = 1.

RSSM_GET_TIME
call function 'RSSM_GET_TIME'
  importing
    e_timestamps = rsicaggr-timestamp
  exceptions
    others       = 1.

DB_COMMIT
call function 'DB_COMMIT'
  exceptions
    others = 1.

ENQUEUE_E_BIW_CUBE
  call function 'ENQUEUE_E_BIW_CUBE'
    exporting
      infocube       = rsicaggr-icube
    exceptions
      foreign_lock   = 1
      system_failure = 2
      others         = 3.

RSSM_GET_TIME
  call function 'RSSM_GET_TIME'
    importing
      e_timestamps = rsicaggr-timestamp
    exceptions
      others       = 1.

DEQUEUE_ERSICENQ
  call function 'DEQUEUE_ERSICENQ'
    exceptions
      others = 1.

RSSM_GET_TIME
    call function 'RSSM_GET_TIME'
      importing
        e_timestamps = rs2ndprocprot-timestamp.

RRSI_SID_VAL_SINGLE_CONVERT
    call function 'RRSI_SID_VAL_SINGLE_CONVERT'
      exporting
        i_iobjnm = rsd_c_dpanm-requid
        i_sid    = rsicaggr-lastpart
      importing
        e_chavl  = rs2ndprocprot-rnr
      exceptions
        others   = 1.

DB_COMMIT
    call function 'DB_COMMIT'.

RSSM_EVENT_RAISE
    call function 'RSSM_EVENT_RAISE'
      exporting
        i_eventid   = rsicsettings-event_id_roll_er
        i_eventparm = rsicsettings-event_pm_roll_er.

DEQUEUE_ERSICENQ
call function 'DEQUEUE_ERSICENQ'
  exceptions
    others = 1.

ENQUEUE_ERSENQUEUE
*  call function 'ENQUEUE_ERSENQUEUE'
*    exporting
*      mode_rsenq_prot_enq = 'S'
*      action              = '/PROC_NEW_REQ/'
*      object              = '/PROC_NEW_REQ/'
*      _scope              = '3'
*      _wait               = 'X'
*    exceptions
*      foreign_lock        = 1.

RSSM_SLEEP_DEBUG
*  call function 'RSSM_SLEEP_DEBUG'
*    exporting
*      i_seconds = 1
*      i_always  = 'X'.

ENQUEUE_ERSENQUEUE
















*  call function 'ENQUEUE_ERSENQUEUE'
*    exporting
*      mode_rsenq_prot_enq = 'E'
*      action              = '/GET_NEW_REQ/'
*      object              = '/GET_NEW_REQ/'
*      _scope              = '3'
*      _wait               = 'X'
*    exceptions
*      foreign_lock        = 1.

DEQUEUE_ERSENQUEUE
*    call function 'DEQUEUE_ERSENQUEUE'
*      exporting
*        mode_rsenq_prot_enq = 'S'
*        action              = '/PROC_NEW_REQ/'
*        object              = '/PROC_NEW_REQ/'
*        _scope              = '3'
*        _synchron           = 'X'.

RSSM_SLEEP_DEBUG
*  call function 'RSSM_SLEEP_DEBUG'
*    exporting
*      i_seconds = 1
*      i_always  = 'X'.

ENQUEUE_ERSENQUEUE
*  call function 'ENQUEUE_ERSENQUEUE'
*    exporting
*      mode_rsenq_prot_enq = 'E'
*      action              = '/PROC_NEW_REQ/'
*      object              = rsicaggr-icube
*      _scope              = '3'
*      _wait               = 'X'
*    exceptions
*      foreign_lock        = 1.

RSSM_SLEEP_DEBUG
*  call function 'RSSM_SLEEP_DEBUG'
*    exporting
*      i_seconds = 1
*      i_always  = 'X'.

RSBATCH_INFORM_MANAGER
call function 'RSBATCH_INFORM_MANAGER'
  exporting
    i_process_type = 'ROLLUP'
    i_status       = icon_yellow_light
    i_t_info       = l_t_info
  importing
    e_batch_id     = l_batch_id.

DB_COMMIT
    call function 'DB_COMMIT'.

RSSM_RSMDATASTATE_MAINTAIN
  call function 'RSSM_RSMDATASTATE_MAINTAIN'
    exporting
      i_infocube       = rsicaggr-icube
    changing
      c_s_rsmdatastate = rsmdatastate_s
    exceptions
      error            = 1
      others           = 2.

RSSM_RSMDATASTATE_MAINTAIN
call function 'RSSM_RSMDATASTATE_MAINTAIN'
  exporting
    i_infocube       = rsicaggr-icube
  changing
    c_s_rsmdatastate = rsmdatastate_s.

RSBATCH_INFORM_MANAGER
call function 'RSBATCH_INFORM_MANAGER'
  exporting
    i_status   = icon_yellow_light
    i_t_info   = l_t_info
    i_batch_id = l_batch_id.

DEQUEUE_ERSENQUEUE
*call function 'DEQUEUE_ERSENQUEUE'
*  exporting
*    mode_rsenq_prot_enq = 'E'
*    action              = '/PROC_NEW_REQ/'
*    object              = rsicaggr-icube
*    _scope              = '3'
*    _synchron           = 'X'.

DEQUEUE_ERSENQUEUE
*call function 'DEQUEUE_ERSENQUEUE'
*  exporting
*    mode_rsenq_prot_enq = 'E'
*    action              = '/GET_NEW_REQ/'
*    object              = '/GET_NEW_REQ/'
*    _scope              = '3'
*    _synchron           = 'X'.

RSSM_PROCESS_ROLLUP
call function 'RSSM_PROCESS_ROLLUP'
  exporting
    i_cube            = rsicaggr-icube
    i_jobname         = l_jobname
    i_calcflag        = l_calcflag
    i_s_sele          = l_s_sele
    i_lastpart        = l_lastpart
    i_parent_batch_id = l_batch_id
  importing
    e_t_msg           = l_t_msg
    e_error           = l_error
    e_lastpart        = l_lastpart
    e_firstpart       = rsicaggr-firstpart.

RSBATCH_INFORM_MANAGER
  call function 'RSBATCH_INFORM_MANAGER'
    exporting
      i_status   = icon_green_light
      i_batch_id = l_batch_id.

RSSM_GET_TIME
  call function 'RSSM_GET_TIME'
    importing
      e_timestamps = rsicaggr-timestamp
    exceptions
      others       = 1.

DB_COMMIT
  call function 'DB_COMMIT'.

RSSM_GET_TIME
    call function 'RSSM_GET_TIME'
      importing
        e_timestamps = rs2ndprocprot-timestamp.

RRSI_SID_VAL_SINGLE_CONVERT
    call function 'RRSI_SID_VAL_SINGLE_CONVERT'
      exporting
        i_iobjnm = rsd_c_dpanm-requid
        i_sid    = rsicaggr-lastpart
      importing
        e_chavl  = rs2ndprocprot-rnr
      exceptions
        others   = 1.

DB_COMMIT
    call function 'DB_COMMIT'.

RSSM_EVENT_RAISE
    call function 'RSSM_EVENT_RAISE'
      exporting
        i_eventid   = rsicsettings-event_id_roll_ok
        i_eventparm = rsicsettings-event_pm_roll_ok.




RSSM_UPDATE_RSMDATASTATE
  call function 'RSSM_UPDATE_RSMDATASTATE'
    exporting
      i_icube    = rsicaggr-icube
    importing
      e_t_compic = l_t_compic
    exceptions
      others     = 1.

DB_COMMIT
  call function 'DB_COMMIT'
    exceptions
      others = 1.

DB_COMMIT
  call function 'DB_COMMIT'
    exceptions
      others = 1.

RSBATCH_INFORM_MANAGER
  call function 'RSBATCH_INFORM_MANAGER'
    exporting
      i_status   = icon_red_light
      i_batch_id = l_batch_id.

RSSM_GET_TIME
  call function 'RSSM_GET_TIME'
    importing
      e_timestamps = rsicaggr-timestamp
    exceptions
      others       = 1.

DB_COMMIT
  call function 'DB_COMMIT'.

RSSM_GET_TIME
    call function 'RSSM_GET_TIME'
      importing
        e_timestamps = rs2ndprocprot-timestamp.

RRSI_SID_VAL_SINGLE_CONVERT
    call function 'RRSI_SID_VAL_SINGLE_CONVERT'
      exporting
        i_iobjnm = rsd_c_dpanm-requid
        i_sid    = rsicaggr-lastpart
      importing
        e_chavl  = rs2ndprocprot-rnr
      exceptions
        others   = 1.

DB_COMMIT
    call function 'DB_COMMIT'.

RSSM_EVENT_RAISE
    call function 'RSSM_EVENT_RAISE'
      exporting
        i_eventid   = rsicsettings-event_id_roll_er
        i_eventparm = rsicsettings-event_pm_roll_er.

RSDDK_AGGR_EXIST_CHECK
*call function 'RSDDK_AGGR_EXIST_CHECK'
*  exporting
*    i_t_aggr        = l_t_aggr
*  importing
*    e_t_aggr_filled = l_t_aggr_active
*  exceptions
*    others          = 1.

RSSM_CHECK_ICUBE_LOAD_RUNNING
*  call function 'RSSM_CHECK_ICUBE_LOAD_RUNNING'
*    tables
*      e_t_detail = l_t_details.

RSDDK_AGGREGATES_ROLLUP
*    call function 'RSDDK_AGGREGATES_ROLLUP'
*      exporting
*        i_infocube           = rsicaggr-icube
*        i_rollup_to          = rsicaggr-lastpart
*      importing
*        e_t_msg              = l_t_msg
*      exceptions
*        data_error           = 1
*        aggr_mod_in_progress = 2
*        rollup_to_small      = 3
*        others               = 4.

RSSM_GET_TIME
*    call function 'RSSM_GET_TIME'
*      importing
*        e_timestamps = rsicaggr-timestamp
*      exceptions
*        others       = 1.

DB_COMMIT
*    call function 'DB_COMMIT'
*      exceptions
*        others = 1.

RSSM_GET_TIME
*      call function 'RSSM_GET_TIME'
*        importing
*          e_timestamps = rs2ndprocprot-timestamp.

RRSI_SID_VAL_SINGLE_CONVERT
*      call function 'RRSI_SID_VAL_SINGLE_CONVERT'
*        exporting
*          i_iobjnm = rsd_c_dpanm-requid
*          i_sid    = rsicaggr-lastpart
*        importing
*          e_chavl  = rs2ndprocprot-rnr
*        exceptions
*          others   = 1.

DB_COMMIT
*      call function 'DB_COMMIT'.

RSSM_EVENT_RAISE
*      call function 'RSSM_EVENT_RAISE'
*        exporting
*          i_eventid   = rsicsettings-event_id_roll_ok
*          i_eventparm = rsicsettings-event_pm_roll_ok.

RSSM_UPDATE_RSMDATASTATE
*    call function 'RSSM_UPDATE_RSMDATASTATE'
*      exporting
*        i_icube    = rsicaggr-icube
*      importing
*        e_t_compic = l_t_compic
*      exceptions
*        others     = 1.

DB_COMMIT
*    call function 'DB_COMMIT'
*      exceptions
*        others = 1.

DB_COMMIT
*    call function 'DB_COMMIT'
*      exceptions
*        others = 1.

RSSM_GET_TIME
*    call function 'RSSM_GET_TIME'
*      importing
*        e_timestamps = rsicaggr-timestamp
*      exceptions
*        others       = 1.

DB_COMMIT
*    call function 'DB_COMMIT'
*      exceptions
*        others = 1.

RSSM_GET_TIME
*      call function 'RSSM_GET_TIME'
*        importing
*          e_timestamps = rs2ndprocprot-timestamp.

RRSI_SID_VAL_SINGLE_CONVERT
*      call function 'RRSI_SID_VAL_SINGLE_CONVERT'
*        exporting
*          i_iobjnm = rsd_c_dpanm-requid
*          i_sid    = rsicaggr-lastpart
*        importing
*          e_chavl  = rs2ndprocprot-rnr
*        exceptions
*          others   = 1.

DB_COMMIT
*      call function 'DB_COMMIT'.

RSSM_EVENT_RAISE
*      call function 'RSSM_EVENT_RAISE'
*        exporting
*          i_eventid   = rsicsettings-event_id_roll_er
*          i_eventparm = rsicsettings-event_pm_roll_er.

RSSM_GET_TIME
*  call function 'RSSM_GET_TIME'
*    importing
*      e_timestamps = rsicaggr-timestamp
*    exceptions
*      others       = 1.

DB_COMMIT
*  call function 'DB_COMMIT'
*    exceptions
*      others = 1.

RSSM_GET_TIME
*      call function 'RSSM_GET_TIME'
*        importing
*          e_timestamps = rs2ndprocprot-timestamp.

RRSI_SID_VAL_SINGLE_CONVERT
*      call function 'RRSI_SID_VAL_SINGLE_CONVERT'
*        exporting
*          i_iobjnm = rsd_c_dpanm-requid
*          i_sid    = rsicaggr-lastpart
*        importing
*          e_chavl  = rs2ndprocprot-rnr
*        exceptions
*          others   = 1.

DB_COMMIT
*      call function 'DB_COMMIT'.

RSSM_EVENT_RAISE
*      call function 'RSSM_EVENT_RAISE'
*        exporting
*          i_eventid   = rsicsettings-event_id_roll_er
*          i_eventparm = rsicsettings-event_pm_roll_er.

RSSM_GET_TIME
*      call function 'RSSM_GET_TIME'
*        importing
*          e_timestamps = rs2ndprocprot-timestamp.

RRSI_SID_VAL_SINGLE_CONVERT
*      call function 'RRSI_SID_VAL_SINGLE_CONVERT'
*        exporting
*          i_iobjnm = rsd_c_dpanm-requid
*          i_sid    = l_lastpart
*        importing
*          e_chavl  = rs2ndprocprot-rnr
*        exceptions
*          others   = 1.

DB_COMMIT
*      call function 'DB_COMMIT'.

RSSM_EVENT_RAISE
*      call function 'RSSM_EVENT_RAISE'
*        exporting
*          i_eventid   = rsicsettings-event_id_roll_er
*          i_eventparm = rsicsettings-event_pm_roll_er.

RSSM_GET_TIME
*      call function 'RSSM_GET_TIME'
*        importing
*          e_timestamps = rs2ndprocprot-timestamp.

RRSI_SID_VAL_SINGLE_CONVERT
*      call function 'RRSI_SID_VAL_SINGLE_CONVERT'
*        exporting
*          i_iobjnm = rsd_c_dpanm-requid
*          i_sid    = rsicaggr-lastpart
*        importing
*          e_chavl  = rs2ndprocprot-rnr
*        exceptions
*          others   = 1.

DB_COMMIT
*      call function 'DB_COMMIT'.

RSSM_EVENT_RAISE
*      call function 'RSSM_EVENT_RAISE'
*        exporting
*          i_eventid   = rsicsettings-event_id_roll_ok
*          i_eventparm = rsicsettings-event_pm_roll_ok.

DEQUEUE_E_BIW_CUBE
call function 'DEQUEUE_E_BIW_CUBE'
  exporting
    infocube = rsicaggr-icube
  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 RSAGGR1 or its description.


   
 

RSAGGR1 - Execute InfoCube aggregation
RSAGGR1 - Execute InfoCube aggregation
RSAFT_PT_XML - Report RSAFT_PT_XML
RSAFT_PT_XML - Report RSAFT_PT_XML
RSAFPROT - Log Functions for Program Hex-0-Check (RSAFCHK)
RSAFPROT - Log Functions for Program Hex-0-Check (RSAFCHK)