Skip to Content
0
Former Member
Apr 28, 2010 at 07:08 AM

ZVGSPVVG0370 prg taking long time to execute

28 Views

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