How to find relationship between tables
1. Go to transaction SQVI
2. Create a View
3. Enter title
4. Choose the Data source as Table Join
5. Go to insert table and add table as per your requirement.
Here you can find various tabs through which you can find out join condition, reference field etc.