topic Re: Why always lock data? in Application Development and Automation Discussions

Why always lock data?

Former Member — Thu, 09 Jul 2009 04:34:13 GMT

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

Re: Why always lock data?

Former Member — Thu, 09 Jul 2009 05:10:05 GMT

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

Re: Why always lock data?

Former Member — Thu, 09 Jul 2009 06:30:06 GMT

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

Re: Why always lock data?

former_member209217 — Thu, 09 Jul 2009 06:36:05 GMT

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.

Re: Why always lock data?

Former Member — Fri, 10 Jul 2009 05:07:48 GMT

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

Re: Why always lock data?

Former Member — Mon, 13 Jul 2009 07:56:21 GMT

Thank you