topic Re: begin transaction & end transaction in Application Development and Automation Discussions

begin transaction & end transaction

Former Member — Tue, 03 Mar 2009 08:29:33 GMT

Hi Friends,

I want to insert two SAP tables.

BEGIN TRANSACTION.
INSERT TABLE A.
INSERT TABLE B.
END TRANSACTION.

Normally, in SQL when i do my desire between "begin transaction" and "end transaction" code blocks, these are thougt as atomic operations. If a record inserted A and processes killed after this inserting so insert B is not operated, then the insert of table A is rollbacked.

I need to this operation in SAP. How can I do?

Thanks.

Re: begin transaction & end transaction

Former Member — Tue, 03 Mar 2009 08:33:07 GMT

hi,

http://www.rwj.dk/transaction.jpg

thanks

Re: begin transaction & end transaction

Former Member — Tue, 03 Mar 2009 09:20:36 GMT

Hi,

This is called as SAP LUW or transaction.

We need to bundle all the update to the databases in one DB LUW so that it can be rolled back together in case of any update fails.

There are several options to do so:

1. PERFORM ... ON COMMIT.

2. CALL FM ... IN UPDATE TASK

You may want to refer to this link: [http://help.sap.com/saphelp_nw04/helpdata/EN/41/7af4bfa79e11d1950f0000e82de14a/content.htm]

Regards,

Lim...