performance improvement for select query

[Former Member]

Hi all,

need to improve performace for the below select query as it is taking long time

SELECT vbeln pdstk

FROM vbuk INTO TABLE it_vbuk1 FOR ALL ENTRIES IN it_likp

WHERE vbeln = it_likp-vbeln AND

wbstk = 'C' AND "pdstk = ' ' AND

vbtyp IN gr_delivery AND

( fkstk = 'A' OR fkstk = 'B' ) OR

( fkivk = 'A' OR fkivk = 'B' ).

Regards,

Kumar

[Former Member]

An extra parenthesis will solve the problem

SELECT vbeln pdstk
FROM vbuk INTO TABLE it_vbuk1 FOR ALL ENTRIES IN it_likp
WHERE vbeln = it_likp-vbeln 
AND wbstk = 'C' 
AND pdstk = ' ' 
AND vbtyp IN gr_delivery 
AND(( fkstk = 'A' OR fkstk = 'B' )   
 OR
( fkivk = 'A' OR fkivk = 'B' )).

Also ensure IT_LIKP is not initial before using in FOR ALL ENTRIES IN

[Former Member]

Hi,

Check if it_likp is sorted on vbeln.

SELECT vbeln pdstk

FROM vbuk INTO TABLE it_vbuk1 FOR ALL ENTRIES IN it_likp

WHERE vbeln = it_likp-vbeln AND

wbstk = 'C' AND

vbtyp IN gr_delivery AND

( ( fkstk = 'A' OR fkstk = 'B' ) OR <-- check this condition , if ( ) is needed ...

( fkivk = 'A' OR fkivk = 'B' ) ) .

Regards,

Srini.

[Former Member]

Moderator message - Please see before posting - post locked Rob