Why always lock data?

[Former Member]

Dear Experts,

I have used one rfc with BDC to supplement wbs budget,with one line data it is ok,but when I use another data it is not ok,I can see lock with transaction code SM12,Who can tell me how to do ?lock table:proj_enq

Best Regards,

Merry

[Former Member]

hi

when u access a record from a table for standard transaction, it locks the entry in sm12,unless u come out of the tcode.

Regards

Sajid

[Former Member]

Can you tell me how can I come out this tcode in ABAP ?

[former_member209217]

Hi Merry,

U need not come out of that TCODE.

Suppose if ur editing any program or if ur Inserting or creating any entries in a table thru SE11 ,others might not be able to do the same because those will be locked under ur userid.

U can come out of the change mode (i.e display mode) to avoid locking under ur userid.Or simply come out of the session,lock will be released.

Suppose if u want unlock any locked object then,

Go the tcode SM12 and press the LIST button available at the top.

Just u will get the list of objects that are currently locked and in use by other user.

Select the one and press the delete button .The lock will be deleted once u confirm the same.

Regards,

Lakshman.

[Former Member]

Dear Merry,

Suppose user A is changing a PO ie., in tcode me22 then in sm12 u can see that there would be a record which shows that it is locked by user.

When user A comes out of me22 tcode (ie., after he made the changes he may save and click on back button) then it unlocks automatically.

But in sm12, u can unlock forcefully by deleting that particular record.But this is not recommended unless its necessary.

Regards

Sajid

[Former Member]

Thank you