Duplicates in CDS view

[former_member628752]

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

[shasan]

Hi Sureshkumar,

Not sure, but I do not see your CDS view attached here. Also i can see the keys for both the joining tables are almost same, except the Ledger. Did you keep that into account while writing your select for your CDS ? If the Accounting docs and the respective line items exists in multiple ledgers, this will also impact your final result set.

[vamshi_mohan]

Hi Suresh,

The issue is not with the CDS view or BSET table. It is with the join statement.

Share your join statement to fix this.

Regards,

Vamshi.