topic Re: table locking ?? in Application Development and Automation Discussions

table locking ??

Former Member — Mon, 14 Jul 2008 16:54:45 GMT

Hi,

I have a couple of custom tables and many users are going to deal with a custom transaction which will be using these tables. Simultaneous access is possible. I have to handle table locking issues ? What are the issues and what are the best ways to handle the same ? Please suggest.

thks

Re: table locking ??

Former Member — Mon, 14 Jul 2008 16:57:24 GMT

Hi,

Create lock objects for the tables in SE11..Then use the enqueue function module to lock the record and dequeue function module to unlock the record..

The Dequeue and enqueue function modules will be automatically generated when the lock object is activated in SE11.

Check the standard sap help to create lock objects

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eef3446011d189700000e8322d00/content.htm

Thanks

Naren

Re: table locking ??

Former Member — Mon, 14 Jul 2008 17:00:54 GMT

Hi Friend,

We can use the function modules ENQUEUE_E_TABLE for locking tables and the function module DEQUEUE_E_TABLE for unlocking tables. With this method, we don't need to lock objects in order to lock the tables. In other words, any table can be locked/unlocked using these function modules.

Check this sample code:

*Locking Table*

data:

varkey like rstable-varkey.

varkey = sy-mandt.

locking the tables............................

call function 'ENQUEUE_E_TABLE'

exporting

MODE_RSTABLE = 'E'

tabname = 'MARA'

varkey = varkey

X_TABNAME = ' '
X_VARKEY = ' '
_SCOPE = '2'
_WAIT = ' '
_COLLECT = 'X'

exceptions

foreign_lock = 1

system_failure = 2

others = 3

case sy-subrc.

when 1.

message i184(bctrain) with 'Foreignlock'.

when 2.

message i184(bctrain) with 'system failure'.

when 0.

message i184(bctrain) with 'success'.

when others.

message i184(bctrain) with 'others'.

endcase.

unlocking the table

call function 'DEQUEUE_E_TABLE'

exporting

MODE_RSTABLE = 'E'

tabname = 'MARA'

varkey = varkey

X_TABNAME = ' '
X_VARKEY = ' '
_SCOPE = '3'
_SYNCHRON = ' '
_COLLECT = ' '

Hope this helps you.

Regards,

Chandra Sekhar