Record level locking for custom table

[Former Member]

Hi All,

My requirement is i have to update the custom table, but when iam locking the table, some times if the user opens the table and try to isert the records its failing.

So i need to create the record level locking for the table.

Please suggest me how to create the record level locking for Custom table.

Thanks in advance

Regards,

Sreehari

[Former Member]

Hi All,

My requirement is i have to update the custom table, but when iam locking the table, some times if the user opens the table and try to isert the records its failing.

So i need to create the record level locking for the table.

Please suggest me how to create the record level locking for Custom table.

Thanks in advance

Regards,

Sreehari

[former_member195698]

Instead of updating the table through SM30. Create a Custom Z program for Updating the table. Create a Lock Object on the Table to Achieve Row level locking.

User has to select the Row to Edit the data.

Regards,

Abhishek

[Former Member]

Hello,

You can create a custom lock object and use Enqueue/Dequeue functions. Otherwise, you may use the function:

call function 'ENQUEUE_E_TABLE'

exporting

mode_rstable = 'E'

tabname = <Table Name>

varkey = <Varkey - Concatenated key fields>

_scope = '3'

exceptions

foreign_lock = 1

system_failure = 2

others = 3.

Thanks,

Venu

[Former Member]

create lock objects in se11 for the custom table .

this will create 2 fms ENQUEUE_<lockobjname> and DEQUEUE_<lockobjname>. when you call the ENQUEUE_<lockobjname> FM, pass all the key fields so as to perform a record level lock.

hope this helps.

Thanks,

Balaji