Skip to Content
0
Former Member
Sep 13, 2007 at 03:59 AM

statement construction

20 Views

Hi

i have written sql like this, program is running for hour, andw heni run se30 it showed the program is taking lion's share of runtime. how to tune this statement?

SELECT vbeln

wadat

FROM likp

INTO TABLE t_likp

FOR ALL ENTRIES IN t_vbak

WHERE vkorg = t_vbak-vkorg

AND kunag = t_vbak-kunnr

AND wadat_ist IN so_budat.