topic Re: Improve Performance for this select in Application Development and Automation Discussions

Improve Performance for this select

Former Member — Fri, 06 Oct 2006 20:05:58 GMT

Hi All,

I have a performance issue.

This below is my select statement. And it takes a long time to retrieve the data.

    
SORT i_mvke BY matnr.
SELECT kunnr werks matnr FROM msku INTO TABLE i_msku
     FOR ALL ENTRIES IN i_mvke                              
     WHERE matnr = i_mvke-matnr
       AND kunnr IN r_kunnr
       AND werks IN s_werks.

is there any way to improve this select.

Thanks in advance.

Re: Improve Performance for this select

Former Member — Fri, 06 Oct 2006 20:10:29 GMT

Hi,

if you don't need all 'Special stock indicator' make also a select about it. msku-SOBKZ

Re: Improve Performance for this select

RichHeilman — Fri, 06 Oct 2006 20:18:57 GMT

Make sure that there are rows in I_MVKE.

if not i_mvke[] is initial.
SORT i_mvke BY matnr.
SELECT kunnr werks matnr FROM msku INTO TABLE i_msku
     FOR ALL ENTRIES IN i_mvke                              
     WHERE matnr = i_mvke-matnr
       AND kunnr IN r_kunnr
       AND werks IN s_werks.
endif.

Regards,

Rich Heilman

Re: Improve Performance for this select

Former Member — Fri, 06 Oct 2006 20:25:10 GMT

Thanks NL & Rich.

But its still sluggish after including SOBKZ. And i did have a check for MVKE not being empty.

How can i make use of index? How do i know if this table has any?

Thanks again.

Re: Improve Performance for this select

Former Member — Fri, 06 Oct 2006 20:28:52 GMT

SE11 --> msku --> Index Button.

In my system, no index is defined for this table...

How to use index??? Just include them in your where parameters...

Greetings,

Blag.

Re: Improve Performance for this select

shishupalreddy — Sat, 07 Oct 2006 04:14:54 GMT

Hi ,

For the follwing query You can create the secondary index on the field 'Special Stock Indicator' in SE11 and then use the same in <Where > clause.

if not i_mvke is initial.

SORT i_mvke BY matnr.

SELECT kunnr werks matnr FROM msku INTO TABLE i_msku

FOR ALL ENTRIES IN i_mvke

WHERE matnr = i_mvke-matnr

AND kunnr IN r_kunnr

AND werks IN s_werks.

Regards,

Re: Improve Performance for this select

jayanthi_jayaraman — Sat, 07 Oct 2006 04:23:04 GMT

Hi,

Check whether your internal table i_msku contains only the fields kunnr werks and matnr.Otherwise use as following.

SORT i_mvke BY matnr.

SELECT kunnr werks matnr FROM msku INTO corresponding fields of TABLE i_msku

FOR ALL ENTRIES IN i_mvke

WHERE matnr = i_mvke-matnr

AND kunnr IN r_kunnr

AND werks IN s_werks.

still the performance is not improved,try using index.

otherwise select all the rows from msku at a strech and then delete the unwanted rows thereafer.

Kindly reward points if it helps.