Skip to Content
0
Former Member
Sep 11, 2007 at 12:03 PM

runtime issue

36 Views

hi all,

the below statement is giving me a runtime error.

In the shortdumb I got the messages as

->The maximum size of an SQL statement has been exceeded.

->The statement contains too many input variables.

->the space needed for the input data exceeds the available memory.

Can some one please suggest me a best replacement for this.

Also when I checked in ST05 this was taking higher time than any other statement and was in red highlight

SELECT vkdfsvkorg vkdfsvbtyp vkdfsvbeln tvkobukrs

vkdfsfkdat VKDFSSPART

into (t_vkdfs-vkorg, t_vkdfs-vbtyp, t_vkdfs-vbeln,

t_vkdfs-bukrs, t_vkdfs-fkdat, T_VKDFS-SPART)

FROM vkdfs join tvko on ( vkdfsvkorg = tvkovkorg )

JOIN VBAK ON ( VKDFSSPART = VBAKSPART )

WHERE fkdat IN s_wadat

AND vkdfs~vkorg IN s_vkorg AND

VKDFS~SPART IN S_SPART AND

vkdfs~vbtyp <> 'C'.

Thank you.