Skip to Content
0
Former Member
Jun 02, 2008 at 08:45 AM

SQL performance tuning - select code is taking so long to execute

23 Views

Hi,

Do you have any suggestion on how to improve the performance of this code? It is taking 3 minutes and returns only one record.

SELECT DISTINCT vbak~vbeln

vbkd~zzvextzau

vbak~auart

INTO TABLE zauth_itab

FROM vbak

INNER JOIN vbap

ON vbapmandt = vbakmandt

AND vbapvbeln = vbakvbeln

INNER JOIN vbup

ON vbupmandt = vbakmandt

AND vbupvbeln = vbakvbeln

INNER JOIN vbkd

ON vbkdmandt = vbakmandt

AND vbkdvbeln = vbakvbeln

AND vbkd~posnr = 0

WHERE vbak~vbeln IN s_vbeln

AND vbap~matnr IN s_matnr

AND vbap~kondm IN s_kondm

AND vbak~auart IN s_auart

AND vbak~vkorg IN s_vkorg

AND vbak~guebg IN r_guebg

AND ( vbak~gueen > sy-datum OR

vbak~gueen = 0 )

AND vbup~rfsta EQ 'C'.

Thanks!

Che