Multiple users to Table maintenance generator

[Former Member]

Hi Experts,

I want to have table maintenance generator, in which multiple user can update table at a time. How can I remove the table lock. Is there any place in SAP, where all the table lock will be. Is it possible to remove the lock by program.

Thanks in advance,

Venkat

[Former Member]

Hai,

using Enqueue/Dequeue function modules.

Dequeue_xxx function module.

xxx is lock object name. goto sm12 and double click on the table name . You will get the lock object name.

Regards,

Venkat

[Former Member]

Hai,

using Enqueue/Dequeue function modules.

Dequeue_xxx function module.

xxx is lock object name. goto sm12 and double click on the table name . You will get the lock object name.

Regards,

Venkat

[former_member404244]

Hi venkat,

This is not suggestable as if two persons accessing same table and same record then there will be problem . for example i have updated a value '1' and the other perosn updated as '2'. I will be expecting '1' to be there but if i see '2' then my data is lost and it is having some other data. Hope you got my point

Regards,

Nagaraj

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

Hi Venkat,

You need to first unlock table level entry, and lock it at row level.

Incase your requirement is to allow write access to only authorised users, then you need to check for authorization at table maintenance events (before displaying and saving ).

Check this link:

http://www. saptechnical. com/Tutorials/ABAP/Lock/Page1.htm

Let me know if you face any issues.

Regards,

Nisha Vengal.