topic Re: multiple logically related Database table(s) transaction control in Application Development and Automation Discussions

multiple logically related Database table(s) transaction control

Balu483 — Mon, 14 Oct 2019 14:01:08 GMT

hi all,

there is a transaction which involves HEADER+Multiple Line Items

when user press save button how to perform a transaction that it should create records in corresponding DB tables

at the end either the complete transaction could successful or fail but not partial.

how can we achieve such case with ACID Database properties

i had searched many SCN posts but still i didn't get the correct one.

so can any one please share a blog or document on it

thanks in advance.

Re: multiple logically related Database table(s) transaction control

GK817 — Mon, 14 Oct 2019 15:15:49 GMT

Hi Bala,

You can keep your INSERT/MODIFY statements in different function modules. You can keep calling these function modules in UPDATE task and then call COMMIT WORK once all validations are passed. Data will be updated at one point only.

You can keep using INSERT/MODIFY statements and use COMMIT WORK / ROLLBACK WORK based on the validation results.

Regards

Re: multiple logically related Database table(s) transaction control

Sandra_Rossi — Mon, 14 Oct 2019 16:02:30 GMT

You know what ACID is, but you didn't find the ABAP statements COMMIT WORK and ROLLBACK WORK?

Re: multiple logically related Database table(s) transaction control

Balu483 — Mon, 14 Oct 2019 17:06:26 GMT

hi Gaurav Karkara,

thanks for your reply. among this two options which one is preferable for industry best standard practices.