UMC_EXECUTE_MDXSTMT_BW20 SAP Function module

UMC_EXECUTE_MDXSTMT_BW20 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 UMC_EXECUTE_MDXSTMT_BW20 into the relevant SAP transaction such as SE37 or SE80.

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

Pattern for FM UMC_EXECUTE_MDXSTMT_BW20 - UMC EXECUTE MDXSTMT BW20

CALL FUNCTION 'UMC_EXECUTE_MDXSTMT_BW20' "
  EXPORTING
    i_destination =             " umc_y_rfcdest
    i_tcube =                   " umc_y_tcube
    i_tquery =                  " umc_y_tquery
    it_mdxcmdtxt =              " umc_yt_mdxcmd
*   i_handleflg = ' '           " as4flag
*   i_get_exception = ' '       " as4flag
*   i_keydate = SY-DATUM        " umc_y_date    Date
  IMPORTING
    et_flat_data =              " umc_yt_flatdata
    e_handle =                  " umc_y_handle
    e_message =                 " umc_y_message  Message Text
  EXCEPTIONS
    RFC_ERROR = 1               "
    ODBO_ERROR = 2              "
    .  "  UMC_EXECUTE_MDXSTMT_BW20

ABAP code example for Function Module UMC_EXECUTE_MDXSTMT_BW20

The ABAP code below is a full code listing to execute function module UMC_EXECUTE_MDXSTMT_BW20 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_et_flat_data  
 
 TYPE UMC_YT_FLATDATA
,
ld_e_handle  
 
 TYPE UMC_Y_HANDLE
,
ld_e_message  
 
 TYPE UMC_Y_MESSAGE
.


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

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

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

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

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

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

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

CALL FUNCTION 'UMC_EXECUTE_MDXSTMT_BW20'
  EXPORTING
    i_destination =              ld_i_destination
    i_tcube =                    ld_i_tcube
    i_tquery =                   ld_i_tquery
    it_mdxcmdtxt =               ld_it_mdxcmdtxt
*   i_handleflg =                ld_i_handleflg
*   i_get_exception =            ld_i_get_exception
*   i_keydate =                  ld_i_keydate
  IMPORTING
    et_flat_data =               ld_et_flat_data
    e_handle =                   ld_e_handle
    e_message =                  ld_e_message
  EXCEPTIONS
    RFC_ERROR =                  1
    ODBO_ERROR =                 2
    .  "  UMC_EXECUTE_MDXSTMT_BW20

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 2. "Exception
  "Add code for exception here
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_et_flat_data
 
 TYPE UMC_YT_FLATDATA ,
ld_i_destination
 
 TYPE UMC_Y_RFCDEST ,
ld_e_handle
 
 TYPE UMC_Y_HANDLE ,
ld_i_tcube
 
 TYPE UMC_Y_TCUBE ,
ld_e_message
 
 TYPE UMC_Y_MESSAGE ,
ld_i_tquery
 
 TYPE UMC_Y_TQUERY ,
ld_it_mdxcmdtxt
 
 TYPE UMC_YT_MDXCMD ,
ld_i_handleflg
 
 TYPE AS4FLAG ,
ld_i_get_exception
 
 TYPE AS4FLAG ,
ld_i_keydate
 
 TYPE UMC_Y_DATE .


ld_i_destination = 'Check type of data required'.
ld_i_tcube = 'Check type of data required'.
ld_i_tquery = 'Check type of data required'.
ld_it_mdxcmdtxt = 'Check type of data required'.
ld_i_handleflg = 'Check type of data required'.
ld_i_get_exception = 'Check type of data required'.
ld_i_keydate = 'Check type of data required'.