Identify join condition between any two table.

[Former Member]

Hi,

I have set of tables. I don't know whether these tables are interlinked or not. I need to identify the underlying join condition in. As per my knowledge if my datasource is based upon infoset query , then I can go to SQ02 and find the underlying join condition. But in this case, I have only table names. How do i find whether they are interlinked or not.

Thanks in advance

Regards

Snehasish

[Former Member]

Thanks all. Points have been awarded to all of you.

[Former Member]

Hi,

There is a way i use. Create a test view. In the Joins tab, on left you give Table Name and at bottom there is option "Reference Tables". Here you get the relations.

[Former Member]

Thanks Partha for your quick reply. Could you please tell me how to go to that TestView means which transaction u r talking about.

[Former Member]

Go to SQVI

--> Create a View >Choose the Data source as Table Join> Go to insert table and add table as per your requirement.

[Former Member]

Hi ,

Go to SE11 t-code

select VIEW radio button

give view name start with Z.select create button

select databseview radiobutton. select copy button.

it opens a view creation window.

give table names in leftside .

select RELATIONSHIP button.

[Former Member]

Yup, RELATIONSHIP tab. As said by Nagaarjuna.