Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Restful ABAP CDS metadata extension columns

AJeB
Participant

‎2024 Apr 22 10:10 AM - edited ‎2024 Apr 22 10:16 AM

0 Kudos
710

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

AJeB_0-1713776663081.png

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

AJeB_1-1713776799680.png

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

2 REPLIES 2

junwu
SAP Champion
SAP Champion

‎2024 Apr 22 2:26 PM

0 Kudos
682

show us your vbak cds.

RaymondGiuseppi
Active Contributor

‎2024 Apr 22 2:51 PM

0 Kudos
676

You have used LIPS, i.e. the delivery lines and not the headers. There are no duplicates if you included the item number in the delivery (lips-posnr), hence the failure of DISTINCT.

Could you provide description of _ZI_AJ_SD_VBAK2 and _ZI_AJ_SD_LIPS2 in text, not pictures.