Union in CDS Views with different columns

[former_member377522]

Hi Experts,

I have 3 different tables containing three different fields. Please refer the image below.

Table XX01 contains Customer Group & Name, Table XX02 contains Customer Code and Table XX03 contains Customer Name. Most of the primary keys don’t have a match between these tables.

Now I want to create a CDS view like below image in such a way that if there is no value in the respective table, still it should show the value as blank.

How to achieve this? Union will help create exactly like this?

[gregorw]

Seems that your first image is missing. Also I would suggest that you look for a better matching Primary tag as you need DB and no UI experts.