topic Re: Lock Object in Application Development and Automation Discussions

Lock Object

Former Member — Thu, 01 Feb 2007 17:39:14 GMT

Hi Experts,

we have a transaction Code Zxo09 this Report Changes the address of the storage location of a particular plant.now the problem is

suppose i execute the program with plant =1400 and Storage location =1000

i get the edit option and after clicking on the edit push button.ie now we can edit...

now let us open another session and run the same program entering DIFFERENT plant and DIFFERENT storage location . wht it say' s is it gives a pop up window say 'use xxx is locked" which should not happen.

in fact there is a table xxx which is getting updated .ie the table is locked.

i don't know the solution but friend say , the TABLE LEVEL LOCKING HAS TO BE BROUGHT DOWN TO RECORD LEVEL LOCKING.

but i don't know how to do that ??

lock mode is :E

please suggest some thing it's very urgent

Regards,

Murali g.s.a

Re: Lock Object

Former Member — Thu, 01 Feb 2007 17:42:19 GMT

Hi,

If you are updating configuration entries..or SM30..It will lock the whole table..Which means only one user can update the table..

This is the disadvantage of using SM30 for maintaining entries..

Solution could be to create a custom transaction that will give access to record by record...

Thanks,

Naren

Re: Lock Object

Former Member — Thu, 01 Feb 2007 17:42:23 GMT

Hi,

Just change the Lock mode to SHARED i mean S mode and do that

Regards

Sudheer

Re: Lock Object

Former Member — Fri, 02 Feb 2007 04:52:17 GMT

Hi,

It seems in the report, you have locking all enties in the table using lock object.

so try to lock only the particular plant and sotrage location, by passing values to lock obejct (FM).

let me know if is not working well.

Regards

Nagaraju

nagaraju.pnr@rediffmail.com

Re: Lock Object

Former Member — Fri, 02 Feb 2007 09:02:27 GMT

HI Naren,

u r solution i think will slove my problem , but , i don't know how to lock the object at record level can u please guide me.

with creating f.m and so on ........... i know it's bit tedious but please.........

Many Thanks for your answer hope this support continues till the problem get's solved.

murali

Re: Lock Object

Former Member — Fri, 02 Feb 2007 09:32:42 GMT

hi Naren,

i think the problem is getting cleared wht u said is correct.

they are two maintainance view tables which are doing this job.

now wht i want to know is if i develop a customised f.m

if will not effect the data mainatined in SM30.

awaiting for your reply,

Murali

Re: Lock Object

Former Member — Fri, 02 Feb 2007 14:52:39 GMT

It looks the problem is solved with a simple change from E to S.

thanks Sudheer .

regards,

murali