topic Re: Common fields b/w tables in Application Development and Automation Discussions

Common fields b/w tables

Former Member — Wed, 05 Mar 2008 17:09:56 GMT

Can anyone tell a method to find ALL the common fields (data elements) between two or more transparent tables in the dictionary

Re: Common fields b/w tables

Former Member — Wed, 05 Mar 2008 19:39:52 GMT

Hi there,,

If you would like to know what are the common fields between two or more tables,,

try following steps..

1. Create a dummy Database view.

2. In the Table/Join Condition, give the names of the table you are looking for

3. Click on the button "Relationships", this will give you all the common fields between those two or more database tables.

if found helpful,don't forget to reward points.

Thanks-

Rahul

Re: Common fields b/w tables

Former Member — Thu, 06 Mar 2008 05:04:40 GMT

Hi,

Go With Table DD02L.

I think This Will Meet U r Requirement.

Re: Common fields b/w tables

Former Member — Thu, 06 Mar 2008 05:34:49 GMT

Hi Tejas,

Go to a transparent table for which you want to know the common fields, from there click the button GRAPHICS (shortcut Ctrl + Shift + F11) in the application tool bar. Then you are redirected to a list containing the tables belonging to the same group. There select whatever tables you would like to see and click COPY. A window will pop-up and will show the relationship between the fields of the tables in a flow chart format.

Reward if helpful.

Re: Common fields b/w tables

Former Member — Thu, 06 Mar 2008 08:58:12 GMT

Hi thejas,

Good.

U can go to transaction SQVI and enter the table names to get the common fields between them.

Thanks,

Gokul.