topic Re: Locking table in Application Development and Automation Discussions

Locking table

Former Member — Fri, 03 Feb 2006 10:19:39 GMT

Hi All,

I'm updating a table and i have to lock the table. I have to use a enqueue for that if im not wrong. which enqueue and dequeue should i use...can somebody help me with this.

thanks,

kiran.

Re: Locking table

Former Member — Fri, 03 Feb 2006 10:32:13 GMT

Hello Kiran,

There are two ways you can work this..

1. u can look for a lock objects for the table in SM37.

2. use FM ENQUEUE_E_TABLE where u can specify table name if u r not sure if end and deq objects exists.

Once u find the end & deq Fm u them in the program to lock and unlock.

Re: Locking table

Former Member — Fri, 03 Feb 2006 10:33:41 GMT

hi,

You have to mention the lock object name for that table.

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

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.

Regards,

Sailaja.

Re: Locking table

hymavathi_oruganti — Fri, 03 Feb 2006 10:36:16 GMT

create lock objects with naming convention ez or ey.

once they are activated they generate fn modules,

enqueue_<lockobjectname> and dequeue_<lockobjectname>.

u call these from ur program.

while debugging only u can set lock

Re: Locking table

Former Member — Fri, 03 Feb 2006 10:42:33 GMT

im trying these with ur help. ill get back when i need some help.

thanks to all...