Duplicate records after extension of Standard CDS view

[jay_d]

Hi Everyone,

I have a requirement to add a new field to the Fiori App F2358 (Monitor Purchase order items). So I have extended the required view C_PurchaseOrderItemMoni.

Extension CDS view:

But when I try to use the added field as filter, I get duplicate records in the result.

The lines are repeating for each Purchase Requisition line linked to PO.

In my understanding, I am doing something wrong with the association but I am not able to figure out.

Can anyone please help me out?

Regards,

[junwu]

[1..1] is just information only, it is not going to force 1..1

if that two table relationship is not 1..1, you will have duplication.