Skip to Content

Union in CDS Views with different columns

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?

cds.jpg (64.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers