Database table protection or lock

[mucsiattila]

Hello!

I need to protect a DB table from writing when my program in running. I have tried CF 'ENQUEUE_E_TABLE' and custom locks also, but these only work if the other programs do check the lock. If other programs start to insert/update/delete the table without checking the lock, they are executed with no errors or warnings. I tested it several times and checked in SM12 if the lock exists. So i need a solution to permanently protect the table from any writing, except the one that I executing.

Thanks in advance.

[RaymondGiuseppi]

If those (dirty) programs don't use any SAP lock concept, then (alas) you have to lock data at database level.

• Consider using AMDP - Methods for Setting locks.
• You'll probably also need to use them to update records.

If there are not too many such programs, better correc those to use SAP Locks