topic Optional parameters on CDS Views? in Application Development and Automation Discussions

Optional parameters on CDS Views?

former_member186444 — Tue, 21 Jul 2015 10:26:43 GMT

As far as I can tell (as I cannot find reference to it anywhere), it's not possible to define an optional parameter for a CDS view.

Is that correct? Thanks.

Re: Optional parameters on CDS Views?

pfefferf — Tue, 21 Jul 2015 10:42:22 GMT

Hello Malcolm,

no, optional parameters are not possible (at the moment). To each input parameter an actual parameter must be assigned. Please take a look to paragraph "Notes" in online help ABAP Keyword Documentation.

Best Regards,

Florian

Re: Optional parameters on CDS Views?

former_member186444 — Tue, 21 Jul 2015 10:49:20 GMT

I just spotted that in the help at the same time as your reply came in! Thanks Florian.

I'm just wondering what the alternative is now. Would it be to put it in the projection list instead and then add it to the WHERE clause of the caller if it's filled and not add it to the WHERE clause when it isn't filled?

Re: Optional parameters on CDS Views?

jasmin_gruschke — Tue, 21 Jul 2015 11:50:11 GMT

Hi Malcolm,

I'd say, that depends... e.g. if you are using aggregations in the view.

But I'd say it's a good workaround if applicable, so I understand instead of passing a filter value to the view in form of an input parameter, you're adding the (to be filtered) field to the projection list and leave the filtering to the consumer, right?

Question is, how will you consume the view? If it's Open SQL you can of course use a default value (in the Open SQL) or the given filter value in case it's given... same holds for IDA ALV, you can pass the default in the ABAP coding.

Cheers,
Jasmin

Re: Optional parameters on CDS Views?

Former Member — Tue, 30 Aug 2016 12:02:20 GMT

Is there any way to make parameters optional in abap cds views, say via annotations...?

Any possibility now?

Re: Optional parameters on CDS Views?

vincenzocappelluti — Fri, 05 Feb 2021 09:18:18 GMT

any update in 2021?