topic Re: Issue in locking Table in Application Development and Automation Discussions

Issue in locking Table

Former Member — Tue, 21 Oct 2008 16:29:47 GMT

Hi All,

I need to update a ZTABLE with UNIQUE serial number while creating shipment and Delivery.

I have used ENQUEUE_E_TABLE to lock the table before updating table in both the ZProgram which will update the serial numbers.

The problem is even though i locked the table , i am facing problem with creation of duplicate number serial numbers while shipment and delivery happens at the same time.We have tested this with multiuser environment.

Since both shipment and delivery updating in UPDATE TASK i coudnt use COMMIT WORK in the programs.

Please let me know if there are any tricks how to lock the table and also for using COMMIT WORK inside UPDATE TASK.

Give some example program for locking tables especialy used in update task.

Thanks and Regards,

kandakumar

Re: Issue in locking Table

Former Member — Tue, 21 Oct 2008 16:40:45 GMT

U should lock the table before updating it in UPDATE TASK process, in order to stop the saving if the lock is still active.

Max

Re: Issue in locking Table

Former Member — Tue, 21 Oct 2008 16:42:07 GMT

are you checking for locks before updating the table. SAP locks using lock object is not a physical lock, so unless you check for that and check sy-subrc after check, it will still allow you to update the record

Re: Issue in locking Table

Former Member — Tue, 21 Oct 2008 17:38:03 GMT

Lock the table before updating it and check the locking with sy-subrc and if it is not locked then use do loop to lock the table.

See the dummy code ,hope it will help you.

Do n times.

*Lock the table

*Check sy-subrc if it is 0 exit the loop else

try again.

if locking is suceessfull.

set a flag.

endif.

Enddo.

If flag is not set give the message table is not locked.

else if it is locked then proceed with updation

Cheers

Neha shukla

Re: Issue in locking Table

BH2408 — Tue, 21 Oct 2008 17:44:58 GMT

Hi ,

ENQUEUE_E_TABLE is used to lock the table when ever the Zprogram has run.

when u r editing the table and running the program will give an error .and change the logic part in ur code .. and unlock the table after completion of updation.

regards,

Bharani