Union of ADSO & Open ODS View not able to perform join (left outer) with another ADSO

[former_member593852]

Hi All,

I've a union of ADSO1 and Open ODS in the Composite Provider with 0BPARTNER as a common field on which I'm further performing left outer join with another ADSO2 to bring some additional attributes from ADSO2 but strangely join is being performed only for the ADSO1's BPartner values & not for the Open ODS's BPARTNER values.

Alternatively I tried creating a separate CPR for Union and used that CPR for joining with ADSO2 but same problem still persists.

Can anyone point out if anything wrong with design or correction measures?

P.S. There is data in all data providers for above join scenarios.

[nora_roch]

Hi Ritul,

check he scenario with the Guided Answer:

BW BEx Queries and HANA Composite Provider

It highlights samples and topics for joins and partproviders.

Cheers,

Nora