05-09-2006 9:53 PM
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.
05-09-2006 9:58 PM
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
05-09-2006 9:58 PM
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
05-09-2006 10:00 PM
hi,
It is possible by running T-Code
ST05 ( SQL Trace )
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
05-09-2006 10:06 PM
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.
05-10-2006 12:47 AM
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
05-16-2006 8:21 PM
05-16-2006 8:43 PM
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
05-17-2006 12:53 AM
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.