‎2013 Oct 19 7:43 AM
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
‎2013 Oct 19 7:45 AM
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
‎2013 Oct 19 7:56 AM
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
‎2013 Oct 19 8:10 AM
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
‎2013 Oct 19 8:13 AM
foreign key relationship is not possible in my case....help if there is any other possibillity
Regards,
Deepak kansal
‎2013 Oct 19 8:21 AM