Skip to Content
0
Former Member
Jul 16, 2008 at 10:49 AM

Query in SAPKKA12 - taking long time

83 Views

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