Skip to Content
0
Former Member
Nov 15, 2012 at 10:40 AM

BW infosets and Multiprovider

77 Views

Hello all, I have presently 3 Tables as shown below: DSO 1 EBELN EBELP EKORG ABC 10 100 ABC 20 100 BCD 10 100 CDE 10 100 TDSO2 EBELN EBELP BELNR ABC 10 PQR ABC 20 QRS BCD 10 RST BCD 10 STU CDE 10 - - - UVW DSO 3 BELNR NETPR PQR 119 QRS 129 RST 139 STU 149 UVW 159 I need the result as table below: Result Final EBELN EBELP EKORG BELNR NETPR ABC 10 100 PQR 119 ABC 20 100 QRS 129 BCD 10 100 RST 139 BCD 10 100 STU 149 CDE 10 100 - - - - - UVW 159

I have tried to create Left outer Join(creating Infosets in SAP BW) between DSO 1 & 2, DSO 2 & 3 separately. But now I am stuck at how to proceed further and merge the Infoset Result 1 & 2 to get the desired Result Final table. Can anyone suggest some ideas on how to do this in general and as well in SAP BW.

Thanks in advance.