Skip to Content
author's profile photo
Former Member

LUW in BTE

Hi,

Please let me know how LUW has to be handled in BTE.

Helpful answers will be rewarded.

thanks .

albert.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 02:46 AM

    Hi

    Check this..

    The R/3 system is multi user system and many users access the same information at the same time, which is mainly DATA. Consider the case where one user is modifying a record, and second user is trying to delete the same record. If the second user is successful in deleting the record then the first user will face problem for modifying the record that is already deleted. The avoid such situation, R/3 system has provided Logical Unit of Work, which is defined as a locking mechanism to protect transaction integrity. Of course, there are other measures, which ensures data integrity like check table i.e. foreign key relationship. Within SAP system there are three types of transaction and may be distinguished as:

    • Database transaction known as LUW. It can be defined as a period in which operation requested must be performed as a unit, i.e. all or nothing operation. At the end of LUW, either of the database changes are committed or rolled back.

    • Update transaction or SAP LUW. One SAP LUW can have several databases LUW. So a set of a database is either committed or rolled back. The special ABAP/4 command COMMIT WORK, marks the end of a SAP LUW.

    • ABAP/4 transaction. Is made up of a set of related task combined under one transaction code. ABAP/4 transactions are for programming environment, in which ABAP/4 transaction functions like one complete object containing screens, menus and transaction codes.

    R/3 system has provided in built locking mechanism, which defines the Logical Unit of Work. Also user can set his own locking mechanism. The LUW starts when a lock entry in the system table is created, and it ends when the lock is released.

    To provide the user the facility to communicate with the table in order to modify or delete or insert data, R/3 has provided tool called SCREEN PAINTER. This tool allows you to design screen, process screen through program and update the database table. SAP has provided one and only one way to update the database table, i.e. transaction. Though you can update database table by using open SQL statement through program, SAP usually doesn’t recommend this kind of updating. Many standard transactions are available to update standard table but if the need arises, the developer should be able to develop new transaction, which allows the updating of database tables. This can be achieved by using various components of screen painter.

    Regards

    Anji

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anji,

      Thanks for your response

      But I like to know ,How LUW has to be maintained in BTE.

      whenever a doc is created thru transactn say f-22,the BTE is capturing it to a ztable then the doc is posted to SAP DB.

      Here the LUW ends when the document is posted to SAP DB.

      Now consider the case if the document is not posted to SAP DB and captured in the Ztable.

      Here the LUW of Doc posted to SAP DB has to be handled.

      Please let me know how to do that.

      Thanks

      albert.