topic Re: finding Table names for tcodes in Application Development and Automation Discussions

finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 11:58:09 GMT

Hi experts

Is there any table to find out the table names by providing the Tcodes?

I have assinged the tcode for several table maintenance so i need a list out all those.

Thanks in advance

sai

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:00:35 GMT

HI,

TSTC is the table where you can find the Tcodes. Even to know the tcode for the table maintantence program you need to check in TSTC passing program name.

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:04:07 GMT

adding to above

TSTC SAP Transaction Codes

TSTCT Transaction Code Texts

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:05:14 GMT

Hi,

It is possible by running T-Code ST05 ( SQL Trace )

http://help.sap.com/saphelp_erp2005/helpdata/en/17/358df9c9fee2469105731e10756921/frameset.htm

Follow this way...

Performing an SQL Trace

1.Open a new window and choose System -> Utilities -> SQL Trace.

The Trace Requests screen appears.

2.Choose Trace On to activate the trace.

3.Perform a typical database access in the first window (for example, an application transaction or the transaction SE16).

4.To turn the trace off, choose Trace Off and examine the SQL statement with List Trace.

5.Position the cursor on one of the PREPARE, OPEN, or REOPEN statements, and choose Explain SQL.

The system displays detail information. The index used is specified in the line beginning with Index.

Regards,

Nitin.

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:06:42 GMT

Hi Saisai,

use TSTC table .

u can also find out by going to that Tcode........> utility...................>status there u will get data elsemnt name

search it in data dictionary.... u will get the table name there.

Regards,

Flavya

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:06:58 GMT

Hi,

The table tstc holds list of all the tcode's..

Vasavi

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:07:01 GMT

Hi Sai,

U can check the Table

TSTC_LOG -SAP Transaction Codes.

U Can check the Where Used list of a particular tcode to get the table name

Regards,

Lakshman

Edited by: Lakshman N on Dec 5, 2008 1:07 PM

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:07:52 GMT

Hi avniash,

Thanks for reply.

but I am looking for tcodes for all tables which have maintenace

Re: finding Table names for tcodes

SuhaSaha — Fri, 05 Dec 2008 12:09:42 GMT

Hello,

I think you can make use of the table TSTCP -- Parameters for Transactions.

The field PARAM will have the data regd. your table:

/*SM30 VIEWNAME=ZTABLE;UPDATE=X;

Hope this helps.

BR,

Suhas

Re: finding Table names for tcodes

GauthamV — Fri, 05 Dec 2008 12:13:00 GMT

hi,

use TSTCP table.

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:13:38 GMT

Hi,

Please check FM: RS_PROGRAM_TABLES

Regards,

Nitin.

Re: finding Table names for tcodes

Former Member — Fri, 05 Dec 2008 12:19:37 GMT

Look in table TVDIR .

Here you have all the Table Views.

You could go n search table nam ewise. try doing Z* and you will find all tables which have table maintenance views for them.

Hope this helps you.!