Skip to Content
avatar image
-2
Former Member

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

  • 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.

  • Get RSS Feed

0 Answers