Skip to Content
Author's profile photo Anoop Satheesan

How to find relation between two tables?

Theme

The main aim of this blog is to find the relation between two tables. Sometimes we have some tables and we need to know, what is the relation between those tables and what all are the common keys in those tables.

Created by

Anoop Satheesan

Date

06/ June/ 2012

Steps to follow


   Go to Tcode SQVI and Create a view.

               

Click on Insert table and add your first table.

Same way, insert your another table.

                              

Now the tables and its relation will be displayed.

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jason Lax
      Jason Lax

      Looks like you posted your article as a blog instead of using the correct content type document.  Selecting the correct content type is important to ensure it gets the right visibility and encourages replies from other SCN users.  See The Difference Between a Discussion, Blog Post, Document and Wiki.

      Author's profile photo Anoop Satheesan
      Anoop Satheesan
      Blog Post Author

      Dear Jason Lax,

      Thanks for the info, I am not good about the new structure of this SCN. Anyway I will try to follow the link you shared.

      Thanks, Thanks again.....

      Anoop Satheesan

      Author's profile photo Former Member
      Former Member

      Isn't Graphic (On the toolbar of SE11) a better option to do the same?

      Sorry, could not attache screenshots as the option was disabled.

      Author's profile photo Anoop Satheesan
      Anoop Satheesan
      Blog Post Author

      Dear chinmay kulkarni,

      That button on the top of SAP screen is also a method, but i think it is mostly used for another purpose. Means, if you want to know in which all objects your fild is using. That option is ok.

      But If you have two tables, and you want to find the relation between those two tables, you can follow my post.

      There may be many other alternatives, but I tried to share a way which helps you to understand easily.

      Thanks,

      Anoop Satheesan

      Author's profile photo Naresh Bammidi
      Naresh Bammidi

      Hi Anoop,

      Can you post a document regarding Graphic option in se11.I tried to find  all related tables of MARA.But i couldn't find anything from that Graphic.Could you tell me please what is the meaning of lines in between tables.

      Thanks

      Naresh Bammidi

      Author's profile photo Anoop Satheesan
      Anoop Satheesan
      Blog Post Author

      Hai Naresh,

      Thanks for watching my threads in scn..

      I will post the same what you asked soon.....

      Thanks,

      Anoop Satheesan

      Author's profile photo Former Member
      Former Member

      Very nice and helpful blog.

      Hope you write more such blogs.

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      Sorry but it's actually not a very good method. It works correctly only in the obvious cases like the example here that could be easily established just by looking at the keys in SE11. Otherwise it tends to propose non-existent links too frequently. E.g. try connecting VBAP and LIPS and you'll be in for a surprise.

      One would have better luck with Google or just looking in SE11 and SE16. Or running SQL trace. Pretty much any other method would be better.

      Author's profile photo Former Member
      Former Member

      Thank you very much for useful answer.

      Can we able find the tables by one more fields?


      I tried in SE15 ,but it provides based on one field.(I am requiring to find through one more field)


      Thanks in advance.Capture.JPG

      Author's profile photo Ramires Meneses
      Ramires Meneses

      Have you tried to click at the Multiple Selection button?

      Untitled.jpg

      Execute and it'll list every tables that the Fields appear. Just need to look in which tables the fields show at the same time.

      Untitled2.jpg

      Author's profile photo Sneha Jadhav
      Sneha Jadhav

      Learned to new to find relations in database tables.

      Informative blog.