topic Commit work issue in Report in Application Development and Automation Discussions

Commit work issue in Report

Former Member — Tue, 04 Oct 2016 09:54:58 GMT

Hi Experts,

I am facing one issue with update of large number of records in custom table.

I am using update statement inside loop of 50K records and than after loop is completed commit work and wait.

Want to know what is best practice to update bulk record of internal table in custom table and does it create any table level lock.

Regards,

Aditya

Re: Commit work issue in Report

Former Member — Tue, 04 Oct 2016 10:13:24 GMT

Use the "FROM TABLE ..." addition of the "UPDATE" statement to update your custom table.

Have a look at the documentation UPDATE dbtab - source - ABAP Keyword Documentation

Edit: I think the first example in provided link does address your problem.

Re: Commit work issue in Report

Former Member — Tue, 04 Oct 2016 13:07:49 GMT

Thanks Andre. so i will be updating from table at a time. How can i update specific fields of data base table with fields of internal table.

Re: Commit work issue in Report

Former Member — Tue, 04 Oct 2016 14:37:41 GMT

There are a lot of ways to do that. So this is also a very Basic question.

Maybe you should post your code snippet here, so that we can help you in a more specific way.

Re: Commit work issue in Report

Former Member — Tue, 04 Oct 2016 16:33:35 GMT

To my knowledge it is not possible to update specific fields of data base table (till 731 - 013). I am not sure whether there is any newer version which allows this.

-Chandra

Re: Commit work issue in Report

Sandra_Rossi — Wed, 05 Oct 2016 02:36:26 GMT

It's possible to update specific fields by creating a DDIC Projection View with only the fields to be updated (+ read/write mode of course). But this is only to be reserved to specific mass updates which are really too slow, otherwise the DDIC would be a mess if "dummy" views are created for all updates!