internal table cannot be extended dump - space complexity.
I have a requirement where I need to optimize a report program. Here, the program is giving short dump " TSV_TNEW_BLOCKS_NO_ROLL_MEMORY" and terminating t the following line because the internal table could not be extended".
Following is the "for all entries" select code where I am getting the dump that internal table 'it_qmel' cannot be extended more.
if idtl is not initial. select aufnr matnr serialnr into table it_qmel from qmel for all entries in idtl where matnr eq idtl-matnr and serialnr in s_sernr. sort it_qmel by aufnr. delete adjacent duplicates from it_qmel. endif.
Could someone please suggest me, how to optimize the above code so that it uses less memory.
Please help, I need this urgently.