topic Table based on a field in Application Development and Automation Discussions

Table based on a field

Former Member — Mon, 01 Oct 2007 14:01:37 GMT

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

Re: Table based on a field

Former Member — Mon, 01 Oct 2007 14:06:34 GMT

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

Re: Table based on a field

Former Member — Mon, 01 Oct 2007 14:08:25 GMT

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

Re: Table based on a field

Former Member — Mon, 01 Oct 2007 14:25:19 GMT

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^

Re: Table based on a field

Former Member — Mon, 01 Oct 2007 14:27:24 GMT

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

Re: Table based on a field

Former Member — Mon, 01 Oct 2007 14:36:30 GMT

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.