Problem in collect statement

Former Member — Thu, 05 Aug 2010 06:01:00 GMT

hi,

I am using Collect staement into an internal table for calculating total from General Ledger Details.which is having arround 60000 records. This loop Statement taking more time.For improveing the performance for the particular loop statment what should i do?..

LOOP AT LT_FAGLFLEXT INTO LS_FAGLFLEXT .

CLEAR : GV_MESSAGE , GV_PERCOUNT.

GV_MESSAGE = TEXT-023. "' Calculating totals from General Ledger Details'.

PERFORM PROGRESS_INDIACTOR USING GV_PERCOUNT GV_MESSAGE .

COLLECT LS_FAGLFLEXT INTO LT_COLLECT_FAGLFLEXT.

CLEAR LS_FAGLFLEXT .

ENDLOOP.

Thanks & Regards

Shubh

Re: Problem in collect statement

Former Member — Thu, 05 Aug 2010 06:14:17 GMT

Hi Shubh,

I don't think that the problem is with collect statement. I didn't see that there is any change in the parameters GV_PERCOUNT and GV_MESSAGE passed to the routine PROGRESS_INDIACTOR. So you can call this perform outside the loop which will increase the performance a lot.

Let me know if the problem still persists.

Thanks,

Kiran.

topic Problem in collect statement in Application Development and Automation Discussions

Problem in collect statement

Re: Problem in collect statement