locks

[Former Member]

hi all..

what is the difference between E(extensible lock) and X(exclusive lock)?

[Former Member]

HI ,

a f1 on the mode of lock object wil give u the detials of the same .

Thanking You

Rohit Gupta

Reward if helpful .

[Former Member]

Hi,

check this

http://help.sap.com/saphelp_nw04s/helpdata/en/7b/f9813712f7434be10000009b38f8cf/content.htm

Lock Objects

In a system where many users can access the same data, it becomes necessary to control the access to the data. In R/3 system this access control is built-in on database tables. Developers can also lock objects over table records.

To lock an object you need to call standard functions, which are automatically generated while defining the lock object in ABAP/4 dictionary. This locking system is independent of the locking mechanism used by the R/3 system. This mechanism also defines LUW i.e. Logical Unit of Work. Whenever an object is locked, either by in built locking mechanism or by function modules, it creates corresponding entry in global system table i.e. table is locked. The system automatically releases the lock at the end of transaction. The LUW starts when a lock entry is created in the system table and ends when the lock is released.

<b>

Types of locks</b>

You can lock the table or record by using following types of locking:

<b>

Exclusive</b> (E) the locked data can only be displayed or modified by single user i.e the owner of the object. Access to other users is denied.

<b>

Shared (S)</b> several users can access the same record simultaneously, but only in display mode and except the first one, who has asked for the data in update mode.

<b>Exclusive not cumulating (X)</b> it is similar to exclusive lock. It allows only a single user access. E can be called several times from the same transaction. In contrast, a lock type X can be called only once during the transaction. Any other call for this lock is rejected.

<b>Activation of Lock Object</b>

When you activate the lock object, the functions are automatically generated. And these are ENQUEUE-EZN and DEQUEUE-EZN. EZN is name of the lock object.

While ENQUEUE is used in program to set the code over the selected data depending upon the lock object arguments. DEQUEUE is used to release the lock.

While creating you can Select secondary tables, if any, linked by foreign key relationship.Fields for the lock objects. This option allows you to select fields for objects (R/3 system allows locking up to record level). Lock object argument are not selected by user but are imposed by the system and includes all the primary keys for the table.

<b>reward if helpful</b>

pritha

[Former Member]

PRACTICAL KARKE TO BATAYA.....

REWARD IF USEFUL...