topic Re: How to Lock a data base table for write access. in Application Development and Automation Discussions

How to Lock a data base table for write access.

Former Member — Tue, 07 Jul 2009 09:02:48 GMT

Hi All,

I have a requirement where in I have to insert a bunch of data into a standard table using some function module. I want to lock the table for the others to insert/modity the records during my insertion. Please help me provide the procedure how to lock a table for write access for others.

thanks and regards,

Naresh

Re: How to Lock a data base table for write access.

Former Member — Tue, 07 Jul 2009 11:29:39 GMT

Hi,

Activating a lock object in the ABAP Dictionary automatically creates function modules for setting (ENQUEUE_<lock object name>) and releasing (DEQUEUE_<lock object name>) locks.

then you can use the ENQUEUE_<lock object name> in program or FM for locking the table.

A lock object is first need to be created between table which are used.

Manish

Re: How to Lock a data base table for write access.

Former Member — Tue, 07 Jul 2009 13:52:48 GMT

Hi Manish,

Thanks for your update. But I already tried it. In that process I can only lock the table for a particalar entry each time. But I want to lock the table for a bunch of entries at a single shot. Because I am doing a mass update.

thanks and regards,

Naresh

Re: How to Lock a data base table for write access.

Former Member — Tue, 07 Jul 2009 14:05:56 GMT

Hi,

Try function Module 'ENQUEUE_E_TABLE' and 'DEQUEUE_E_TABLE'.

Regards,

Himanshu Verma

Re: How to Lock a data base table for write access.

Former Member — Tue, 07 Jul 2009 14:11:25 GMT

Hi Naresh,

When you say "the others to insert/modity the records during my insertion", you need to determine how those other change the table and find the lock object that uses (transaction SM12). If that locks entries in the table individually, that's what you might have to do.

Regards,

Nick

Re: How to Lock a data base table for write access.

Former Member — Tue, 07 Jul 2009 14:34:05 GMT

Hi Verma,

what should be passed to VARKEY. If possible can you please give me an axample.

thanks,

Naresh

Re: How to Lock a data base table for write access.

Former Member — Tue, 07 Jul 2009 14:51:30 GMT

Hi,

VARKEY is an optional parameter this is used is you want to lock the table based on certain field values like if you want to lock BKPF based on company code then you ahve to pass that to this variable if you want to lock table irrespective of any vlaues you can just pass the table name to this function module and that should do the trick...

Regards,

Himanshu Verma

Re: How to Lock a data base table for write access.

Former Member — Wed, 08 Jul 2009 04:31:44 GMT

Hi,

If you want to apply for bunch of records , you can use loop for it .

LOOP.

" some processing

PERFORM lock record. " ENQUEUE

" some processing again

APPEND record TO update_table.

ENDLOOP.

Thanks

Manish

Re: How to Lock a data base table for write access.

Former Member — Thu, 09 Jul 2009 12:02:59 GMT

Hi,

Please go to this link.It may help you.

http://help.sap.com/abapdocu/en/ABENDB_LOCK.htm

Rewsrd if helpful.

Thanks,

Re: How to Lock a data base table for write access.

Former Member — Thu, 09 Jul 2009 12:48:52 GMT

Hi,

See to this link it may help you.

http://help.sap.com/saphelp_47x200/helpdata/en/af/22ab01dd0b11d1952000a0c929b3c3/frameset.htm