topic Re: lock object in Application Development and Automation Discussions

lock object

Former Member — Thu, 14 Aug 2008 17:49:13 GMT

hi gurus......

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

Re: lock object

RichHeilman — Thu, 14 Aug 2008 17:51:28 GMT

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

Re: lock object

Former Member — Thu, 14 Aug 2008 17:54:00 GMT

hi Rich Healman....

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

Re: lock object

Former Member — Thu, 14 Aug 2008 18:07:20 GMT

check here..

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

Re: lock object

Former Member — Sat, 16 Aug 2008 09:04:18 GMT

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.

Re: lock object

vinod_vemuru2 — Sat, 16 Aug 2008 14:27:01 GMT

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.

Re: lock object

Former Member — Mon, 18 Aug 2008 05:15:58 GMT

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

Re: lock object

Former Member — Mon, 18 Aug 2008 05:47:42 GMT

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

Re: lock object

matt — Mon, 18 Aug 2008 08:47:07 GMT

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