SAP ORA_COLL_SE_GENERAL_MAIN_DATA Function Module for Oracle monitoring: collect database general main data









ORA_COLL_SE_GENERAL_MAIN_DATA is a standard ora coll se general main data SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Oracle monitoring: collect database general main data processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for ora coll se general main data FM, simply by entering the name ORA_COLL_SE_GENERAL_MAIN_DATA into the relevant SAP transaction such as SE37 or SE38.

Function Group: SDBORA3
Program Name: SAPLSDBORA3
Main Program: SAPLSDBORA3
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function ORA_COLL_SE_GENERAL_MAIN_DATA pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'ORA_COLL_SE_GENERAL_MAIN_DATA'"Oracle monitoring: collect database general main data
  EXPORTING
   CON_NAME =  "Oracle monitoring: connection name
*  S_MONIKEY_7 =  "Oracle monitoring: monikey
*  S_MONIKEY_8 =  "Oracle monitoring: monikey
*  S_MONIKEY_9 =  "Oracle monitoring: monikey
*  S_MONIKEY_10 =  "Oracle monitoring: monikey
*  PARAM =  "Oracle monitoring: parameter
*  REFRESH =  "Oracle monitoring: flag
   MONIKEY =  "Oracle monitoring: monikey
   PROCESS_TYPE =  "Oracle monitoring: process type
*  S_MONIKEY_1 =  "Oracle monitoring: monikey
*  S_MONIKEY_2 =  "Oracle monitoring: monikey
*  S_MONIKEY_3 =  "Oracle monitoring: monikey
*  S_MONIKEY_4 =  "Oracle monitoring: monikey
*  S_MONIKEY_5 =  "Oracle monitoring: monikey
*  S_MONIKEY_6 =  "Oracle monitoring: monikey

 IMPORTING
   DATE =  "Date and time, current (application server) date
   TIME =  "Date and Time, Current Application Server Time
   WDAY =  "Oracle monitoring: Week day
   CWEEK =  "Oracle monitoring: calendar week
   UPLOAD =  "Oracle monitoring: bytes uploaded in MONI
   DURATION =  "Oracle monitoring: duration
   RCODE =  "Oracle monitoring: total return code
.



IMPORTING Parameters details for ORA_COLL_SE_GENERAL_MAIN_DATA

CON_NAME - Oracle monitoring: connection name

Data type: DBCON_NAME
Optional: No
Call by Reference: No ( called with pass by value option)

S_MONIKEY_7 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

S_MONIKEY_8 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

S_MONIKEY_9 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

S_MONIKEY_10 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

PARAM - Oracle monitoring: parameter

Data type: DB02_PARAM
Optional: Yes
Call by Reference: No ( called with pass by value option)

REFRESH - Oracle monitoring: flag

Data type: DB02_FLAG
Optional: Yes
Call by Reference: No ( called with pass by value option)

MONIKEY - Oracle monitoring: monikey

Data type: MONIKEY
Optional: No
Call by Reference: No ( called with pass by value option)

PROCESS_TYPE - Oracle monitoring: process type

Data type: DB02_PROC_TYP
Optional: No
Call by Reference: No ( called with pass by value option)

S_MONIKEY_1 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

S_MONIKEY_2 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

S_MONIKEY_3 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

S_MONIKEY_4 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

S_MONIKEY_5 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

S_MONIKEY_6 - Oracle monitoring: monikey

Data type: MONIKEY
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXPORTING Parameters details for ORA_COLL_SE_GENERAL_MAIN_DATA

DATE - Date and time, current (application server) date

Data type: DB02_DATE
Optional: No
Call by Reference: No ( called with pass by value option)

TIME - Date and Time, Current Application Server Time

Data type: DB02_TIME
Optional: No
Call by Reference: No ( called with pass by value option)

WDAY - Oracle monitoring: Week day

Data type: DB02_WDAY
Optional: No
Call by Reference: No ( called with pass by value option)

CWEEK - Oracle monitoring: calendar week

Data type: DB02_CWEEK
Optional: No
Call by Reference: No ( called with pass by value option)

UPLOAD - Oracle monitoring: bytes uploaded in MONI

Data type: DB02_UPLOAD
Optional: No
Call by Reference: No ( called with pass by value option)

DURATION - Oracle monitoring: duration

Data type: DB02_DURATION
Optional: No
Call by Reference: No ( called with pass by value option)

RCODE - Oracle monitoring: total return code

Data type: DB02_RCODE
Optional: No
Call by Reference: No ( called with pass by value option)

Copy and paste ABAP code example for ORA_COLL_SE_GENERAL_MAIN_DATA Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than 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 newer method of declaring data variables on the fly. 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), which i why i have stuck to the origianl for this example.

DATA:
lv_date  TYPE DB02_DATE, "   
lv_con_name  TYPE DBCON_NAME, "   
lv_s_monikey_7  TYPE MONIKEY, "   
lv_s_monikey_8  TYPE MONIKEY, "   
lv_s_monikey_9  TYPE MONIKEY, "   
lv_s_monikey_10  TYPE MONIKEY, "   
lv_param  TYPE DB02_PARAM, "   
lv_refresh  TYPE DB02_FLAG, "   
lv_time  TYPE DB02_TIME, "   
lv_monikey  TYPE MONIKEY, "   
lv_wday  TYPE DB02_WDAY, "   
lv_process_type  TYPE DB02_PROC_TYP, "   
lv_cweek  TYPE DB02_CWEEK, "   
lv_s_monikey_1  TYPE MONIKEY, "   
lv_upload  TYPE DB02_UPLOAD, "   
lv_s_monikey_2  TYPE MONIKEY, "   
lv_duration  TYPE DB02_DURATION, "   
lv_s_monikey_3  TYPE MONIKEY, "   
lv_rcode  TYPE DB02_RCODE, "   
lv_s_monikey_4  TYPE MONIKEY, "   
lv_s_monikey_5  TYPE MONIKEY, "   
lv_s_monikey_6  TYPE MONIKEY. "   

  CALL FUNCTION 'ORA_COLL_SE_GENERAL_MAIN_DATA'  "Oracle monitoring: collect database general main data
    EXPORTING
         CON_NAME = lv_con_name
         S_MONIKEY_7 = lv_s_monikey_7
         S_MONIKEY_8 = lv_s_monikey_8
         S_MONIKEY_9 = lv_s_monikey_9
         S_MONIKEY_10 = lv_s_monikey_10
         PARAM = lv_param
         REFRESH = lv_refresh
         MONIKEY = lv_monikey
         PROCESS_TYPE = lv_process_type
         S_MONIKEY_1 = lv_s_monikey_1
         S_MONIKEY_2 = lv_s_monikey_2
         S_MONIKEY_3 = lv_s_monikey_3
         S_MONIKEY_4 = lv_s_monikey_4
         S_MONIKEY_5 = lv_s_monikey_5
         S_MONIKEY_6 = lv_s_monikey_6
    IMPORTING
         DATE = lv_date
         TIME = lv_time
         WDAY = lv_wday
         CWEEK = lv_cweek
         UPLOAD = lv_upload
         DURATION = lv_duration
         RCODE = lv_rcode
. " ORA_COLL_SE_GENERAL_MAIN_DATA




ABAP code using 7.40 inline data declarations to call FM ORA_COLL_SE_GENERAL_MAIN_DATA

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!