topic Re: internal table space issue in Application Development and Automation Discussions

internal table space issue

Former Member — Tue, 04 Dec 2012 10:26:38 GMT

dear all,

when i am executing a report of bank balance, it is giving a short dump " no more storage space is available for extending an internal table". please tell me how i can resolve this issue.

thanks

Re: internal table space issue

Former Member — Tue, 04 Dec 2012 10:30:30 GMT

HI Robin

Please check the number of records it is fetching while debugging.

There is cretain limit for internal tables storage.

Some unneccesary loops may also increase the number of records.

Refresh and free the internal tables when they are not in use.

Thanks

Guru

Re: internal table space issue

Former Member — Tue, 04 Dec 2012 10:37:55 GMT

Can you please send the error screen shot?

Re: internal table space issue

Former Member — Tue, 04 Dec 2012 11:32:20 GMT

Hello Robin,

It is because of the data you are fetching is too big that internal table cannt hold all of this as it has some limitations.

You need to extract your data in chunks and probably write on to application server if you want to download complete file .

Regards,

Deepti

Re: internal table space issue

Former Member — Tue, 04 Dec 2012 11:40:01 GMT

Hi,

Try to use HASHED Table for your requirement,

here you can get the details.

http://help.sap.com/saphelp_erp60_sp/helpdata/en/fc/eb366d358411d1829f0000e829fbfe/frameset.htm

hope this works for you.

Avirat

Re: internal table space issue

Former Member — Tue, 04 Dec 2012 11:40:50 GMT

Hi,

Try to use HASHED Table for your requirement,

here you can get the details.

http://help.sap.com/saphelp_erp60_sp/helpdata/en/fc/eb366d358411d1829f0000e829fbfe/frameset.htm

hope this works for you.

Avirat

Re: internal table space issue

RaymondGiuseppi — Tue, 04 Dec 2012 18:42:09 GMT

set some parameters/selections mandatory to reduce volume
for huge data don't load the whole data, only load one main internal table (one run or by package) and then load missing data by load/package and free temporary internal tables asap
only load required data/field from database

Regards,

Raymond

Re: internal table space issue

Clemenss — Tue, 04 Dec 2012 19:46:38 GMT

Hi Robin,

identify the fields you really need and select into corresponding fields of table of this line type.

Use of hashed tables is always nice but will not help at all to reduce the size.

Regards, Clemens

Re: internal table space issue

Former Member — Wed, 05 Dec 2012 03:25:44 GMT

Dear Avirat,

I am using a BAPI 'BAPI_GLX_GETDOCITEMS' in my report . This bapi have that internal table.