Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

suppose i know only field name.how to find table name?

Former Member
0 Kudos

hi to all...

1...here is a requirement.

suppose i know the field name.but i don't know the table name in which that field is exiting.i want to find out the table.how i have to approach for this requirement.

thanks and regards,

k.swaminath.

8 REPLIES 8

Former Member
0 Kudos

hi,

go to SE15.

ABAP Directory-> Fields-> table fields.

write ur field there and search for table

reward if useful.

Former Member
0 Kudos

Hi,

go to transaction SE11 and use display datatype.

Inside this view you can use "Referenz" STR-SHIFT-F3.

Regards

Nicole

Former Member
0 Kudos

Hi

go to se80>repository information system>ABAP Dictionary>fields>table fields

give ur field name. take a particular table .

go to se11.

give the table name, take the cursor to the particular field and click on the where used list to get the other tables where the field is used.

<b>Rewar dif usefull</b>

Former Member
0 Kudos

Hi,

goto table DD03L and give your filed name in field name column. and execute.

it will show all tables where the field is being used sorted in relevance

Former Member
0 Kudos

Goto tcode->SE84,then press on fields,then table fields.Give the field name and execute.U will see the field used in different tables.

to find the table name from the data element i.e. the field name. First go to SE11, there type the field name in the Data Element tab and then go to the toolbar on the top and press the WHERE-USED-LIST and then it displays the list of tables where the given field has been used and from that you can choose the required table depending on your requirement.

here is the nice blog to find table name for a field

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

Step1 : Go to SE11

Step 2:At Database table Textbox: Press F4

Step 3:again Click Information System

Step 4: write your short text

From the displayed list select your suitable (needed) Object(Table)

Former Member
0 Kudos

hi,

use the following navigation for your problem

goto se85>abap dictionary>fields-->tablefields.

doubleclick on the tablefields then you having the search options

Please reward me points if you find this answer is useful

Former Member
0 Kudos

hi,

there is a very simple solution for that follow these steps

go to se 11.. then go to domain and then write the domain of that data element then u get the domain name .. then for that where=>used=>list can be used to get the name of tables where the table is used..u ll surely get required table ......

reward if helpful

regards

NIESH KUMAR

Former Member
0 Kudos

HI,

There are many ways to find.

1. Go to domain of that field, go to value range tab there u will find value table.

2. If not present go to DD03L , in selection screen of it give field name , u will get all table names in which that field exists.

3. Or you can do it by SE80 also as explained earlier..

reward if useful.

Thanks,

Madhura Nadgauda