01-12-2005 9:20 AM
Hi,
I found a structure with field: ADRC_STRUC - REMARK
I need to know what table it takes it's data from. Howto ?
I tried the "Where-Used-List" ... but its not simple
I want to see the SELECT INTO clause... i belive...
//Martin
Message was edited by: Martin Andersson
01-12-2005 9:36 AM
Look at adrc table the data you need is there.
-
If it helps please give points.
01-12-2005 9:36 AM
Look at adrc table the data you need is there.
-
If it helps please give points.
01-12-2005 12:36 PM
Hi,
We are getting there.... the real table is ADRCT.
How did you know this ?
If you know a structure in the dictionary...what do you do in order to figure out the <i>real table</i> ?
//MA
01-12-2005 12:38 PM
I use the ST05 Transaction to see the whole process of what i need
01-12-2005 1:10 PM
If the only thing you have is the name of structure. You can just look at the fields of the structure and in which table it is used mostly.
But the name of the field and the one in the table may differ. In this situation it gets more cumbersome.
But if you are looking in a program and where the values come. try to set a watchpoint for your structure and see in debug mode where it is filled.
-
If it helps please give points.
01-12-2005 5:33 PM
Another way of getting it is by double-clicking the data element of the field REMARK. Then do a cross reference on this data element looking for it Tables. Then you will see the Transparent Tables that uses that data element.
01-13-2005 5:21 PM
I used 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?
01-12-2005 11:23 AM
Martin,
-> TA ST05 - Trace on
-> your Transaction , which you'll analyze
-> Trace off
-> Trace list - analyse the select statements
Andreas
01-12-2005 4:28 PM
Hi Martin,
This is what I typically do, if I need to find out what table(s) that a given structure ultimately points to.
1. As suggested by others here, debugging is one option.
2. Go to SE12, give the structure name, do a where used in programs, tables and function module interfaces. You may end up in getting a lengthy list but you need a good process of elimination to get to the tables. If the structure is used in a table as an INCLUDE or APPEND structure, well and good. But if it is used in a program or a function module interface, I would go to the code and see where the structure is getting filled and with what information. If you could continue to follow this trace, to the main program where the data declarations are at, you will find the tables that are defined. Sometimes searching for a 'Select' statement could lead you to the table.
Though it sounds cumbersome, most often, I could get my answer and in a quick time.
Hope this helps,
Srinivas