I like to to build a custom CDS View (as OData) that returns the project team for Customer and Internal projects. The closest view I found is I_ResourceAssignmentPlanItem, which works fine except that it returns to many duplicated entries. We are only interested in the EngagementProject itself and the EmployeeInternalID.
However the field PlanLineItemUUID is automatically added due the Access Protection. When making the OData call it returns a lot of duplicated entries, which we need to filter out every time.
Is there a way to have a custom cds view to return only unique values, and to somehow avoid the PlanLineItemUUID field being included.
Unfortunately I haven't fund any other view that can be used to return the project team.