topic Re: Finding tables.. in Application Development and Automation Discussions

Finding tables..

Former Member — Wed, 17 Aug 2005 15:02:19 GMT

I know how to find the table associated with particular data element.(by clicking on technical documantation after cliking F1)

Is there a way in SAP where I can find the tables which contain more than one data element we want in it ?

Tushar.

RichHeilman — Wed, 17 Aug 2005 15:05:23 GMT

Sure, in SE11, enter the data element in the data type field, click the radiobutton associated with data type and click Where-Used.

Regards,

Rich Heilman

Message was edited by: Rich Heilman

Former Member — Wed, 17 Aug 2005 15:12:45 GMT

Actually I Know that.

There we find all the tables associated with just one data element, say VORNR.

I am asking something different.

If I want to find the tables which has both VORNR and ARBPL field what do I do for that ?

RichHeilman — Wed, 17 Aug 2005 15:24:58 GMT

Oh, I see. I don't think that there is a way without doing some creative programming.

Regards,

Rich Heilman

RichHeilman — Wed, 17 Aug 2005 15:25:53 GMT

You could do the where-used seperately, download the list to excel, and cross reference them.

Regards,

Rich Heilman

Former Member — Wed, 17 Aug 2005 18:26:56 GMT

This reply is not exactly what your are looking for, because it's search for fieldnames and not for data elements. Perhaps it's helpful after all.

- start the Transaction SE84 (Repository Info System)

- Select in the tree ABAP Dictionary -> Fields -> Table Fields

- Insert in the Select-Option "Field name" the name of the files (E.g. CARRID and CONNID) and expecute it

- now you will get a list of all tables which have one or both of this fields

- it's easy to identify the tables which contain both fields in the list

Stefan