Commit work issue in Report

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Sandra_Rossi]

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!