ST05 with different users in Parallel

[aayushaggarwal]

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

[matt]

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

[Mohamed_Mukhtar]

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

[Former Member]

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?

[aayushaggarwal]

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

[matt]

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.

[aayushaggarwal]

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

[matt]

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

[Former Member]

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.

[Colleen]

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.

[Former Member]

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

[dilorenzo]

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

[Colleen]

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

[aayushaggarwal]

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

[aayushaggarwal]

Hi Dominik,

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

Regards,

Aayush Aggarwal

[Former Member]

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

[dilorenzo]

Hi Aayush,

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

For customer code, I use anst_search_tool.

Regards,

Dominik

[aayushaggarwal]

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

[matt]

So SCOV doesn't cut it?