Skip to Content

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

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Marco Enrico Reis Alberto

    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.

    (0) 

Leave a Reply