Lock Object

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

Regards

Sudheer

[Former Member]

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

thanks Sudheer .

regards,

murali

[Former Member]

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