hi,
In ZVGSPVVG0370 prg taking 10 min to execute and finally it going for dump becase of the following select query.
SELECT knumv kposn knumh kmxaw kinak
FROM konv
INTO CORRESPONDING FIELDS OF TABLE gt_konv
FOR ALL ENTRIES IN lt_s971
WHERE knumv = lt_s971-knumv
AND kschl = pa_kschl
AND kappl = 'V'.
i am geting values for the internal table lt_s971 by using follwing query
SELECT s971vbeln s971knumv s971auart s971vbtyp s971~matnr
s971vkorg s971vtweg s971spart s971prsdt
FROM s971 AS s971 INNER JOIN vbak AS vbak
ON s971vbeln = vbakvbeln
INTO CORRESPONDING FIELDS OF TABLE lt_s971
WHERE s971~vkorg IN so_vkorg
AND s971~vtweg IN so_vtweg
AND s971~spart IN so_spart
AND vbak~vkorg IN so_vkorg
AND vbak~vtweg IN so_vtweg
AND vbak~spart IN so_spart
AND s971~matnr IN so_matnr
AND s971~prsdt >= l_datab
AND s971~prsdt <= l_datbi.
in this internal table nearly 20 lakh records are there. So please give me the suggestion to improve the speed.
Thanks in advance
R.vijai