Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

memory problems in internal table

Hi,

I am facing an issue with the internal table memory.

I am selecting something from the database and putting it in internal table but the load is so much that it is giving me memory errors as the data may go into millions.

So what we have decided is to cut down the data in the internal table. we have defined a variable which will contain suppose 30000 data.

so what i mean to do is to take the records from the databas based on the value in the variable. By that way i will be taking only 30000 data each time.

But the issue is that first time it will take 1 to 30000 records if i give upto 30000 rows in the select query.. but then how will i take 30001 to 60000 the next time.. by that i mean how will i keep incrementing in the select query.

Thanks in advance.

Amit Kurup

Tags:
replied

You can use <b>PACKAGE SIZE</b> in the SELECT statement to define the number of records to read.

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

Regards,

Wenceslaus.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question