lock object

[Former Member]

hi gurus......

locking a table means , is it locking all the fields or just the key fields?

[RichHeilman]

It is locking the record based on the key fields. Not locking the actual fields of the row, but the entire row based on its keys.

Regards,

Rich Heilman

[Former Member]

hi Rich Healman....

thanks for the reply , could u plz explain me little bit....

[Former Member]

check here..

http://help.sap.com/saphelp_nw70/helpdata/en/a2/3547360f2ea61fe10000009b38f839/content.htm

[Former Member]

It is locking the record based on the key fields in that table.

when evevr we lock the object system automatically creates function modules.

with names ENQUEUE_LOCKOBJECTNAME.

DEQUEUE_LOCKOBJECTNAME.

[vinod_vemuru2]

Hi Diana,

It depends on how u created the lock object. When u create a lock object for the table u have to give the parameters based on which u want to lock. So when u call Enqueue FM u can see these parameters as input. If u don't pass any key by default it locks the whole table. If u pass the fields based on which u want the lock then only those records will be locked.

eg: Take example of VBAP where vbeln and posnr are the keys. When u lock the table based on vbeln all items will be locked. If u pass both vbeln and posnr only this line item record will be locked.

Hope it is clear.

Thanks,

Vinod.

[Former Member]

Hi Daina,

Check these links:

http://help.sap.com/saphelp_nw04/Helpdata/EN/7b/f9813712f7434be10000009b38f8cf/content.htm

http://searchsap.techtarget.com/tip/1,289483,sid21_gci858655,00.html

Regards,

Chandra Sekhar

[Former Member]

Hi Friend ,

Lock objects are use in SAP to avoid the inconsistancy at the time of data is being insert/change into database.

SAP Provide three type of Lock objects.

- Read Lock(Shared Locked)

protects read access to an object. The read lock allows other transactions read access but not write access to

the locked area of the table

- Write Lock(exclusive lock)

protects write access to an object. The write lock allows other transactions neither read nor write access to

the locked area of the table.

- Enhanced write lock (exclusive lock without cumulating)

works like a write lock except that the enhanced write lock also protects from further accesses from the

same transaction.

You can create a lock on a object of SAP thorugh transaction SE11 and enter any meaningful name start with EZ Example EZTEST_LOCK.

Use: you can see in almost all transaction when you are open an object in Change mode SAP could not allow to any other user to open the same object in change mode.

Example: in HR when we are enter a personal number in master data maintainance screen SAP can't allow to any other user to use same personal number for changes.

Technicaly:

When you create a lock object System automatically creat two function module.

1. ENQUEUE_<Lockobject name>. to insert the object in a queue.

2. DEQUEUE_<Lockobject name>. To remove the object is being queued through above FM.

You have to use these function module in your program.

Hope this will give a basic idea.

Girish

[matt]

http://www.sap-img.com/abap/type-and-uses-of-lock-objects-in-sap.htm