‎2010 Oct 11 1:34 PM
Hi Gurus,
I have a program with a function module "TB_DATAFEED_MODIFY_OICQP"for updating table OICQP for price data.
The function module can be used for mass update but user requirement is in such a way that the error records which are not updated needs to be displsyed in LOG.
So i was using the function module inside the final loop of data and doing the update 1 by 1 and checking SY-SUBRC = 0.
The function module has a ENQUE , DEQUE function inbuilt inside this.
QUESTION: Is there any problem in using a mass update function module in LOOP, but only updating record 1 by 1.
Avi.
‎2010 Oct 11 1:47 PM
‎2010 Oct 11 1:55 PM
Hi,
You will not get any problem while writing that in LOOP.
read it 1 by 1.
Go a head.
Kruthik
‎2010 Oct 11 5:30 PM
Hello,
Well, it all depends on the volume of data, if it is too much, you can eventually have time out problems. If you can, run your program in background, as a job, and at least you will never have a time out.
Best regards.
‎2010 Oct 11 5:54 PM
it's not preferred, but if there is no alternate solution. Calling function module in loop for 100 to 5000 times usually works ok (depending on FM memory handling). If it's complex, usually performance goes on reducing. one can measure time after each call & then see how time taken for each call, goes on increasing.