Question Re: SAP CDS Parameter without leading zero in Technology Q&A

SAP CDS Parameter without leading zero

hassin — Mon, 07 Mar 2022 11:38:10 GMT

Hello Guys,

I have a question about the use of parameters in my CDS Code.

For example I'm want to search via parameter a specific material.

In our DB all material have leading zeros.

But I want to enter the materialnummer without the leading zero.

Down you can see my code, hava you idea/tip how I can solve this problem?

Regads

Hassin

@AbapCatalog.sqlViewName: 'ZCS_MARA_PARA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'VDS View with Parameter'

define view ZCS_MARA_Test1_PARA
    with parameters p_matnr : matnr, p_ernam : ernam
as select from ZCP_MARAView_Test1 

{
    //ZCP_MARAView_Test1
    ltrim(matnr,'0')    as Materialnummer,
    ersda               as Angelegt_Am,
    ernam               as Angelegt_Von,
    laeda               as Geaedert_Am,
    aenam               as Geaendert_Von
}
where   matnr = :p_matnr

Re: SAP CDS Parameter without leading zero

Cocquerel — Mon, 07 Mar 2022 12:28:03 GMT

Would changing the WHERE clause this way fit your requirement ?

where ltrim(matnr,'0') = :p_matnr

Re: SAP CDS Parameter without leading zero

hassin — Mon, 07 Mar 2022 13:06:23 GMT

It would fit my requirement but I get an error.

User-defined functions are not supported in the WHERE clause

Re: SAP CDS Parameter without leading zero

Cocquerel — Fri, 11 Mar 2022 08:27:45 GMT

maybe it is because of your HANA version because when running the following statement on my system that 2.0 SPS05, it is working fine.

select ltrim('000111','0') from dummy
where ltrim('000111','0') = '111'

Re: SAP CDS Parameter without leading zero

hassin — Wed, 12 Oct 2022 08:39:37 GMT

To solve this issue you have to use "ltrim(matnr,'0') as Matnr_Test" one view before.