topic Re: Problem with internal table memory in Application Development and Automation Discussions

Problem with internal table memory

Former Member — Fri, 20 Apr 2007 12:06:38 GMT

Hi,

I have a problem with internal table memory when executing a program.

It gives a short dump saying ' NO STORAGE SPACE AVAILABLE FOR EXTENDING INTERNAL TABLE '.

While short dump the int table has 2059835 records each of length 1800 characters. how to overcome this problem.

Thanks in advance.

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 12:08:34 GMT

Hi,

Use <b>WorkArea</b> Concept for the internal Table Present inside the program.

Reg,

Hariharan Natarajan.

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 12:10:54 GMT

fine tune ur program .

or extent page area of ur User ID.

Regards

Prabhu

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 12:13:23 GMT

If you trying to select the data from database table , then use packaga size option in select statement

http://www.sap-img.com/abap/package-size.htm

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 12:21:50 GMT

Hi Ramu,

You know the default size of an internal table is 8kb. if you are trying to store in internal table more than this size it may give you the dump saying 'No storage space' etc.,

Try like this create a custome database table with the same structure what you have in internal table. As soon as the internal table reaching certain limit take suppose 50,000 records, you update these records in data base table like this you update all records in database table.

Now you have all 2059835 records what ever it is in your data base table.

You can select partly from this data base table and process.

This is the way you resove this.

reward all helpful answers.

Regards,

Venkat

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 12:26:01 GMT

Hi,

in the Profiels, you need to increase the space for some parameters

Look at the below links

https://www.sdn.sap.com/irj/sdn/profile?userid=813610

http://www.sapfans.com/forums/viewtopic.php?p=714795&sid=46063020b4c3134d314e6361edcbdf24

Regards

Sudheer

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 12:33:09 GMT

I had faced with the same issue.

Solutions is to read entries in breaks and then put it in Internal table operate it and keep on appending by creating different table.

Even you can do any internal table operation if data is huge.

Reward if useful.

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 13:34:15 GMT

Using package size in the select statement is the best solution for this issue as far as i know instead of changing the memory areas...

Regards,

Sankar.

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 13:39:13 GMT

use parallel cursor, this is the best solution for this

Reward if usefule

Re: Problem with internal table memory

Former Member — Fri, 20 Apr 2007 13:43:28 GMT

Phanindra,

Can you please educate me on parallel cursor? I am new to this.

Regards,

Sankar.