topic Re: cds view case syntax in Application Development and Automation Discussions

cds view case syntax

marco_sposa — Fri, 20 May 2022 12:36:49 GMT

Hello expert,

i'm struggling with a CDS view syntax.

According to fact that the supplier value is only numerical or aplhanumerical i will concatenate field in a different order.

in my case

something like

Thank in advance

case
when lifnr (is numerical)
then concat_with_space(...
else
concat_with_space(...
end as zdef

Re: cds view case syntax

Sandra_Rossi — Fri, 20 May 2022 13:37:21 GMT

What is your issue? Can you explain with example what is the input data, and what you expect?

Re: cds view case syntax

marco_sposa — Fri, 20 May 2022 14:13:43 GMT

Hello Sandra thank you for reply

i have a CDS view on reguh/regup table with an association to lfa1

i'm trying to build a consumption view in witch i have a new column with the concatenation of the address

the issue is that according to the value of lifnr i have to use reguh field for my concatenation when lifnr is numc ('12345' ) other wise (ABCDE) i have to concatenate the value for _lfa1.

i'm struggling with the syntax ( how to check if the value is numeric or not ) like the abap function check CATS_NUMERIC_INPUT_CHECK or using regex .

I read documentation about regex in cds with i can't figure out what is the correct syntax

Re: cds view case syntax

Sandra_Rossi — Sat, 21 May 2022 08:15:47 GMT

REPLACE_REGEXPR exists since ABAP 7.55. What is your version?

Moreover, it can be used only on a View Entity, not DDIC-Based View.

Re: cds view case syntax

marco_sposa — Mon, 23 May 2022 07:43:00 GMT

Hello thanx for your reply it's DDIC-based view and i'm not trying to cleansing the value just check if it's numeric or not, i though i could do it in the cds