4 weeks ago
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 ?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
10 | |
5 | |
5 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.