Skip to Content
-2

Union in CDS Views with different columns

Apr 12 at 10:16 AM

33

avatar image
Former Member

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)
10 |10000 characters needed characters left 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.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers