SAP MCOD_ORA_GET_INFOS Function Module for









MCOD_ORA_GET_INFOS is a standard mcod ora get infos SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used to perform a specific ABAP function and below is the pattern details, 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 mcod ora get infos FM, simply by entering the name MCOD_ORA_GET_INFOS into the relevant SAP transaction such as SE37 or SE38.

Function Group: NORA
Program Name: SAPLNORA
Main Program:
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Remote-Enabled
Update:



Function MCOD_ORA_GET_INFOS 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 'MCOD_ORA_GET_INFOS'"
  EXPORTING
*  DATA_DL = ' ' "General Flag

TABLES
   SQL_TAB =  "Structure of Table SQL_TAB
   SYSTEM_EVENT_SUM =  "
   SYSTEM_EVENT =  "
   SQL_SESSTAT_TAB =  "
   ALL_SYSTEM_EVENT =  "
   ALL_SYSTEM_EVENT_SUM =  "
   SESSION_EVENT =  "Information from V$SESSION_EVENT
   SESSION_EVENT_USER =  "
   CPU_PER_USER_PER_SID =  "
   CPU_PER_USER_SUM =  "
   CPU_PER_USER =  "Information about CPU per USER per SID from V$SESSTAT
   CPU_WAIT_PER_USER =  "
.



IMPORTING Parameters details for MCOD_ORA_GET_INFOS

DATA_DL - General Flag

Data type: TST04HELP-FLAG
Default: ' '
Optional: No
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for MCOD_ORA_GET_INFOS

SQL_TAB - Structure of Table SQL_TAB

Data type: SQL_STRUC
Optional: No
Call by Reference: Yes

SYSTEM_EVENT_SUM -

Data type: SYS_EVENT
Optional: No
Call by Reference: Yes

SYSTEM_EVENT -

Data type: SYS_EVENT
Optional: No
Call by Reference: Yes

SQL_SESSTAT_TAB -

Data type: SQL_SESS
Optional: No
Call by Reference: Yes

ALL_SYSTEM_EVENT -

Data type: SESS_EVNT
Optional: No
Call by Reference: Yes

ALL_SYSTEM_EVENT_SUM -

Data type: SESS_EVNT
Optional: No
Call by Reference: Yes

SESSION_EVENT - Information from V$SESSION_EVENT

Data type: SESS_EVNT
Optional: No
Call by Reference: Yes

SESSION_EVENT_USER -

Data type: SESS_EVNT
Optional: No
Call by Reference: Yes

CPU_PER_USER_PER_SID -

Data type: CPUSID_USR
Optional: No
Call by Reference: Yes

CPU_PER_USER_SUM -

Data type: CPUSID_USR
Optional: No
Call by Reference: Yes

CPU_PER_USER - Information about CPU per USER per SID from V$SESSTAT

Data type: CPUSID_USR
Optional: No
Call by Reference: Yes

CPU_WAIT_PER_USER -

Data type: SYS_EVENT
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for MCOD_ORA_GET_INFOS 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_data_dl  TYPE TST04HELP-FLAG, "   ' '
lt_sql_tab  TYPE STANDARD TABLE OF SQL_STRUC, "   
lt_system_event_sum  TYPE STANDARD TABLE OF SYS_EVENT, "   
lt_system_event  TYPE STANDARD TABLE OF SYS_EVENT, "   
lt_sql_sesstat_tab  TYPE STANDARD TABLE OF SQL_SESS, "   
lt_all_system_event  TYPE STANDARD TABLE OF SESS_EVNT, "   
lt_all_system_event_sum  TYPE STANDARD TABLE OF SESS_EVNT, "   
lt_session_event  TYPE STANDARD TABLE OF SESS_EVNT, "   
lt_session_event_user  TYPE STANDARD TABLE OF SESS_EVNT, "   
lt_cpu_per_user_per_sid  TYPE STANDARD TABLE OF CPUSID_USR, "   
lt_cpu_per_user_sum  TYPE STANDARD TABLE OF CPUSID_USR, "   
lt_cpu_per_user  TYPE STANDARD TABLE OF CPUSID_USR, "   
lt_cpu_wait_per_user  TYPE STANDARD TABLE OF SYS_EVENT. "   

  CALL FUNCTION 'MCOD_ORA_GET_INFOS'  "
    EXPORTING
         DATA_DL = lv_data_dl
    TABLES
         SQL_TAB = lt_sql_tab
         SYSTEM_EVENT_SUM = lt_system_event_sum
         SYSTEM_EVENT = lt_system_event
         SQL_SESSTAT_TAB = lt_sql_sesstat_tab
         ALL_SYSTEM_EVENT = lt_all_system_event
         ALL_SYSTEM_EVENT_SUM = lt_all_system_event_sum
         SESSION_EVENT = lt_session_event
         SESSION_EVENT_USER = lt_session_event_user
         CPU_PER_USER_PER_SID = lt_cpu_per_user_per_sid
         CPU_PER_USER_SUM = lt_cpu_per_user_sum
         CPU_PER_USER = lt_cpu_per_user
         CPU_WAIT_PER_USER = lt_cpu_wait_per_user
. " MCOD_ORA_GET_INFOS




ABAP code using 7.40 inline data declarations to call FM MCOD_ORA_GET_INFOS

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.

"SELECT single FLAG FROM TST04HELP INTO @DATA(ld_data_dl).
DATA(ld_data_dl) = ' '.
 
 
 
 
 
 
 
 
 
 
 
 
 


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!