Is it ok to have two (or more) commits in one report?
I've got a question about 2 (or even more) commits in report.
Here's my situation:
I am calling BAPI, that modifies database table, e.g. BKPF. Later on I need that new data, so right after calling BAPI I use BAPI_TRANSACTION_COMMIT. Then I use that new data to modify my Z dbtab, so after that I use COMMIT WORK statement.
As I am aware commit statement puts a temporary lock on table which is currently used, so no one else can use it.
Is it ok to use many commits in one program? Or are there any "good behaviours" about using commits?
Also second question. Does MODIFY dbtab FROM wa statement include any commits? I had a situation, when after using that statement on my Z table (without any commits after) it actually modified content of my table.
Thanks for all your answers.