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.