‎2007 Dec 22 7:49 AM
Can you tell me how to see the list of tables and fields ??
How to know the table to which the data is posted ?
And, how to find out the table if we know a Field (eg.BLDAT)???
Its urgent plz ???
‎2007 Dec 22 12:51 PM
Hi Venkat,
view report and see tables used in it... or you want something automatic?
of course you can put cursor on some table used in SQL and see where it's used.. selecting table structures... if that is what you want... and if not...
There are a couple of ways to see what you are looking for. The 2 I use most of the time are:
SE11 - Tables, Data Elements, etc - You use the data element to find where it is used. (e.g.: data element for company code - BLDAT)
SE16 - Tables
Cheers,
Satish.
‎2007 Dec 22 8:11 AM
goto the data element of BLDAT. use 'where used list' button.
or check DD03L table.
if u can tell me the exact requirement i can help u more.
Reward if useful
regards
ANUPAM
‎2007 Dec 22 12:51 PM
Hi Venkat,
view report and see tables used in it... or you want something automatic?
of course you can put cursor on some table used in SQL and see where it's used.. selecting table structures... if that is what you want... and if not...
There are a couple of ways to see what you are looking for. The 2 I use most of the time are:
SE11 - Tables, Data Elements, etc - You use the data element to find where it is used. (e.g.: data element for company code - BLDAT)
SE16 - Tables
Cheers,
Satish.
‎2007 Dec 23 7:24 AM
Check table DD03L (Table Fields).
Enter the field name value ' BLDAT'...u can get all the related table names.
Regards,
Maha
‎2007 Dec 23 10:34 AM
hi,
my suggestion is take the package from transaction code
using that package u search tables in se11 or otherwise goto dd02l or 3l by using data element u find it
‎2007 Dec 23 11:33 AM
Hi,
You can make use of SE11. Type the field name and click on display button.
Then you can click on the button where used? from toolbar and select table under options provided and you will get list of all tables in which the required field is present or is used.
Reward if u find this helpful.
Regards,
ABAP_DEV