topic Using Function Module in a Loop in Application Development and Automation Discussions

Using Function Module in a Loop

Former Member — Mon, 11 Oct 2010 12:34:03 GMT

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.

Re: Using Function Module in a Loop

former_member404244 — Mon, 11 Oct 2010 12:47:35 GMT

Hi,

I don't see any problem in that.

Regards,

Nagaraj

Re: Using Function Module in a Loop

former_member1125862 — Mon, 11 Oct 2010 12:55:43 GMT

Hi,

You will not get any problem while writing that in LOOP.

read it 1 by 1.

Go a head.

Kruthik

Re: Using Function Module in a Loop

mrio_espinheira — Mon, 11 Oct 2010 16:30:11 GMT

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.

Re: Using Function Module in a Loop

Former Member — Mon, 11 Oct 2010 16:54:38 GMT

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.