Skip to Content
-2

Get all data that match to the regex.

Hi all

How to create a CDS that select all KUNNR from table KNA1 that Customer Number starts for example with 'A%'.

I could use LIKE in the where clause but the RHS of the condition have to be static. It should depends on the input parameter.

Is it possible to do it with CDS?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 15 at 01:16 PM
    Add comment
    10|10000 characters needed characters exceeded

    • After looking at the doc, carefully :), I'm not sure whether you can parameterize it. But as I said in your other thread, I don't know CDS. If I read the doc, I see that CDS is for defining "semantic data models". So, I guess that "LIKE :parameter" in the CDS is not possible because it's "not semantic enough", and it should be done only in the ABAP SELECT. Or maybe, it will be possible to do it in a future release.