Consume Table Function With Parameters From CDS View

[Former Member]

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.

[Former Member]

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.

[rajucd81]

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.

[Former Member]

So how would you consume a table function with parameters?

[rajucd81]

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.

[sakshi_sawhney]

In Select query pass the parameter like below

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

[former_member187095]

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