topic Re: delete the lock in Application Development and Automation Discussions

delete the lock

Former Member — Fri, 16 Feb 2007 06:10:14 GMT

how to delete the lock

Re: delete the lock

Former Member — Fri, 16 Feb 2007 06:13:14 GMT

Have a look at below link.<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/37/a2e3b4344411d3acb00000e83539c3/frameset.htm">Deleting Lock Entries</a>

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: delete the lock

Former Member — Fri, 16 Feb 2007 06:13:41 GMT

What lock??

Table lock or session locked??

if it for session locked go to sm12...

if it for table then look enque and deque FM

Thanks

Re: delete the lock

Former Member — Fri, 16 Feb 2007 06:15:04 GMT

Hi,

Using SM12 transaction you can delete LOCK entries

Or You can use DEQUEUE related function modules to Unlock Table in the program.

Regards,

Anji

Re: delete the lock

Former Member — Fri, 16 Feb 2007 06:19:45 GMT

to unloack a table use Fm -

DEQUEUE_E_TABLE

DEQUEUE_E_TABLEE

DEQUEUE_E_TABLES

for session use tcode -

Sm12

Re: delete the lock

Former Member — Fri, 16 Feb 2007 06:20:57 GMT

Refer Tcodes,

SM12,

SE03

Re: delete the lock

Former Member — Fri, 16 Feb 2007 06:51:11 GMT

Hi Varalakshmi,

Goto SM12 .

click on LIST in the application bar.

then in the menu go for LOCK ENTRY and select Delete All.

Regards,

Naresh

Re: delete the lock

Former Member — Fri, 16 Feb 2007 08:45:41 GMT

my program s being locked how do i delete that

Re: delete the lock

Former Member — Fri, 16 Feb 2007 08:47:23 GMT

go to SM12 press list or enter select your prog name there in application tool bar you can see the delete option press that. it will delete the lock.

regards

shiba dutta

Re: delete the lock

Former Member — Fri, 16 Feb 2007 09:00:56 GMT

hi kannan,

well if u wanna entry lock through programming, i m givin u full step n code for locking and unlocking.

go to se11--> then give lock object name started by ez, as in example i took EZENMARA. then in table tab give table name MARA. then in LOCK field u can give the choice here i took shared lock 'S'.

THEN SAVE AND ACTIVATE.

THEN GO TO SE38 COPY THE BELOW PROGRAM AND ENJOY THE LOCK .

AND IF U WANNA TO USE UNLOCK IN PROGRAMMING JUS USE DEQUEUE_EZENMARA AND PUT THE REQUIRED ENTRY.

TABLES: MARA.

PARAMETER: MATNR LIKE MARA-MATNR.

CALL FUNCTION 'ENQUEUE_EZENMARA'

EXPORTING

MODE_MARA = 'S'

MANDT = SY-MANDT

MATNR =

X_MATNR = 'MATNR'

_SCOPE = '2'
_WAIT = ' '
_COLLECT = ' '
EXCEPTIONS
FOREIGN_LOCK = 1
SYSTEM_FAILURE = 2
OTHERS = 3

IF SY-SUBRC = 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

WRITE: 'TABLE IS LOCKED'.

ELSE.

SELECT * FROM MARA WHERE MATNR = MATNR.

WRITE:/ MARA-MATNR,MARA-ERNAM,MARA-MTART.

ENDSELECT.

ENDIF.

REGARDS.

VIJAY DWIVEDI.

REWARDS IF HELPFULL.

Re: delete the lock

Former Member — Fri, 16 Feb 2007 09:34:14 GMT

Hello,

Go to transaction SM12 and clikc the button list. Now u can delete the locked entries by selecting it and clicking the DELETE button.

Regs,

Venkat Ramanan N

Re: delete the lock

Former Member — Fri, 16 Feb 2007 09:40:12 GMT

hi kannan i think your probem is that your program or other object has been locked then jus go to sm12 and unlock it.

regards

vijay dwivedi

Re: delete the lock

Former Member — Fri, 16 Feb 2007 09:49:49 GMT

Hi,

The lock on a object can be deleted using the transaction SM12.

Regards,

Sowmya.

Re: delete the lock

Former Member — Fri, 16 Feb 2007 11:05:48 GMT

my authorization s being denied in sm12

Re: delete the lock

Former Member — Fri, 16 Feb 2007 11:19:07 GMT

Hi,

Goto SM12 transaction .

Click on the list . It will display list of all programs which are locked.

so select your program which has been locked and delete it.

Regards,

Sruthi

Re: delete the lock

Former Member — Fri, 16 Feb 2007 11:20:43 GMT

Hi,

Actually what message r u getting when u click sm12 transaction.

Regards,

Sruthi

Re: delete the lock

Former Member — Fri, 09 May 2014 11:10:32 GMT

This message was moderated.