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

[Former Member]

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.

[Mohamed_Mukhtar]

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

[Former Member]

Dont use Background task as it is now obsolete.

[RaymondGiuseppi]

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).

[Former Member]

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)