Skip to Content
0
Former Member
Nov 30, 2009 at 06:04 AM

Select statement with 3 'OR' operations in where condition

182 Views

Hi experts,

Following select statement taking more time for executing

if not it_itab[] is initial.

select belnr

blart

xblnr

stblg

bldat

gjahr

into table it_blart

from bkpf

for all entries in it_itab

where ( belnr = it_itab-belnr or belnr eq it_itab-rebzg or belnr eq it_itab-vbeln ).

endif.

kindly provide alternate select query to fetch same data as in above statement.

thanks & regards,

Raghul gandhi