topic Re: Consume Table Function With Parameters From CDS View in Application Development and Automation Discussions

Consume Table Function With Parameters From CDS View

Former Member — Mon, 07 Jan 2019 15:29:56 GMT

I have a table function with parameters (other than just client). When I try to consume the function from a CDS view, it only likes the CLIENT parameter; I can't send the values for the others.

I'm new to using table functions and AMDPs so I'm hoping this is just a beginner's error. I am using Eclipse IDE to edit the code.

Re: Consume Table Function With Parameters From CDS View

rajucd81 — Tue, 08 Jan 2019 08:16:01 GMT

Hi Dianna Short-Hopkins,

You can't use left side table fields in parameters assignment of right side table/view, it should be some constant/pre-defined values in your case like $session.client.

Re: Consume Table Function With Parameters From CDS View

Former Member — Tue, 08 Jan 2019 20:29:34 GMT

So how would you consume a table function with parameters?

Re: Consume Table Function With Parameters From CDS View

rajucd81 — Thu, 10 Jan 2019 06:26:25 GMT

Ideally Table functions will be used in Programs and passed the parameters from selection screen. in CDS views if you want to use it you should have some constants/pre-defined variables to pass to parameters of Table function.

Re: Consume Table Function With Parameters From CDS View

sakshi_sawhney — Wed, 08 Jan 2020 13:33:04 GMT

In Select query pass the parameter like below

objects( client : $session.client.. and so on. )

Re: Consume Table Function With Parameters From CDS View

former_member187095 — Thu, 09 Nov 2023 03:50:18 GMT

Avoid passing the table function client information during the join in the CDS view. Instead, include it while selecting fields from the table function. For instance, the table function alias is 'object' in your screenshot, and the syntax should be object(clnt: $session.client).Fieldname