topic Re: Function Module Performance Tunning Issue in Application Development and Automation Discussions

Function Module Performance Tunning Issue

Former Member — Sun, 11 Feb 2007 15:53:57 GMT

I would like improve the performance for this below function module.

This FM is for BW extraction . Ztest is the view created based aufnr,afru and cdhdr table with 12 fields.

I have checked in the SE30 -transaction . It hit is 92 % in the database level and ABAP is only 7% . Please advise me how can improve the performace of this function module.

Advance thanks for your help.

FUNCTION ZTEST.

*"----

""Local interface:

*" IMPORTING

*" REFERENCE(I_REQUNR) TYPE SRSC_S_IF_SIMPLE-REQUNR

*" REFERENCE(I_DSOURCE) TYPE SRSC_S_IF_SIMPLE-DSOURCE OPTIONAL

*" REFERENCE(I_MAXSIZE) TYPE SRSC_S_IF_SIMPLE-MAXSIZE DEFAULT 1000

*" REFERENCE(I_INITFLAG) TYPE SRSC_S_IF_SIMPLE-INITFLAG OPTIONAL

*" REFERENCE(I_READ_ONLY) TYPE SRSC_S_IF_SIMPLE-READONLY OPTIONAL

*" TABLES

*" I_T_SELECT TYPE SRSC_S_IF_SIMPLE-T_SELECT OPTIONAL

*" I_T_FIELDS TYPE SRSC_S_IF_SIMPLE-T_FIELDS OPTIONAL

*" E_T_DATA STRUCTURE ZVIEW1 OPTIONAL

*" EXCEPTIONS

*" NO_MORE_DATA

*" ERROR_PASSED_TO_MESS_HANDLER

*"----

TABLES: ZVIEW1.

Auxiliary Selection criteria structure

DATA: L_S_SELECT TYPE SRSC_S_SELECT.

Initialization mode (first call by SAPI) or data transfer mode
(following calls) ?

*----

Data Structures for delta-mechanism

*----

DATA: L_V_LINES TYPE I.

*----

Static structures

*----

STATICS: S_S_IF TYPE SRSC_S_IF_SIMPLE,

counter

S_COUNTER_DATAPAKID LIKE SY-TABIX,

cursor

S_CURSOR TYPE CURSOR.

Ranges for data selection

RANGES: L_R_ERSDA FOR ZVIEW1-ERSDA,

L_R_AUFNR FOR ZVIEW1-AUFNR,

L_R_BUDAT FOR ZVIEW1-BUDAT,

L_R_RMZHL FOR ZVIEW1-RMZHL,

L_R_RUECK FOR ZVIEW1-RUECK,

L_R_VORNR FOR ZVIEW1-VORNR.

DATA: L_T_DATA TYPE STANDARD TABLE OF ZVIEW1 WITH HEADER LINE.

Initialization mode (first call by SAPI) or data transfer mode
(following calls) ?

IF I_INITFLAG = SBIWA_C_FLAG_ON.

************************************************************************

Initialization: check input parameters

buffer input parameters

prepare data selection

************************************************************************

Check DataSource validity

CASE I_DSOURCE.

WHEN 'ZTEST'.

WHEN OTHERS.

RAISE ERROR_PASSED_TO_MESS_HANDLER.

ENDCASE.

Copy selection criteria for future extractor calls (fetch-calls)

APPEND LINES OF I_T_SELECT TO S_S_IF-T_SELECT.

Fill parameter buffer for data extraction calls

S_S_IF-REQUNR = I_REQUNR.

S_S_IF-DSOURCE = I_DSOURCE.

S_S_IF-MAXSIZE = I_MAXSIZE.

S_S_IF-INITFLAG = I_INITFLAG.

Fill field list table for an optimized select statement
(in case that there is no 1:1 relation between InfoSource fields
and database table fields this may be far from being trivial)

APPEND LINES OF I_T_FIELDS TO S_S_IF-T_FIELDS.

ELSE. "Initialization mode or data extraction ?

************************************************************************

Data transfer: First Call OPEN CURSOR + FETCH

Following Calls FETCH only

************************************************************************

First data package -> OPEN CURSOR

IF S_COUNTER_DATAPAKID = 0.

Fill range tables BW will only pass down simple selection criteria
of the type SIGN = 'I' and OPTION = 'EQ' or OPTION = 'BT'.