Hi,
The following query is from program SAPKKA12 and taking a long time to run . Any inputs how can I optimize it?
Will index creation on VBAP help?
SELECT vbeln
posnr
abgrs
objnr
werks
kzbws
fkrel
uepos
FROM vbap
INTO CORRESPONDING FIELDS OF TABLE posnr_tab
WHERE vbeln IN abgrvbel AND
posnr IN abgrposn AND
werks IN r_werks AND
prctr IN vp_prctr AND
kzvbr EQ 'E' AND
vbeln = vbap~vbelv AND
posnr = vbap~posnv AND
objnr <> space and
( (add_selection) AND abgrs IN abgrschl
OR (add_selection1) ).
Thanks in advance.
Neethu Mohan