Showing posts with label lock. Show all posts
Showing posts with label lock. Show all posts

Tuesday, March 6, 2012

SAP's Lock Concept


In an Update request the data is changed for an entire SAP LUW (Logical Unit of Work), which are either carried out in full or not al all. An LUW can consist of multiple Transaction screens. So LUW can modify and update data consisting in multiple database objects (rows and tables), i.e. SAP’s LUW can result changes in many database objects. Sometimes only a few fields might be affected, so it might be required to lock only those affected fields, while rest of the fields can be used by other users. So therefore SAP has come out with its own Lock Concepts which can lock an object. An object in turn can lock a series of Database objects spread over many row and tables in the database level. Eg. When a User Master data is modified the data may affect more then one table in the Database Level, but Database can lock only at record level or a table level on one table. But SAP Locks will lock the entire object which could be spread over rows in all the affecting (here two) tables. The database lock exists only for the duration of the database LUW, in which the changes made in the SAP system are actually updated. And the SAP Lock is released once the LUW is commited or rolled back when the LUW is cancelled.

Why two different Enqueue Services for Java and ABAP.
Since SAP uses two separate schemas at the database, one each for ABAP and Java Stack. Data is saved is separately for ABAP and Java Stack. So enqueue process (locked objects) for Java would not interfere with the enqueue process (locked Objects) of ABAP stack.

Monday, July 4, 2011

How to Lock / Unlock Client on SAP System

Step by step procedure.

Here i am writing the procedure to lock amd unlock a client in SAP,very rarely we need to use it..But stil u should know so follow these simple steps...


1) To lock or unlock a client in R/3 System, run the following function modules in

transaction se37

2. SSCR_LOCK_CLIENT ( to lock the client)
3. SSCR_UNLOCK_CLIENT (to unlock the client)

Run these functions with a client input which is to be locked/unlocked. This function set flag '' Client is locked temporarily for client copy" in client maintenance menu.The client will be available for users DDIC and SAP*. If any other user tries to login, system gives message that ' Client locked temporarily'.


To unlock the client

1. Run transaction SE37
2. Enter the function module as SSCR_UNLOCK_CLIENT
3. press F8 or test run (single run).
4. Specify the client and execute(F8).

Follow similar procedure for locking the client...