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