topic Re: STAD Tables in Application Development and Automation Discussions

STAD Tables

Former Member — Fri, 17 Jul 2009 09:26:50 GMT

Hi,

Please let me know the tables that are used by transaction STAD.

regards,

Milan Thaker.

Re: STAD Tables

Former Member — Fri, 17 Jul 2009 09:28:20 GMT

Hi Milan,

turn on sql trace.

run STAD. then go to trace again . you will find all tabled being used by STAD

Re: STAD Tables

Former Member — Fri, 17 Jul 2009 09:28:50 GMT

Hi Milan,

these are the table.

sapwlwamai,

trdir,

sapwlslins.

Regards,

Vijay

Re: STAD Tables

Former Member — Fri, 17 Jul 2009 09:29:59 GMT

Hi Milan,

Checkk this Tables

SAPWLSLINS SAP Workload: ST03N; For Table Control to Select Instances

SAPWLWAMAI . output fields in Trans. STAD - main list

TRDIR Generated Table for View TRDIR

Regards,

Lakshman.

Re: STAD Tables

Former Member — Fri, 17 Jul 2009 09:31:04 GMT

ST05 is the tcode for the Trace.

Activate the trace for this transaction(option with filter is present).

Then execute stad.

then display trace.

you can see select,insert,update queries from table.So you will get all tables.

Regards

Sajid

Re: STAD Tables

Former Member — Fri, 17 Jul 2009 09:34:09 GMT

Hi,

To all the tables used in the transaction STAD.. Goto System-> Status. From there you will get the main program for that transaction. Then goto SE80 and you will get all the table names used in this Tcode.

Hope this will solve your requirement.

Re: STAD Tables

Former Member — Fri, 17 Jul 2009 09:35:38 GMT

Hello

All statistic data in STAD are stored in file on server, not in DB tables.

Re: STAD Tables

Former Member — Fri, 17 Jul 2009 09:46:11 GMT

Hey could you please provide the name of the file.

regards,

Milan Thaker

Re: STAD Tables

Former Member — Fri, 17 Jul 2009 09:56:17 GMT

Hi Milan,

Chk this Link

regards,

Lakshman.