Application Development and Automation 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: 
Read only

Fetching table based on a Field name

sridevi_p
Active Contributor
0 Likes
563

Hi,

Suppose if i know the field name, is it possible for me to know the tables where the said field is available?

E.g. BUKRS - Cocode

If i give this field name, i want the list of tables that has BUKRS as the field name.

Request your help on this.

Thanks,

Sridevi

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
536

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.

regards,

srinivas

<b>*reward points for useful answers*</b>

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.

regards,

srinivas

<b>*reward points for useful answers*</b>

3 REPLIES 3
Read only

Former Member
0 Likes
536

Hi

U can do a query on table DD03L

Max

Read only

Former Member
0 Likes
537

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.

regards,

srinivas

<b>*reward points for useful answers*</b>

Read only

Former Member
0 Likes
536

Dear Sridevi,

I you have a field like BUKRS then go to SE11.

Put in BUKRS in under "Data Type".

Go to the where used List ICon - the third from the left on the APPlication Toolbar

or press CTRLSHIFTF3.

this will list out all the tables where this particular field is being used.

Hope this solves you problem

Thanks

Venugopal

Reward accordingly if found useful