Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

what is the best way to seach the table names for the TCODE fields?

Former Member
0 Kudos

Hi All,

I am new to SAP coding, can any one tell me what is the best way to seach the table names for the TCODE fields?

And general procedure to know what are the tables are updating for any TCODE?

Thanks

Rajesh.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

You can Switch On the trace by executing Tcode ST05 and then run the Transaction or you can say business process.

Then Switch off the trace and view it. Then Review the Trace and you will get all the table names for that business process.

regards

Aman

7 REPLIES 7

Former Member
0 Kudos

You can Switch On the trace by executing Tcode ST05 and then run the Transaction or you can say business process.

Then Switch off the trace and view it. Then Review the Trace and you will get all the table names for that business process.

regards

Aman

0 Kudos

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,

Santosh

ferry_lianto
Active Contributor
0 Kudos

Hi Rajesh,

The easy way is to go the main program of the transaction code and find the TOP include program.

This include program usually used to declare all tables being used within the transactio code.

Other way you can use find button to search table in main program.

Hope this will help.

Regards,

Ferry Lianto

Please reward points if helpful.

Former Member
0 Kudos

Hi Rajesh,

Couple of more options

1). You can use tcode SE49 to find tables related to a program.

2). From se38 editor, enter the program name and hit Shift + F4 ( environment analysis ). This will list down all the tables accessed by the program.

Cheers

VJ

Mark helpful answers

0 Kudos

Hi thanks for ur answers and time.

Rajesh.

Former Member
0 Kudos

These answers are correct, but you have to bear in mind that they may miss some tables.

ST05 will only show which tables were accessed for a particular run of a transaction. Different tables may be used in other circumstances.

The program analysis will show all tables used by a program, but most SAP standard programs call function modules which may call other tables. I don't think those show up here.

There's no tool that I know of that will give a complete list of all tables that might be used by any program.

Rob

former_member186741
Active Contributor
0 Kudos

you can also use transaction se30 to run the transaction you are interested in. Then you can view the analysis which includes the tables used by the transaction. As with the other approaches, this will only tell you the tables used on that particular instance of the transaction.