Skip to Content
0
Former Member
Jul 06, 2009 at 04:29 PM

Select single for update not creating lock on entry

177 Views

Hi All,

I want to update an entry from MARA table so what ii did is

select single for update * from mara where matnr = 'ZYS'.

The for update is supposed to create a lock for me and the the lock is released after the commit or roll back.

I'm running this prg in debug mode and after the statment

select single for update * from mara where matnr = 'ZYS''.

I opened MM02 for this material and could change the data which i'm not supposed to be as there is lock on this particular mater from single for update statemnt

or

I even tried from other program

select single * from mara where matnr = 'ZYS'. in debug mode and it returned a sy-subrc eq 0.

and i don't see a lock in SM12 FOR SELECT * FOR UPDATE.....

Can anyone clarify on this

Thanks

David