finding Table names for tcodes

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

adding to above

TSTC SAP Transaction Codes

TSTCT Transaction Code Texts

[Former Member]

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

[Former Member]

Hi avniash,

Thanks for reply.

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

[SuhaSaha]

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

[GauthamV]

hi,

use TSTCP table.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

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

Vasavi

[Former Member]

Hi,

Please check FM: RS_PROGRAM_TABLES

Regards,

Nitin.

[Former Member]

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.!