topic Re: bldat in Application Development and Automation Discussions

bldat

Former Member — Sat, 22 Dec 2007 07:49:01 GMT

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 ???

Re: bldat

Former Member — Sat, 22 Dec 2007 08:11:21 GMT

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

Re: bldat

Former Member — Sat, 22 Dec 2007 12:51:32 GMT

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.

Re: bldat

Former Member — Sun, 23 Dec 2007 07:24:50 GMT

Check table DD03L (Table Fields).

Enter the field name value ' BLDAT'...u can get all the related table names.

Regards,

Maha

Re: bldat

Former Member — Sun, 23 Dec 2007 10:34:03 GMT

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

Re: bldat

Former Member — Sun, 23 Dec 2007 11:33:40 GMT

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