Skip to Content
0
Former Member
May 06, 2013 at 02:59 PM

Infoset to join infoobject with DSOs

55 Views

Hi Experts,

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.

For ex:

DSO1 Accounting Document details

Document NoAD100AD200AD300AD400

DSO2: Billing Document Details

Document NoProfit CenterAD100PC1AD300PC2

IO: Profit Center

Profit CenterLocationPlantPC1LOC1PL1PC2LOC2PL2

Output should be:

Document NoProfit CenterLocationPlantAD100PC1LOC1PL1AD200AD300PC2LOC2PL2AD400

BR

Harish