2010 Aug 05 4:08 PM
I have creaed a custom table with DB locking. And I have a separate program using an Editbale ALV grid to update this table. I have used the ENQUEUE FM created with my DB locks to lcok the table whilst a user is in the transaction. Whcih works fine, but is there any way to find out the user that is locking the table - all the FM returns is a return code of 1 (foreign lock)???
2010 Aug 05 5:03 PM
Hello,
Please check system variables:
sy-msgv1 and sy-msgv2
which should contain user name who is locking the record.
Thanks.
I have creaed a custom table with DB locking. And I have a separate program using an Editbale ALV grid to update this table. I have used the ENQUEUE FM created with my DB locks to lcok the table whilst a user is in the transaction. Whcih works fine, but is there any way to find out the user that is locking the table - all the FM returns is a return code of 1 (foreign lock)???
2010 Aug 05 5:03 PM
Hello,
Please check system variables:
sy-msgv1 and sy-msgv2
which should contain user name who is locking the record.
Thanks.
2010 Aug 05 6:06 PM
Transaction SM12 will show you any active table locks and the user locking them.
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |