topic Re: Lock Objects in Application Development and Automation Discussions

Lock Objects

Former Member — Sat, 19 Oct 2013 06:43:00 GMT

Hi All,

i have one query in which i have to put lock object on one table but before implementing that i want to check some specific fields of this table is getting by someone or not

eg. I want to put lock object on ZOTR001 which is getting update through one tcode, in this table there are some fields like Storage location and plant.

so my query is i want to check whether this table is getting update with the same storage location and plant if yes then i want to lock the lock the table otherwise it will allow the user the create otr number and let the user update the table zotr001 by tcode.

Please help!!

Regards,

Deepak kansal

Re: Lock Objects

former_member188827 — Sat, 19 Oct 2013 06:45:38 GMT

You can assign the fields you need to check as lock parameters in lock object (in SE11). Then in your program you can call the relevant lock module(ENQUEUE* FM) to check if the entry is locked by someone.

Regards

Re: Lock Objects

Former Member — Sat, 19 Oct 2013 06:56:00 GMT

Hi,

You are right but the fields that i want to check are not the key fields that is why not displaying in lock paramters in SE11.

Regards,

Deepak kansal

Re: Lock Objects

former_member188827 — Sat, 19 Oct 2013 07:10:25 GMT

Lock parameters can only be the key fields of table.See if you can use foreign key relationship by adding secondary tables in your lock object to get your desired lock arguments. Following link may be helpful:

http://help.sap.com/saphelp_nwpi711/helpdata/en/cf/21eea5446011d189700000e8322d00/frameset.htm

Regards

Re: Lock Objects

Former Member — Sat, 19 Oct 2013 07:13:53 GMT

foreign key relationship is not possible in my case....help if there is any other possibillity

Regards,

Deepak kansal

Re: Lock Objects

former_member188827 — Sat, 19 Oct 2013 07:21:29 GMT

Check the following link:

http://scn.sap.com/thread/308337

Regards