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?

[SatheeshSSN]

Hi Unni,

Yes, i beleive you can add an inner join in the extension view.

Another way is to try to achieve your requirement through CDS Access Control. Try to create some logic in access control by having some custom or standard auth object added to the respective roles.

Thanks,

Satheesh

[unni_sreekumar]

I tried adding _alias.[inner].field but shows me error "In view extends, no INNER JOIN must be used.

Also access control will not work in our case as delegation is maintained in a custom table.