SAP CDS Table function with parameters - Is there any way to consume this in a join or association?

[jmalla]

I have run into this issue several times over the years. We can develop nice table functions with input parameters. However, there is no way to consume them in a join or association. Does anyone have an example that uses a table function in a CDS view using an inner join or association leveraging the parameters (not hardcoded values or $session.client)?

If so, it would be great to see an example. Till now, I have not seen one.

Thanks,'

Jay

[Jelena]

This question has been sitting open for over a month and I'm guessing others are just as confused by it as I am. Could you share a more specific example of what exactly are you trying to do? I'm not sure I understand the issue and why you want to do exactly as written.

When I use table functions, I put a CDS view on top of them right away. Then, that CDS view can totally be used in an association. I've not tried it in JOIN but I think it wouldn't be very efficient. If you have such need, I'd just create another table function and do a JOIN there.

It would be helpful if you could add more details to the question.