topic ROLLBACK database tables in Application Development and Automation Discussions

ROLLBACK database tables

Former Member — Fri, 29 May 2009 12:05:38 GMT

Hi Friends,

I need some help on Rollback

I have a header table and an Item table

First data is inserted in Header table and then the related item records are updated in Item table

Assume a scenario where the Header records gets updated successfully and the item records

insertion fails for some reason

So in this case the header records should be rolledback , please give some inputs on this

Thanks

Chandra

Edited by: Chandrasekhar Jagarlamudi on May 29, 2009 2:10 PM

Re: ROLLBACK database tables

ThomasZloch — Fri, 29 May 2009 12:18:09 GMT

Your header and item updates would be one LUW (logical unit of work). Once everything is done without errors, you send a COMMIT WORK. Before that, you can use ROLLBACK WORK to undo the changes to the header table, should there be a problem with the items update.

Thomas

Re: ROLLBACK database tables

Former Member — Fri, 29 May 2009 12:21:50 GMT

Thanks Thomas

Can you please let me know how can we make the 2 tables as one LUW as i am new to this

Do we have to maintain it at database level or program level

Thanks

Chandra

Re: ROLLBACK database tables

ThomasZloch — Fri, 29 May 2009 12:25:36 GMT

The keywords I mentioned are ABAP statements, the LUW logic is inside your program code. Check the online help for these keywords in the ABAP editor, it's all being explained there.

Thomas

Re: ROLLBACK database tables

Former Member — Fri, 29 May 2009 12:32:11 GMT

This message was moderated.

Re: ROLLBACK database tables

Firoz_Ashraf — Sun, 31 May 2009 12:40:14 GMT

Hi,

You may write your code in the following fashion:

 
INSERT zhead FROM TABLE i_zhead.
IF sy-subrc EQ 0.
   INSERT zitem FROM TABLE i_zitem.
   IF sy-subrc NE 0.
      ROLLBACK WORK.
   ENDIF.
ENDIF.

Regards,

Firoz.