Skip to Content

How to get the real table information of a structure from the trace file?

I user the ST05 to trace a program to find the real table information of a structure in this program. But I found so many sql trace information in the trace file. So how can I find which information is useful for me to find the real table of a structure?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jan 13, 2005 at 10:35 PM

    Hi Zlmark,

    Normally the field in the structure has the same data element as the field in the table. Look at the structure field data element in SE11 and then do cross reference on this data element.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 13, 2005 at 05:37 PM

    Hi!

    If you don't recognize some tables, because they belong to same application, then it's difficult.

    Try to change interesting value. Afterwards you can search for 'INSERT', 'UPDATE' (and 'MODIFY'?) - that will leave only a small number of lines, which have to be analyzed in detail (e.g. have a look at them with SE16).

    Regards,

    Christian

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2005 at 08:34 PM

    In addition to the other comments, if you know you have actually read data, you can skip over the selects that did not return any records. There is a column for the number of records returned by the select. Many times, for example, i know the program should have retrived 4 records for display, so i look for a select that returned 4 records. It does not always work, but it sometimes does.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.