*SAP luw *& *Database LUW*

[Former Member]

pls ..tell me about

sap luw and database luw

[Former Member]

Hi,

LUW or Database LUW or Database Transaction ::

• A “LUW” ( logical unit of work ) is the span of time during which any database updates must be performed .

Either they are all performed ( committed ) , or

they are all thrown away ( rolled back ).

LUW ( or “database LUW” or “database transaction” )

This is the set of updates terminated by a database commit. A LUW lasts, at most, from one screen change to the next

( because the SAP system triggers database commits automatically at every screen change ).

LUWs help to guarantee database integrity. When an LUW has been successfully concluded, the database is once again in a correct state. If, however, an error occurs within an LUW, all database changes made since the beginning of the LUW are canceled and the database is then in the same state as before the LUW started.

An LUW begins :::::::::::::

• Each time you start a transaction

• When the database changes of the previous LUW have been confirmed (database commit) or

• when the database changes of the previous LUW have been cancelled (database rollback)

An LUW ends ::::::::::::::::

- When the database changes have been confirmed (database commit) or

- When the database changes have been canceled (database rollback)

SAP LUW or Update Transaction :::::::

- Update transaction ( or “SAP LUW”)

This is a set of updates terminated by an ABAP/4 commit. A SAP LUW may last much longer than a database LUW, since most update processing extends over multiple transaction screens.The programmer terminates an update transaction by issuing a COMMIT WORK statement.

An SAP LUW is a logical unit consisting of dialog steps, whose changes are written to the database in a single database LUW.

In an application program, you end an SAP LUW with either

the COMMIT WORK or ROLLBACK WORK statement.

An SAP transaction is an application

program that you start using a transaction code. It may contain one or more SAP LUWs.

Whenever the system reaches a COMMIT WORK or ROLLBACK WORK statement that is not at the end of the last dialog step of the SAP transaction, it opens a new SAP LUW.

Regds

Sivaparvathi

Please reward points if helpful..

[Former Member]

thank u for ur detailed explanation...

[kamireddy_harsha]

Use full answer.............

[Kanagaraja_L]

BD LUW

When it is called it locks the rows , Update the rows & commit the rows issued by auto Commit.

SAPLUW

Collection of Business reports is called SAPLUW and Issuing the Commit like UPDATE,INSERT,MODIFY statements are valid Commit work is given by Developer Side.

Kanagaraja L