topic Re: How to Implement shared lock in Application Development and Automation Discussions

How to Implement shared lock

Former Member — Wed, 29 Oct 2008 05:03:29 GMT

Hi friends,

For a table I have created views. I want to create shared lock for that table.

How to achieve that.

can we create shared lock for views?

Thanks.

Re: How to Implement shared lock

Former Member — Wed, 29 Oct 2008 06:13:15 GMT

Hi Pagidala,

Go to Se11-> Select Lock object radiobutton->give some name starting with E for example EZDEMO_LOCK->click on Create ->give short description->clcik on Tables Tab->give the table name for which you want to implement shared lock example ZTABLE ->lock mode you select as Read Lock.After this save check and activate your lock object.

We have selected READ LOCK since it protects read access to an object. The read lock allows other transactions read access but not write access to the locked area of the table.

Check the below link for the complete information on Lock Concept.

http://help.sap.com/saphelp_nw04/helpdata/en/41/7af4c5a79e11d1950f0000e82de14a/content.htm

Cheers!!

VEnk@

Edited by: Venkat Reddy on Oct 29, 2008 11:54 AM

Re: How to Implement shared lock

Former Member — Wed, 29 Oct 2008 06:37:00 GMT

Thanks for your reply.

I have created views for that table. Now do we have to create lock for those views

or only for that table?

Edited by: pagidala Ramesh on Oct 29, 2008 12:07 PM

Re: How to Implement shared lock

Former Member — Wed, 29 Oct 2008 06:56:21 GMT

My suggestion is to lock the table i think you might have created maint view, even though you create them giving the table name so table play the major role here. Even though what ever changes or additions that you do will store in table too...so better create the lock for Table.

Cheers!!

VEnk@

Edited by: Venkat Reddy on Oct 29, 2008 12:26 PM

Re: How to Implement shared lock

Former Member — Wed, 29 Oct 2008 07:13:58 GMT

Thanks,

After creating lock object do we need to do any further settings?

My req is to access the data through views, and update the table.

But I am getting "data is locked by user xxxxx", error and is not allowing to go into edit mode. I need to enter into the edit mode of all views at a time.

Do we need to write any prog to enable the lock(Im just going with the view through transaction code. i am not going for any report)?.

Edited by: pagidala Ramesh on Oct 29, 2008 12:50 PM

Re: How to Implement shared lock

Former Member — Wed, 29 Oct 2008 07:24:53 GMT

Currently you remove the lock by t-code SM12.

Definitely if the other person is access the records then data lock will be obvious. Once you consultant your basis guys and explain them how to want the lock modes and all then they might help you.

Cheers!!

VEnk@

Edited by: Venkat Reddy on Oct 29, 2008 12:56 PM