topic Re: Fetching table based on a Field name in Application Development and Automation Discussions

Fetching table based on a Field name

sridevi_p — Wed, 18 Jul 2007 09:40:29 GMT

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

Former Member — Wed, 18 Jul 2007 09:42:11 GMT

U can do a query on table DD03L

Max

Former Member — Wed, 18 Jul 2007 10:25:28 GMT

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>

Former Member — Wed, 18 Jul 2007 13:26:26 GMT

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