Hello,
The below queries are very time consuming.Could you please suggest how to improve performance for these 2 queries:
QUERY1:
SELECT avbeln aposnr aauart avkorg avtweg aspart
avkbur akunnr bmatnr bkwmeng b~vrkme
bnetwr bwerks blgort bvstel babgru berdat b~ernam
cfaksk cktext cvdatu czzbrsch ckvgr1 caugru
INTO CORRESPONDING FIELDS OF TABLE g_t_sodata
FROM vapma AS a INNER JOIN vbap AS b ON
avbeln = bvbeln AND aposnr = bposnr
INNER JOIN vbak AS c ON avbeln = cvbeln
WHERE a~vkorg IN so_vkorg
AND a~vtweg IN so_vtweg
AND a~vkbur IN so_vkbur
AND a~auart IN so_auart
AND a~vbeln IN so_vbeln
AND b~abgru IN so_abgru
AND c~faksk IN so_faksk
AND ( b~erdat GT g_f_zenkai_date OR
( berdat EQ g_f_zenkai_date AND berzet GE g_f_zenkai_time ) )
AND ( b~erdat LT g_f_kaisi_date OR
( berdat EQ g_f_kaisi_date AND berzet LT g_f_kaisi_time ) ).
QUERY2:
SELECT avbeln aposnr aauart avkorg avtweg aspart
avkbur akunnr bmatnr bkwmeng b~vrkme
b~netwr
bwerks blgort bvstel babgru berdat bernam
cfaksk cktext cvdatu czzbrsch ckvgr1 caugru
INTO CORRESPONDING FIELDS OF TABLE g_t_sodata
FROM vapma AS a INNER JOIN vbap AS b ON
avbeln = bvbeln AND aposnr = bposnr
INNER JOIN vbak AS c ON avbeln = cvbeln
WHERE a~vkorg IN so_vkorg
AND a~vtweg IN so_vtweg
AND a~vkbur IN so_vkbur
AND a~auart IN so_auart
AND a~vbeln IN so_vbeln
AND b~abgru IN so_abgru
AND c~faksk IN so_faksk.