Skip to Content
0
Former Member
Jun 26, 2009 at 12:46 PM

Locking transaction from modifying table

101 Views

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