Custom CDS view using UNION

[former_member306668]

Hi;

Is it possible to join two CDS views to display the combined result of two views. For example CDS view 1 returns following

Invoice No Invoice Amount Payment Date Payment Amount

1 10,000

CDS view 2 returns following

Invoice No Invoice Amount Payment Date Payment Amount

1 01.01.2019 6,000

1 02.02.2019 3,000

The final view should display following

Invoice No Invoice Amount Payment Date Payment Amount

1 10,000

1 01.01.2019 6,000

1 02.02.2019 3,000

The scenario is that we like to display invoice information, with payment information. In case of multiple payments, the invoice amount is duplicated in the results which leads to incorrect results.

Thanks

Thomas

[epeet]

ferasbasha3 we have a question on a similar topic. We want to have a view with projects on one row with the belonging project manager and project controller. We use the team member view for this. However, when we have for instance 2 project controllers, the project gets two rows. We want to force the join to pick one row. Is this possible wit a join?

Regards,

Esmee