logical unit of work

[Former Member]

Hi all,

Can help me regarding LUW(logical unit of work) and its importance in r/3 ?

Thanks and Regards

Ravi

[Former Member · Accepted solution]

Hi,

Take a look ...

http://help.sap.com/saphelp_46c/helpdata/en/a5/3ec8654ac011d1894e0000e829fbbd/content.htm

Its nothing but seggregation of your transactions between two commits/rollback.

Regards,

Ravi

Note : please mark the helpful answers

[former_member927251]

Hi,

Have a look at this.

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/41/7af4bfa79e11d1950f0000e82de14a/content.htm">LUW</a>

Please mark helpful answer.

Regards,

Amit Mishra

[Former Member]

Hi,

A logical unit consisting of dialog steps, whose changes are written to the database in a single database LUW is called an SAP LUW. Unlike a database LUW, an SAP LUW can span several dialog steps, and be executed using a series of different work processes. If an SAP LUW contains database changes, you should either write all of them or none at all to the database. To ensure that this happens, you must include a database commit when your transaction has ended successfully, and a database rollback in case the program detects an error. However, since database changes from a database LUW cannot be reversed in a subsequent database LUW, you must make all of the database changes for the SAP LUW in a single database LUW. To maintain data integrity, you must bundle all of you database changes in the final database LUW of the SAP LUW.

rgds,

Latheesh

[Former Member]

Hai Ravi Charan

There are 3 types of LUW's available in SAP

1)Database Transaction or DBLUW

2)SAP Transaction or SAPLUW

2)ABAP Transaction or ABAPLUW

1) DBLUW : when it is called it locks the rows , Update the rows & commit the rows issued by auto Commit

2) SAPLUW : collection of Business reports is called SAPLUW and Issuing the Commit

here UPDATE,INSERT,MODIFY statements are valid

Commit work is given by Developer Side.

3) ABAPLUW : What ever Transaction Code we are creating is called ABAPLUW it is belongs upon Developers

here 3 types of updates available

1) Bundled Updates

2) Un-Bundled Updates

1) Bundled Updates :

in Bundled Updates all your updates in a single unit of work present in a PERFORM 'XYZ'

PERFORM 'XYZ' on Commit.

here PERFORM-kept in Buffer 'XYZ' this form having all your update statements

Priarities of execution.

Perform xy on comit it will execute first

perform ab on comit it will execute second

I want to change this execution Order

Perform xy on comit Level 2 it will execute second

perform ab on comit Level 1 it will execute First

because it will depends on Level command

Using in Function Modules

Call Function XYZ in Update Task.

--

---

Commit work.

In this case it stores in a buffer once encounters the commit statement this will executes from the buffer

so it is an asynchronos method

2) Un Bundled Updates

these are two types

1) Inline Updates

2) Buffered Inline Updates

1) Inline Updates : INSERT,UPDATE

when update statement found in a program then it is called inline update and you should give the 'commit work'after a update statement

inthe inline update if you not issue a commit work the system will automatically issues the commit work.

2) Buffered Inline Updates:

you will buffer all your inline updates and executes after Encounter the 'COMMIT WORK'

100

XYZ --> we can not roll back here

200

ABC---> if here is using commit

Thanks & Regards

Sreenivasulu P

[Former Member]

Hi

A database LUW is an inseparable sequence of database operations. The contents of the database must be consistent at its beginning and end. The beginning and end of a database LUW are defined by a commit command to the database system (database commit). During a database LUW, that is, between two database commits, the database system itself ensures consistency within the database. In other words, it takes over tasks such as locking database entries while they are being edited, or restoring the old data (rollback) if a step terminates in an error.

Regards,

Tanveer.

Please mark helpful answers