Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

begin transaction & end transaction

Former Member
0 Kudos

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.

2 REPLIES 2

Former Member
0 Kudos

Former Member
0 Kudos

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...