Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

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.

3 Comments

  1. i have made a join between Mara and Marc.

    as input i select material according to material type, material group and plants.

    output i want the material, the group and the maintenance view.

    not all the plants have the same maintenance view but the query returns wrong maintenance view!

    what can it be?

  2. i have made a join between Mara and Marc.

    as input i select material according to material type, material group and plants.

    output i want the material, the group and the maintenance view.

    not all the plants have the same maintenance view but the query returns wrong maintenance view!

    what can it be?

  3. Former Member

    This is very useful . Thanks for sharing .