topic Re: Locking transaction from modifying table in Application Development and Automation Discussions

Locking transaction from modifying table

Former Member — Fri, 26 Jun 2009 12:46:44 GMT

Hi All,

We have a transaction. This transaction is used to modify the data in certain tables. Currently multiple users can open the transaction in 'Change Mode'. We have to put a lock if one 'Change Mode' is open for transaction, it should say other new users that they can't modify it and open in display mode.

We thought of following strategy:

1. Create lock object for each corresponding to each table.

2. Call Enqueue Function Modules in PBO of different screens used in transaction.

Now problem is that once user is leaving the transaction he/she should dequeue it. We can do it by calling Dequeue FMs corresponding to 'BACK/EXIT/CANCEL' buttons. But can't think how to handle the scenario if user presses '/n'.

You can also suggest any other way of handling the issue as well.

Regards,

Ashwini

Re: Locking transaction from modifying table

Former Member — Fri, 26 Jun 2009 13:07:43 GMT

Hi,

If the user exits by choosing /n the locks are released.

You can check this yourself, go into any transaction that opens a lock, then view the lock in SM12. Now, close the first transaction with /n and refresh the list in SM12. The locks have gone.

Regards,

Nick

Re: Locking transaction from modifying table

Former Member — Fri, 26 Jun 2009 13:35:55 GMT

Hi,

The locks releases are dependent on the scope parmeter which you are passing ot the ENQUEUE_FUNCTION module.

There are this parameter can have 3 values 1,2,3.

We need to pass correct value depending on your requirement.

If you are updating all the tables in the same program which you are using to displaying the transaction go for scope parameter 1. So the lock will get released automatically when you end the transaction.

If you use some function module at update task then use the scope parameter 2. In such case you need to end it after updation using DEQUQE_<lock object> FM.

Generally locks will get released once the transaction got ended by /n. You can check that in T code SM12. after coming out of transaction. No need of Dequeue FM in such case.

Thanks

Kiran.

Edited by: kiran Pasala on Jun 26, 2009 3:36 PM

Edited by: kiran Pasala on Jun 26, 2009 3:38 PM