topic Re: ST05 in Application Development and Automation Discussions

ST05

Former Member — Thu, 22 Jul 2010 06:24:46 GMT

Hi being a functional consultant how can i decode the transaction ST05 as there are so many tables available .

what does the colour signifies the yellow and blue colour.

Can anybody help me in this regard.

Thanks & Regards

Zafar

Re: ST05

Former Member — Thu, 22 Jul 2010 07:24:47 GMT

Blue is heading.

Light yellow and dark yellow is just for differentiation of different table fetch.

If you double click on any item, it will take you to select query with the actual values.There you can see A0, A1.... like that.These are just variables denoting what values which are passed during run time.

Also you have display call position button. this will take you to actual program.

Regards,

Nikhil

Re: ST05

Former Member — Thu, 22 Jul 2010 07:31:03 GMT

hi,

This yellow and blue color is just to differntiate different tables ...

you could also see Recs. and RC cloumn after deactivating the Trace. these are nothing but Recs ( number records fetched during that select statement), RC ( Return code ) which will have 0 if any records fetched or 4 when no records fetched.

Regards

Re: ST05

Former Member — Thu, 22 Jul 2010 07:47:23 GMT

how can 1 transaction can having so many different tables and how can i identify the tables which i require?

suppose i need to find out the table for System Status for a maintenance order .from all the tables displayed how can i find out tables for system status?

Re: ST05

Former Member — Thu, 22 Jul 2010 07:57:49 GMT

One transaction can have lots of database hits. All will be showing in st05.

If you want to identify the tables, double click each section and then you can see the select query.You will get the table name after FROM in the select query

Regards,

Nikhil

Re: ST05

Former Member — Thu, 22 Jul 2010 09:19:14 GMT

In the initial screen of st05

which trace should we select

1.SQL trace

2.RFC Trace

3.enque trace

or the Table buffer trace?

when we disply trace

Duration Obj Name OP

571 CAUFV PREPARE

2 CAUFV OPEN

.498 CAUFV FETCH

6 CAUFV REOPEN

i guess obj.name is the table name then there is a statement,what does prepare ,open fetch means and where should we double click so that we can obtain the required tables.

Re: ST05

Former Member — Thu, 22 Jul 2010 09:24:58 GMT

You should go for sql trace and activate the trace. then execute your program and come back and deactivate the trace and go for display trace.

for each table hit, you can see PREPARE OPEN FETCH. You can double click on corresponding items and it will take you to select query

Here you can see the table name after FROM