Skip to Content
0
Former Member
Jul 01, 2009 at 06:46 AM

Select query modification

33 Views

Hi,

This below mentioned select statement taking more time to execute so i am planning to devide into parts. Please do let me know if any better suggestions on its division.

SELECT ekko~ebeln

ekko~lifnr

ekko~bukrs

ekbe~ebelp

ekbe~budat

ekbe~belnr

ekbe~gjahr

ekbe~wrbtr

ekbe~shkzg

ekbe~xblnr

INTO TABLE it_poir_dtl

FROM ekbe

INNER JOIN ekko ON

ekbeebeln = ekkoebeln

FOR ALL entries IN it_bkpf

WHERE ekbe~vgabe = '1'

AND ekko~bukrs = it_bkpf-bukrs

AND ekbe~belnr = it_bkpf-awkey(10)

AND ekbe~gjahr = it_bkpf-gjahr

AND lifnr BETWEEN '0000100000' and '0000199999'.

Earliest reply would help me a lot.

Thanks,

Devasing