topic Re: ST05 with different users in Parallel in Application Development and Automation Discussions

ST05 with different users in Parallel

aayushaggarwal — Tue, 29 Mar 2016 05:23:48 GMT

Hi Experts,

We have a requirement in which we are using ST05 for tracing the SQL statements and finding the custom objects used in the Client's system. But, we are facing a problem that only one user can use ST05 at once.

Like, if A is using ST05 then B cannot use the trace.

Due to this, we are going at a very slow pace.....

Please tell me, is there any alternative for the same ??

Thanks in advance...

Regards,

Aayush Aggarwal

Re: ST05 with different users in Parallel

matt — Tue, 29 Mar 2016 08:11:34 GMT

Have you tried "Activate Trace with Filter"? You can either activate for a single user, a user matching a pattern or all users.

Re: ST05 with different users in Parallel

Mohamed_Mukhtar — Tue, 29 Mar 2016 09:08:12 GMT

Hi Ayush,

You can also use trasaction ST12 to activate trace per user,work process , background jobs etc.

Please go through the link :-

Thanks

-Learner

Re: ST05 with different users in Parallel

Former Member — Tue, 29 Mar 2016 09:17:01 GMT

Why do you need the possibility for several users? Couldn't you trace the DB actions independent of the user? As far as I understand you only need to know, which tables are accessed while running a specific program or transaction.

Have you already thought about a code inspector check, which shows you the table accesses instead?

Re: ST05 with different users in Parallel

aayushaggarwal — Wed, 30 Mar 2016 05:04:22 GMT

Hello everyone,

I think you all got me wrong, let me clarify that with the help of an example:

SAY we have two sap login ids: sap1 & sap2, and sap1 is currently using the trace (ST05) and looking for the tables for Purchase order scenario.

At the same time, sap2 want to use the trace (in parallel to sap1) for sales order scenario.

But he can't because it is already been activated by sap1

So, is there any option sap2 can use the trace in parallel to sap1??

Regards,

Aayush

Re: ST05 with different users in Parallel

matt — Wed, 30 Mar 2016 05:19:22 GMT

Only by setting the trace on for all users. However in my experience, if people are diligent and disciplined in turning off the trace when they're not using it, there is little conflict.

Re: ST05 with different users in Parallel

aayushaggarwal — Wed, 30 Mar 2016 05:48:47 GMT

Hi Matthew,

If we will activate the trace for all users, wouldn't it degrade the performance because there may be 100 sap users in the system??

Regards,

Aayush Aggarwal

Re: ST05 with different users in Parallel

matt — Wed, 30 Mar 2016 06:35:40 GMT

Maybe. But you'll get the data you want.

Re: ST05 with different users in Parallel

Former Member — Wed, 30 Mar 2016 06:39:21 GMT

Hopefully you do not trace on the productive system for your requirement and on development or quality system it should be no problem I think.

Re: ST05 with different users in Parallel

Colleen — Wed, 30 Mar 2016 09:25:30 GMT

Another thing to consider is not using the same system at the same time for tracing if you are trying to locate tables.

Before resorting to ST05 for SQL I will check SM12 locks if it's change data. Also, if you know the module you can figure out most of the tables based on naming conventions and where used on the fields.

But really, you shouldn't need to have trace on for ages to go through the code. If you do, contact each other and coordinate schedules of using it.

Re: ST05 with different users in Parallel

Former Member — Wed, 30 Mar 2016 12:00:23 GMT

Personally I think that using ST05 is problematic in trying to find custom tables etc etc because you have to be sure that when you execute your code you visit all logic paths just in case there is a wayward select some where.

A silly example.... A report with two radio buttons - Show me P/O's, Show me Sales orders. One selects from Ekpo, the other Vbak. If the user keeps selecting Show Me P/O's then the VBAK selection will never appear in ST05.

Why not look at the customer development packages->Tables and then do a where used on them ?

Seems like a lot more accurate to me.

... or am I missing something here ?

Rich

Re: ST05 with different users in Parallel

dilorenzo — Wed, 30 Mar 2016 15:05:09 GMT

Hi,

I often use anst_search_tool for finding custom code.

The custom tables should be in included in custom code, right?

To find standard tables I use SD11.

Best regards,

Dominik

Re: ST05 with different users in Parallel

Colleen — Wed, 30 Mar 2016 22:39:05 GMT

my background isn't development so not sure

ST05 comes in handy to get an indicator - but then I'm usually tracing standard programs. Anything more complex, I'll put a break point in and step through the code to learn it

Re: ST05 with different users in Parallel

aayushaggarwal — Thu, 31 Mar 2016 03:15:36 GMT

Hi Richard,

Thanks for your reply!!

Looking for all the custom objects and using where used on each of it, seems ideal but wouldn't it be very hectic and time taking as compared to SQL trace.

And lets say I am looking for all the Z objects in PO, then how will i find the package for those objects because there may be a number of Z packages there in the system.

Regards,

Aayush

Re: ST05 with different users in Parallel

aayushaggarwal — Thu, 31 Mar 2016 04:56:30 GMT

Hi Dominik,

Please share the steps I will have to do in SD11, to find the custom tables.

Regards,

Aayush Aggarwal

Re: ST05 with different users in Parallel

Former Member — Thu, 31 Mar 2016 07:30:12 GMT

Hi Aayush....

hectic ??

No I don't think so, it would be measured and complete. You use SE80 to display customer packages and within those packages you select the custom tables and do a where used.

That doesn't rely on code taking every executable path.

Rich

Re: ST05 with different users in Parallel

dilorenzo — Thu, 31 Mar 2016 07:44:57 GMT

Hi Aayush,

I use SD11 for finding standard tables and methods, not customer tables.

For customer code, I use anst_search_tool.

Regards,

Dominik

Re: ST05 with different users in Parallel

aayushaggarwal — Thu, 31 Mar 2016 08:52:35 GMT

Hi Richard,

Thanks for your reply...

the our client environment has a large number of customization in which 100s of packages contain 1000s of tables, so that's why its going to be hectic.

Anyways i think there is no better alternate of ST05.

However, if any one has any other suggestions please reply on this thread.

Thanks Experts!!

Regards,

Aayush Aggarwal

Re: ST05 with different users in Parallel

matt — Thu, 31 Mar 2016 10:09:57 GMT

So SCOV doesn't cut it?