Performance issue in ABAP

Hi,

This issue is becoming very big challenge for us.

"select adrnr

tplnr

appending table i_iloa

package size 50000

from iloa

where tplnr in s_mprn2

and owner eq '2'.

endselect.

like this i have some other select statements based on i_iloa.

I am getting 4 milian records based on above selection.

Based on i_iloa i have to get some other line items

"select zztplnr

herst

serge

typbz

baujj

zzicharge

matnr

appending table i_equi_i

package size 50000

from equi

for all entries in i_iloa

where zztplnr eq i_iloa-tplnr.

endselect."

I think an average this will get more than 10millians records.So system is going for dump.

ERROR

"Operating system can not provide enough space to process the data"

Error analysis is

"The internal table could not be enlarged futher.You are attempted to create block of table of length for internal table"

Is there any way to fine tune this coding.

Thanks in advance

Murali