Table based on a field

[Former Member]

Hi ABAP Gurus

I have a field.How can I know from which table this field is from ?

If this field is present in multiple tables, how can I find the tables ?

Please help me on this.

Regards

Jessy

[Former Member]

Hi,

You can find the table names from SE84/SE85

Go To T-code SE85.

CLick on ABAP Dictionary.

THen fields.

in that click on table fields.

Than enter field name and excute(F8).

then it will display all the tables where that field is present.

You can look at the below blog also

/people/community.user/blog/2006/12/29/useful-tips-to-find-out-the-table-for-screen-field

Regards

Sudheer

[Former Member]

Hi,

use the foolwing procedure:

Go to Tcode - SE84 -> ABAP Dictionary -> FIELDS. Double click on the fields one screen will be opened on the reight hand side. Here provide the field name & Execute. It will display all the tables this fileds belongs.

Reward points if helpful answer.

Ashvender

[Former Member]

hi

good

click on that field name,it ll take you to se11,select on where used list button ,select the table type.

it ll give you the list of tables where that particular field has been used.

thanks

mrutyun^

[Former Member]

Hi

goto SE16

enter the Table name DD03L

enter

enter the field name

execute

it displays all the tables in which that field is there

also you can see

SE84/SE85 tcodes

or click on the data element of that field

and use where used list of that data element in tables

execute

displays the list of tables where that data element is used

Regards

Anji

[Former Member]

Hi,

You get the tables names by selecting where used list button in SE11.

Go to SE11 - > Provide field name in the Database table and click on the where used list, from that pop window select only the tables. It will give you all the tables where this field is used.

Thanks,

Sriram Ponna.