How to add inner join association to an extended cds view

[unni_sreekumar]

Hi All,

We have extended a standard CDS view of standard application WBS Element Overview. We are trying  to add restriction to  Project Managers and Delegates (maintained in a custom table) to view only the ones assigned to them. There is a table function which take session user as input and return a required resultset . 

Is there a way we can add an inner join to this TF in the extended view ? My understanding is we can only add association( which is also Left Outer join) and not inner joins in extended view? Any workaround  ?

[AndreaUS · Accepted solution]

Hi,

using INNER JOINS in extensions is prohibited, as it would influence the result cardinality of the extended view and would therefore be a modify the standard, which is not allowed.

Depending on the scenario, you should rather define your own CDS view on a C1-released interface.

Hope this helps

[unni_sreekumar · Accepted solution]

Thanks Andrea, so defining our own CDS will require a new Fiori app too right? or can we extend the Standard app to consume the new service?