03-03-2009 8:29 AM
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.
03-03-2009 8:33 AM
03-03-2009 9:20 AM
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...