topic Re: SQL Trace Finding Base table for Field in Tcode in Application Development and Automation Discussions

SQL Trace Finding Base table for Field in Tcode

Former Member — Tue, 12 Sep 2006 14:58:03 GMT

HI all,

If we want to find a base table for the field in any transaction code then how to find it with SQL Trace

There are so many SELECT Statements in Trace List It is hard to find. How we can Find . please help.

Thanks in advance

Ranjith

Re: SQL Trace Finding Base table for Field in Tcode

Former Member — Tue, 12 Sep 2006 15:00:54 GMT

U can also use the F1(help) and F4 (Technical Help) to find the table and fieldname information.

Just press F1 and than F4 with the cursor on the given field.

Re: SQL Trace Finding Base table for Field in Tcode

Former Member — Tue, 12 Sep 2006 15:04:09 GMT

Hi anurag

I know it but we will be able to see the field, name my question is how we can find its base table

what will happen if we press f4 on the Field, how to find it with SQL Trace

Ranjith

Re: SQL Trace Finding Base table for Field in Tcode

former_member195698 — Tue, 12 Sep 2006 16:36:44 GMT

You have to check each table present in the select statement in the trace. Better get all the tables in the trace with the select statement and check the description of the tables. From the description it will be easy to figure out.