Skip to Content
Author's profile photo Manish Shankar
Manish Shankar
October 10, 2012 Less than a 1 minute read

How to find Relations between tables in SAP

To find the relation between Tables in SAP:

1. Go to Transaction SQVI , Enter the QuickView name and click on Create

1.JPG

2. You’ll get this screen. Here For Data source: Select ‘Table Join’ from drop down and Enter.

2.JPG

3. Click on ‘Insert table’ and enter the table name.

3.JPG

4. Repeat the Step 3 and Insert the tables.

5. It’ll display the relation like this:

4.JPG

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Manish,

      Very good document it is.

      Can you upload any document about tabstripts.

      Author's profile photo Mahesh kumar
      Mahesh kumar

      Hi sahil,

      Please find the below link regarding to the tabstrip.

      http://help.sap.com/saphelp_nw04/helpdata/en/17/5bf1b52ba211d2954f0000e8353423/content.htm

      http://wiki.sdn.sap.com/wiki/display/WDABAP/TABSTRIP+CONTROLS+IN+ABAP

      http://wiki.sdn.sap.com/wiki/display/ABAP/Dynamic+Tabstrip+in+ABAP

      Regards

      Mahesh

      Author's profile photo Former Member
      Former Member

      You can:

       

      Please check the below info, it may help in your task:

      1.Goto t-code SQVI.

      2.Give a test QuickView name and create with data source 'Table join' in layout mode.

      3.Goto Edit->insert table.Mention the table name and add the table.

      or

      SE11 via the graphic button (Ctrl+Shift+F11).

      The other cumbersome version would be to find a Where Used List restricted to used in "Database Tables" but this will not give the relationships. You will have to figure out that piece manually looking at each table.