Unique Sales Orders from VBPA for a Customer in CDS

[dev_logan]

Hi,

How to optimally model CDS views to fetch unique Sales orders from VBPA table for a Customer / Partner whose Function can be Ship-to party or Sold-to party. If Partner is both Ship-to/Sold-to then only unique record is required. If Partner is Ship-to and some other partner is Sold-to, then both partner details are required to be extracted while having unique Sales Order record.

This can be achieved easily with traditional abap code. Interested to see if CDS can be modeled to achieve the same.

regards,

Dev

[NooruBohra]

Use group by in CDS and have proper keys in your CDS.