Merging data using CDS Views

[former_member188001]

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

[maheshpalavalli]

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.

https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-US/abencds_f1_union.htm

Br

Mahesh