topic Re: Locked transaction code in Application Development and Automation Discussions

Locked transaction code

Former Member — Wed, 22 Oct 2008 18:43:24 GMT

Gurus,

How can we know who has locked the transaction code in a system?

Thanks,

Saga

Re: Locked transaction code

Former Member — Wed, 22 Oct 2008 18:52:56 GMT

Hi,

Use Tcode SM12 with * in user field. You will get the list of user names.

Rakesh

Re: Locked transaction code

Former Member — Wed, 22 Oct 2008 19:16:20 GMT

Rakesh,

I am just wondering how we can see the tcodes locked. Here I can see only tables locked.

Could you please let me know if I am wrong?

Thanks,

saga

Re: Locked transaction code

Former Member — Wed, 22 Oct 2008 19:20:50 GMT

Hi Sagarika,

Go to SM01 and then key in the t-code that you want to check and then enter.

If the t-code is locked you will see the box checked beside it.

Thanks,

Saby..

Re: Locked transaction code

Former Member — Wed, 22 Oct 2008 19:24:58 GMT

Run report RSAUDITC from SA38.

Rakesh

Re: Locked transaction code

Former Member — Wed, 22 Oct 2008 19:32:11 GMT

This also give only list of tcodes locked but not showing who locked the tcode.

Thanks,

saga

Re: Locked transaction code

Former Member — Wed, 22 Oct 2008 20:00:51 GMT

There is no standard easy way to do this.

If this is a once off investigation based on an event, then you can use the audit logs (SM20, etc) to see who used transaction SM01 since the last time the transaction which is locked was last successfully used.

There is a complicated way of activating a more detailed way of logging, but it is not easy to use.

See transaction SE13 (log data changes, and search for threads about it) and this thread:

Please leave the thread open for a while. Perhaps someone knows of another way.

Cheers,

Julius

Re: Locked transaction code

Former Member — Wed, 22 Oct 2008 20:02:42 GMT

In SM12 chose a valid row and go to detail view of the lock.

Under technical attributes you will get the tcode name which is locked along with user.

Rakesh

Re: Locked transaction code

Former Member — Fri, 24 Oct 2008 05:52:48 GMT

Hi Sagarika,

As mentioned by Julius, you can configure the audit log.

Or you can try the following to narrow down your search.

1) Use STAD/ST03N.

I am considering STAD for the following steps.

2) Get the list of the users executing SM01 using Transaction=SM01.

3) Go to Edit-> Select output fields.

4) Select only User & Update requests.

Non-zero value under Update requests indicates the user has made some changes.

Still I am finding a way

1) to differentiate between the update requests for locking & unlocking & then

2) to relate a request with the transaction.

Regards,

Sachhidanand Rankhambe