3597268 - Missing Line Items in Reports Due to Incorrect Cardinality in Custom CDS Views

When executing queries or reports based on a custom CDS view that joins delivery headers and items, fewer line items are displayed than expected. Specifically, queries with multiple selections in the WHERE clause (e.g., using "IN") return fewer rows than queries with a single selection. 

For example:

Single selection:

WHERE OUTBOUNDDELIVERY = '0000000001'

returns multiple line items as expected.

Multiple selections:

WHERE OUTBOUNDDELIVERY IN ('0000000001', '0000000002')

returns fewer aggregated line items than expected.

CDS view, analytical query, aggregation issue, missing line items, cardinality, outbound delivery, custom CDS, many-to-one join, one-to-many join, F1866A, Custom CDS Views , KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem