Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Locking table

Former Member
0 Likes
607

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
581

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.

4 REPLIES 4
Read only

Former Member
0 Likes
582

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.

Read only

Former Member
0 Likes
581

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.

Read only

0 Likes
581

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

thanks to all...

Read only

hymavathi_oruganti
Active Contributor
0 Likes
581

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