Get all data that match to the regex.

[former_member267947]

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

[horst_keller]

You can use built-in functions. See the documentation.

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abencds_f1_builtin...

[former_member267947]

Which built-in function can I use to build the regex for where clause?

For example, String Functions can not be used in the where clause.

Thanks

[Sandra_Rossi]

Read carefully the documentation. It's not obvious for novices, so read the pages several times. You'll get to that one -> ABAP CDS - cond_expr, WHERE. Of course, there's no regular expression around, but LEFT (for instance) is equivalent to LIKE 'A%'.

[former_member267947]

I tried as following:

@AbapCatalog.sqlViewName: 'ZAMPAYERINFO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Read payer information'
define view zam_payer_info
  with parameters
    p_payer :kunnr
  as select distinct from knvp
    join                  kna1 on knvp.kunnr = kna1.kunnr
{
  key knvp.kunnr as Payer,
      kna1.name1 as Name


}
where knvp.kunnr = left (:p_payer, 10)

But it does not work at all. What am I doing wrong?

Thanks

[SudarshanS]

Hi, a related question,

Am looking for a HANA SPS12 CDS equivalent of SUBSTR_REGEXPR() function. Couldn't find any after searching through the help docs. Please can you suggest an alternative?

Thanks

Sudarshan

https://help.sap.com/viewer/7c78579ce9b14a669c1f3295b0d8ca16/Cloud/en-US/a2f80e8ac8904c13959c69bfc30...