Merging data using CDS Views

former_member188001 — Fri, 16 Aug 2019 18:42:39 GMT

Hi all,

I have 2 CDS Views

First View (CDS1) - Fetches data with one where condition on some tables/standard views

Second View (CDS2) - Fetches data with another where condition on the same table/standard views

Now, i would like to merge the output using third view (CDS3) . Appreciate if you could please give some suggestions.

I tired to do Inner join/Outer join but not able to still merge the data from CDS1 and CDS2

Regards,

Salil

Re: Merging data using CDS Views

maheshpalavalli — Fri, 16 Aug 2019 19:37:39 GMT

f u want to join two tables on condition use join. If u want to combine 2 table and provide them in a single view then use union.

Mahesh