I created a infoset joining 2 DSO and 1 InfoObject. DSO1 contains Accounting Document details and DSO2 contains Billing Document Details and Profit Center is the infoobject.
Between DSO1 and DSO2 i used Left Outer join and now i want to include the infoobject with DSO2. I tried with both inner and left outer join. But it throws error.
Please suggest how to achieve this.
DSO1 Accounting Document detailsDocument NoAD100AD200AD300AD400
DSO2: Billing Document DetailsDocument NoProfit CenterAD100PC1AD300PC2
IO: Profit CenterProfit CenterLocationPlantPC1LOC1PL1PC2LOC2PL2
Output should be:Document NoProfit CenterLocationPlantAD100PC1LOC1PL1AD200AD300PC2LOC2PL2AD400