topic Re: record locking in Application Development and Automation Discussions

record locking

Former Member — Mon, 26 Feb 2007 14:56:47 GMT

Hello,

I am studying the locking concept. Can anyone tell me how can I lock a single record of a table? I found examples how to lock an entire table, but I need to lock at record level. Thank you!

Re: record locking

RichHeilman — Mon, 26 Feb 2007 14:59:49 GMT

You can use lock objects. You simply create a lock object in SE11, this creates two function modules automatically, ENQUEUE_<lock object name> and DEQUEUE_<lock object name> . You use the ENQUEUE function module to lock the record, by simply passing the key values of the record to the function module.

Regards,

Rich Heilman

Re: record locking

Former Member — Mon, 26 Feb 2007 15:01:11 GMT

Hello,

Check this thread:

http://www.sapdevelopment.co.uk/dictionary/lock_enqueue.htm

In the enqueue Fm you could metion the value of the keyfield of the table. Which will lock only one record.

Vasanth

Re: record locking

Former Member — Tue, 27 Feb 2007 08:44:44 GMT

Anyone knows why am I beeing asked for an access key when I am trying to create a lock object starting with Z or E (as the system requires) ? I have developer role.

Thank you!

Re: record locking

Former Member — Tue, 27 Feb 2007 08:46:43 GMT

Sorry for this post

Message was edited by:

George Popescu

Re: record locking

Former Member — Tue, 27 Feb 2007 08:50:59 GMT

hi,

i am able to create the lock object.. starting with EZ...

no problem.

regards,

pankaj singh