Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to lock a database Z table before updating it through a report program

Hi,

How to lock a database Z table before updating it through a report program and also how to unlock it after my updation.

The whole process is done through report program.

Former Member
Former Member replied

Hi,

Go to SE11, in the option 'Lock object' enter the name of your lock,

begin with 'E', suppose 'EXXXX' And create. In tab 'Tables' fill the

table name where the record you want to lock exist and select the

lock mode. Lock mode can be shared and exclusive. If 'shared',

when you lock the record, other can also read data, but can not

modify. If 'exclusive', when you lock the record, other can neither

read nor modify the record. After save and activate, you will get two

function module.'ENQUEUE_EXXXX' to lock record,

'DEQUEUE_EXXXX' to release lock on one record.

When use this function module it only lock one record at a time. It

does not lock the table.

Regards,

Omkaram.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question