SAP RSDU_INFOCUBE_INDEXES_DROP_ORA Function Module for drops the secondary indexes on the facttable of an infocube









RSDU_INFOCUBE_INDEXES_DROP_ORA is a standard rsdu infocube indexes drop ora SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for drops the secondary indexes on the facttable of an infocube 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 rsdu infocube indexes drop ora FM, simply by entering the name RSDU_INFOCUBE_INDEXES_DROP_ORA into the relevant SAP transaction such as SE37 or SE38.

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



Function RSDU_INFOCUBE_INDEXES_DROP_ORA 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 'RSDU_INFOCUBE_INDEXES_DROP_ORA'"drops the secondary indexes on the facttable of an infocube
EXPORTING
I_INFOCUBE = "Name of the InfoCube
* I_FACTTAB = "
* I_INDEXNAME = "
* I_SKIP_PACKAGE = RS_C_FALSE "
* I_DOUBLE_FACTTAB = RS_C_TRUE "

IMPORTING
E_DROPPED = "Number successfully deleted indexes

CHANGING
* C_PROCESSED = RS_C_FALSE "Boolean

EXCEPTIONS
DROPPING_ERROR = 1 INDEX_INFO_ERROR = 2 ILLEGAL_INPUT = 3
.



IMPORTING Parameters details for RSDU_INFOCUBE_INDEXES_DROP_ORA

I_INFOCUBE - Name of the InfoCube

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

I_FACTTAB -

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

I_INDEXNAME -

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

I_SKIP_PACKAGE -

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

I_DOUBLE_FACTTAB -

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

EXPORTING Parameters details for RSDU_INFOCUBE_INDEXES_DROP_ORA

E_DROPPED - Number successfully deleted indexes

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

CHANGING Parameters details for RSDU_INFOCUBE_INDEXES_DROP_ORA

C_PROCESSED - Boolean

Data type: RS_BOOL
Default: RS_C_FALSE
Optional: No
Call by Reference: Yes

EXCEPTIONS details

DROPPING_ERROR - error during DDIC index drop

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

INDEX_INFO_ERROR -

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

ILLEGAL_INPUT -

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

Copy and paste ABAP code example for RSDU_INFOCUBE_INDEXES_DROP_ORA 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_e_dropped  TYPE I, "   
lv_i_infocube  TYPE RSD_INFOCUBE, "   
lv_c_processed  TYPE RS_BOOL, "   RS_C_FALSE
lv_dropping_error  TYPE RS_BOOL, "   
lv_i_facttab  TYPE RSD_TABLNM, "   
lv_index_info_error  TYPE RSD_TABLNM, "   
lv_i_indexname  TYPE RSDU_INDEXNAME, "   
lv_illegal_input  TYPE RSDU_INDEXNAME, "   
lv_i_skip_package  TYPE RS_BOOL, "   RS_C_FALSE
lv_i_double_facttab  TYPE RS_BOOL. "   RS_C_TRUE

  CALL FUNCTION 'RSDU_INFOCUBE_INDEXES_DROP_ORA'  "drops the secondary indexes on the facttable of an infocube
    EXPORTING
         I_INFOCUBE = lv_i_infocube
         I_FACTTAB = lv_i_facttab
         I_INDEXNAME = lv_i_indexname
         I_SKIP_PACKAGE = lv_i_skip_package
         I_DOUBLE_FACTTAB = lv_i_double_facttab
    IMPORTING
         E_DROPPED = lv_e_dropped
    CHANGING
         C_PROCESSED = lv_c_processed
    EXCEPTIONS
        DROPPING_ERROR = 1
        INDEX_INFO_ERROR = 2
        ILLEGAL_INPUT = 3
. " RSDU_INFOCUBE_INDEXES_DROP_ORA




ABAP code using 7.40 inline data declarations to call FM RSDU_INFOCUBE_INDEXES_DROP_ORA

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.

 
 
DATA(ld_c_processed) = RS_C_FALSE.
 
 
 
 
 
 
DATA(ld_i_skip_package) = RS_C_FALSE.
 
DATA(ld_i_double_facttab) = RS_C_TRUE.
 


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!