ORA_COLL_SE_AGG_PART_LIST SAP Function module - Oracle monitoring: update table ora_mon_roots

ORA_COLL_SE_AGG_PART_LIST is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.

See here to view full function module documentation and code listing, simply by entering the name ORA_COLL_SE_AGG_PART_LIST into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: SDBORA3
Released Date: Not Released
Processing type: Normal fucntion module

Pattern for FM ORA_COLL_SE_AGG_PART_LIST - ORA COLL SE AGG PART LIST

CALL FUNCTION 'ORA_COLL_SE_AGG_PART_LIST' "Oracle monitoring: update table ora_mon_roots
  EXPORTING
    con_name =                  " dbcon_name    Oracle monitoring: connection name
    monikey =                   " monikey       Oracle monitoring: monikey
    process_type =              " db02_proc_typ  Oracle monitoring: process type
*   s_monikey_1 =               " monikey       Oracle monitoring: monikey
*   s_monikey_2 =               " monikey       Oracle monitoring: monikey
*   s_monikey_3 =               " monikey       Oracle monitoring: monikey
*   s_monikey_4 =               " monikey       Oracle monitoring: monikey
*   s_monikey_5 =               " monikey       Oracle monitoring: monikey
*   s_monikey_6 =               " monikey       Oracle monitoring: monikey
*   s_monikey_7 =               " monikey       Oracle monitoring: monikey
*   s_monikey_8 =               " monikey       Oracle monitoring: monikey
*   s_monikey_9 =               " monikey       Oracle monitoring: monikey
*   s_monikey_10 =              " monikey       Oracle monitoring: monikey
*   param =                     " db02_param    Oracle monitoring: parameter
*   refresh =                   " db02_flag     Oracle monitoring: flag
  IMPORTING
    date =                      " db02_date     Oracle monitoring
    time =                      " db02_time     Oracle monitoring: time
    wday =                      " db02_wday     Oracle monitoring: Week day
    cweek =                     " db02_cweek    Oracle monitoring: calendar week
    upload =                    " db02_upload   Oracle monitoring: bytes uploaded in Moni
    duration =                  " db02_duration  Oracle monitoring: duration
    rcode =                     " db02_rcode    Oracle monitoring: total return code
    .  "  ORA_COLL_SE_AGG_PART_LIST

ABAP code example for Function Module ORA_COLL_SE_AGG_PART_LIST

The ABAP code below is a full code listing to execute function module ORA_COLL_SE_AGG_PART_LIST including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).

DATA:
ld_date  
 
 TYPE DB02_DATE
,
ld_time  
 
 TYPE DB02_TIME
,
ld_wday  
 
 TYPE DB02_WDAY
,
ld_cweek  
 
 TYPE DB02_CWEEK
,
ld_upload  
 
 TYPE DB02_UPLOAD
,
ld_duration  
 
 TYPE DB02_DURATION
,
ld_rcode  
 
 TYPE DB02_RCODE
.


DATA(ld_con_name) = 'Check type of data required'.

DATA(ld_monikey) = 'Check type of data required'.

DATA(ld_process_type) = 'Check type of data required'.

DATA(ld_s_monikey_1) = 'Check type of data required'.

DATA(ld_s_monikey_2) = 'Check type of data required'.

DATA(ld_s_monikey_3) = 'Check type of data required'.

DATA(ld_s_monikey_4) = 'Check type of data required'.

DATA(ld_s_monikey_5) = 'Check type of data required'.

DATA(ld_s_monikey_6) = 'Check type of data required'.

DATA(ld_s_monikey_7) = 'Check type of data required'.

DATA(ld_s_monikey_8) = 'Check type of data required'.

DATA(ld_s_monikey_9) = 'Check type of data required'.

DATA(ld_s_monikey_10) = 'Check type of data required'.

DATA(ld_param) = 'Check type of data required'.

DATA(ld_refresh) = 'Check type of data required'.
.

CALL FUNCTION 'ORA_COLL_SE_AGG_PART_LIST'
  EXPORTING
    con_name =                   ld_con_name
    monikey =                    ld_monikey
    process_type =               ld_process_type
*   s_monikey_1 =                ld_s_monikey_1
*   s_monikey_2 =                ld_s_monikey_2
*   s_monikey_3 =                ld_s_monikey_3
*   s_monikey_4 =                ld_s_monikey_4
*   s_monikey_5 =                ld_s_monikey_5
*   s_monikey_6 =                ld_s_monikey_6
*   s_monikey_7 =                ld_s_monikey_7
*   s_monikey_8 =                ld_s_monikey_8
*   s_monikey_9 =                ld_s_monikey_9
*   s_monikey_10 =               ld_s_monikey_10
*   param =                      ld_param
*   refresh =                    ld_refresh
  IMPORTING
    date =                       ld_date
    time =                       ld_time
    wday =                       ld_wday
    cweek =                      ld_cweek
    upload =                     ld_upload
    duration =                   ld_duration
    rcode =                      ld_rcode
    .  "  ORA_COLL_SE_AGG_PART_LIST

IF SY-SUBRC EQ 0.
  "All OK
ENDIF.

ABAP code to compare 7.40 inline data declaration with original syntax

The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.

DATA:

ld_date
 
 TYPE DB02_DATE ,
ld_con_name
 
 TYPE DBCON_NAME ,
ld_time
 
 TYPE DB02_TIME ,
ld_monikey
 
 TYPE MONIKEY ,
ld_wday
 
 TYPE DB02_WDAY ,
ld_process_type
 
 TYPE DB02_PROC_TYP ,
ld_s_monikey_1
 
 TYPE MONIKEY ,
ld_cweek
 
 TYPE DB02_CWEEK ,
ld_upload
 
 TYPE DB02_UPLOAD ,
ld_s_monikey_2
 
 TYPE MONIKEY ,
ld_duration
 
 TYPE DB02_DURATION ,
ld_s_monikey_3
 
 TYPE MONIKEY ,
ld_rcode
 
 TYPE DB02_RCODE ,
ld_s_monikey_4
 
 TYPE MONIKEY ,
ld_s_monikey_5
 
 TYPE MONIKEY ,
ld_s_monikey_6
 
 TYPE MONIKEY ,
ld_s_monikey_7
 
 TYPE MONIKEY ,
ld_s_monikey_8
 
 TYPE MONIKEY ,
ld_s_monikey_9
 
 TYPE MONIKEY ,
ld_s_monikey_10
 
 TYPE MONIKEY ,
ld_param
 
 TYPE DB02_PARAM ,
ld_refresh
 
 TYPE DB02_FLAG .


ld_con_name = 'Check type of data required'.
ld_monikey = 'Check type of data required'.
ld_process_type = 'Check type of data required'.
ld_s_monikey_1 = 'Check type of data required'.
ld_s_monikey_2 = 'Check type of data required'.
ld_s_monikey_3 = 'Check type of data required'.
ld_s_monikey_4 = 'Check type of data required'.
ld_s_monikey_5 = 'Check type of data required'.
ld_s_monikey_6 = 'Check type of data required'.
ld_s_monikey_7 = 'Check type of data required'.
ld_s_monikey_8 = 'Check type of data required'.
ld_s_monikey_9 = 'Check type of data required'.
ld_s_monikey_10 = 'Check type of data required'.
ld_param = 'Check type of data required'.
ld_refresh = 'Check type of data required'.