How to find source table

[Former Member]

Hi Experts,

Please some one tell me how to find the source table for a structure table. I have table called AFVGD( Structure Table) and AFIH( Transparent Table) , I want to find the physical table where this two tables based on like I want to know Price field is coming from that is existing in AFVGD.

Thanks

Robbie

[Former Member]

Hi Experts,

Please some one tell me how to find the source table for a structure table. I have table called AFVGD( Structure Table) and AFIH( Transparent Table) , I want to find the physical table where this two tables based on like I want to know Price field is coming from that is existing in AFVGD.

Thanks

Robbie

[Former Member]

one way is checkout the where-used-list of the dataelement , u find the relevant tables for that from which u can choose

[Former Member]

Hi Chandrashekar,

I cant find any information, I selected the table in SE11 for example AFVGD and I selected Where-Used List under that I selected only Database table. But I got the message called " Structure AFVGD was not found in Database tables ". Please any other ideas......

Thanks

Robbie

[Former Member]

Find the where-used-list of the price field but not structure

1. Goto Se11

2. Give the dataelement as dataelement of price field

3. check the where-used-list for database tables

[Former Member]

Hi,

You can also use ST05..

Switch on the SQL Trace..

Execute the transaction..

Switch off the SQL Trace..

You can see the tables that were used in the transaction.

Thanks,

Naren

[Former Member]

hi robbie,

to find the source table of the particular field,jus go to SE11.

click the "data type" radio button.

now correspondingly give the data type of the price field u want to find.

then click "where-used list"

this wil show a drop down.

jus check only "table fields" in that.

then it wil show u all the tables which contains ur price field is present.

****reward points if my ans is useful.

all the best.

[Former Member]

go to se11 display the structure afvgd.

the price field PREIS take data element name and it will be PREIS

and come back to initial screen of se11 go to data type give the name PREIS here in application tool bar you can find the where used list button just click it will pop up some box check tables there and press enter it will display the tables list.

i think you can find it in AFVC table.

regards

shiba dutta

[Former Member]

Hi,

Thanks for your great efforts, I solved my issue.

Thanks

Robbie

[Former Member]

This message was moderated.