HOW TO FIND TABLE

[Former Member]

Hi,

Is there anyway to find all tables in which field exists - only by knowing field name without knowing table names.

[Lakshmipathi · Accepted solution]

Yes you can

Go to SE84, click ABAP Dictionary and Fields. Double click on [Table Fields] so that on your right side, a screen will appear. Input the Field name in the box against Field Name and execute. You will get list of all tables in which the field is used.

thanks

G. Lakshmipathi

[former_member184555]

Hi

Table DD03L is the table which stores the list of all the fields and it also gives you the table in which that field exists. Goto SE16 and input the table name as DD03L and execute and in the next screen - in the field name - provide the field name and remove the maximum hits and execute. This will give you the list of tables that have this field.

Thanks,

Ravi

[former_member204513]

Dear SAPSD,

Plaese fallow these steps

Go to field for which field you want to find the tables press F1 -->Click on Technical info tab in F1 screen , now system will take you to the Technical Information screen here you double click on the Field name now system will take you to the Display structure screen here you double clink on Component type of that field now system will take you to the Display data element screen in this screen you click on Where-Used list Icon or CntrlShiftF3 now sytem will take you to Where-Used list Data Element screen here you chek Table fields then Execute now system will give the list of all the tables for that field.

I hope it will help you,

Regards,

Murali.

[Former Member]

Hello,

You may select the filed and press F1 and see the technical details about the field. You can see the filed name as well as the table / structure name.

Prase