Common fields b/w tables

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Go With Table DD02L.

I think This Will Meet U r Requirement.

[Former Member]

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.

[Former Member]

Hi thejas,

Good.

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

Thanks,

Gokul.