Skip to Content
0
Former Member
Oct 16, 2013 at 06:00 AM

No storage space available for extending the internal table

61 Views

Hi All,

We are getting "No storage space available for extending the internal table" error while executing the report.


error occured at this select statement:

SELECT vbak ~ vbeln vbap ~ posnr vbap ~ uepos vbap ~ pstyv vbak ~ auart vbak ~ vkorg
vbak ~ kunnr vbap ~ matnr vbap ~ pmatn vbap ~ mvgr1 vbap ~ mvgr3 vbap ~ charg
vbap ~ werks vbap ~ abgru vbak ~ augru vbak ~ lifsk vbak ~ faksk vbak ~ vsbed
vbap ~ lprio vbak ~ vdatu vbak ~ zzsurg_date vbap ~ kwmeng vbap ~ prodh
vbap ~ vrkme vbap ~ netpr vbap ~ netwr vbap ~ waerk vbap ~ zzterr_id
vbak ~ audat vbak ~ erzet vbak ~ ernam vbak ~ vbtyp vbak ~ erdat
vbup ~ uvall vbup ~ gbsta vbup ~ gbsta vbup ~ fksaa vbap ~ serail
vbap ~ faksp vbap ~ zmeng vbap ~ zieme vbap ~ umvkz vbap ~ umvkn vbap ~ kmein
INTO CORRESPONDING FIELDS OF TABLE i_data
FROM vbak
INNER JOIN vbap
ON vbak ~ vbeln = vbap ~ vbeln
INNER JOIN vbup
ON vbap ~ vbeln = vbup ~ vbeln AND
vbap ~ posnr = vbup ~ posnr
WHERE vbak ~ vbeln IN s_vbeln AND
vbap ~ prodh IN s_prodh AND
vbap ~ matnr IN s_matnr AND
vbak ~ vkorg IN s_vkorg AND
vbap ~ werks IN s_werks AND
vbak ~ kunnr IN s_kunnr AND
vbak ~ auart IN s_auart AND
vbak ~ audat IN s_audat AND
vbak ~ ernam IN s_ernam AND
vbak ~ vdatu IN s_vdatu AND
vbak ~ zzsurg_date IN s_sdate AND
vbap ~ abgru IN

s_abgru.

where vkorg is mandatory parameter. can we optimize this condition to avoid the memory dump??

Thanks in advance..

Have a great day !!