Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to create a Complex Multi-Join b/w more than two tables in a multi-sourced Relational Universe?

Scenario:

A complex multi-join in a multi sourced relational universe is as follows:

DS1.Table1.Col1=DS2.Table1.Col1 or
DS1.Table1.Col2=DS2.Table1.Col1 or
DS1.Table1.Col3=DS2.Table1.Col1 or
DS1.Table1.Col3=DS2.Table1.Col1

After making some changes in the backend, Col1,2,3 and 4 from Data Source (DS) 1 have been split and are part of different tables. How do I re-create the above join with the new DS1 fields coming from 4 different tables.

Ideally I want to do the following: 

DS1.Table1.Col1=DS2.Table1.Col1 or
DS1.Table2.Col1=DS2.Table1.Col1 or
DS1.Table3.Col1=DS2.Table1.Col1 or
DS1.Table4.Col1=DS2.Table1.Col1

IDT only lets you create multi joins if the fields are coming from two tables.

Is it possible to create the above joins individually and then somehow combine them with the "or" operator.

Its important to note that the DS1 fields were text fields while new DS1 fields are now master data fields.

Thank you for your inputs. 

Tags:
Not what you were looking for? View more on this topic or Ask a question