topic Re: COMMIT WORK in a separate LUW from my program so that it does not effect the main program? in Application Development and Automation Discussions

COMMIT WORK in a separate LUW from my program so that it does not effect the main program?

Former Member — Wed, 06 Dec 2017 07:48:05 GMT

How can I do COMMIT WORK in a separate LUW from my program so that it does not effect the main program? Actually I am updating the BI system with my sales data using the Function /DMF/BI_SALES_DATA. In the main program we are fetching the sales data using the FETCH CURSOR. Now my requirement is to set the the commit after each fetch.

Re: COMMIT WORK in a separate LUW from my program so that it does not effect the main program?

Mohamed_Mukhtar — Wed, 06 Dec 2017 08:13:53 GMT

Hi,

Call the FM /DMF/BI_SALES_DATA (if it is RFC) in background task.

ABAP Documentation - Call Function in background task

Hope it helps.

Thanks

Re: COMMIT WORK in a separate LUW from my program so that it does not effect the main program?

RaymondGiuseppi — Wed, 06 Dec 2017 15:35:48 GMT

Consider call of the FM (or a RFC enabled wrapper) STARTING NEW TASK. Also in the OPEN CURSOR statement use the WITH HOLD option (to protect it against implicit database commit).

Re: COMMIT WORK in a separate LUW from my program so that it does not effect the main program?

Former Member — Wed, 06 Dec 2017 17:01:43 GMT

Dont use Background task as it is now obsolete.

Re: COMMIT WORK in a separate LUW from my program so that it does not effect the main program?

Former Member — Wed, 06 Dec 2017 17:03:20 GMT

I am not sure but why you need a Commit after fetching?

Second you can call your FM in a new task and there perform the Commit(new task will not affect your main program)