Hi,
I have to improve the performance of the one custome program. I applied SQL trace & found out that below extract of code is taking maximum time.
SELECT vbak~vbeln
vbak~erdat
vbak~auart
vbak~augru
vbak~vkorg
vbak~vtweg
vbak~spart
vbak~kunnr
vbak~submi
vbak~knumv
vbuk~fksak
INTO CORRESPONDING FIELDS OF TABLE it_vbak
FROM vbak
INNER JOIN vbuk ON vbakvbeln EQ vbukvbeln
WHERE vbak~vbeln IN s_vbeln
AND vbak~vkorg EQ p_vkorg
AND vbak~vtweg EQ p_vtweg
AND vbak~spart IN s_spart
AND vbak~erdat IN s_erdat
AND vbak~kunnr IN s_kunnr
AND vbak~auart IN r_auart
AND vbak~augru EQ c_zcb
AND vbuk~fksak EQ c_c.
How can i use the for all entries in above code.. Will it enhance the performance of the code?