Memory Size in Select statement.

Hi,

We have a problem in executing the program. The code fetches millions of records for processing, due to this , the Dump occured. Any way to fine tune the Code to split the file and process the contents of it.

The Code :

select * from zglob_avail into table gt_zglob_avail.

lv_count = sy-dbcnt.

loop at gt_zglob_avail.

if gt_zglob_avail-offer_package is not initial and

gt_zglob_avail-good is not initial.

.

.

.

. endif.

endloop.

The Dump :

Roll..................... 16128

EM....................... 595179824

MM Used.................. 572595736

MM Free.................. 14183512

Regards,

Syed Ajaz