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

Finding tables..

Former Member
0 Likes
624

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
555

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

5 REPLIES 5
Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
555

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

Read only

0 Likes
555

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 ?

Read only

0 Likes
555

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

Regards,

Rich Heilman

Read only

0 Likes
555

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

Regards,

Rich Heilman

Read only

Former Member
0 Likes
556

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