Thomas Born
Custom CDS view using UNION
Thomas Born · over 1 year ago · Question
Answered
Thomas Born

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

Comments

Comments
Alumni