Problem with internal table memory

[Former Member]

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.

[Former Member]

Hi,

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

Reg,

Hariharan Natarajan.

[Former Member]

fine tune ur program .

or extent page area of ur User ID.

Regards

Prabhu

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

use parallel cursor, this is the best solution for this

Reward if usefule

[Former Member]

Phanindra,

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

Regards,

Sankar.