Skip to Content
0

Avoid Duplicate entries in CDS view

Oct 20, 2017 at 06:48 AM

245

avatar image

Hello Gurus,

I am new to CDS views. I have created one CDS View to get the entries from BSET table joining with ACDOCA table. I am getting entries which are exist in BSET table but the issue is in BSET table, Document number, year, G/L account number and Tax code are same. If BSET table contains more than 1 entry am getting only 1 entry from BSET. I have used DISTINCT key word while selection. But what ever the entries exist in BSET those all are valid and need to display in report.

in BSET if we have 3 entries in CDS view it is repeating 9 entries with same values but I dont want 9 entries.

Please guide me how to get the all entries from BSET.

Please find the attached CDS View. Let me know if any changes in View.

cds-view.txt (8.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers