Restful ABAP CDS metadata extension columns

HI I have two CDS view that get records from VBAK and LIPS

the requirement is to get the Sales Order with Delivery and display the delivery in the column

this is the CDS of LIPS


in VBAK CDS I got a warning message -> The association _ZI_AJ_SD_LIPS2 can modify the cardinality of the results set

After displaying it in FIORI list report it is displaying 2 same Sales Order and it has same records


How can I prevent the duplicate records, I already tried to add DISTINCT keyword but its not working? 

Scroll to Top