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