Edm.Decimal - not accepting decimal values in Gateway Calls

[former_member190939]

Hello Experts,

I have a service which looks like below :

And my gateway http call looks like below :

/sap/opu/odata/sap/ZUI5_MAIN_SRV/salesColl_saveInvoicesSet?$filter=AmountCol eq 1.00

The above call ends up in error always and the error is "Property 1.00 not found in type salesColl_saveInvoices".

But If I remove the decimal values, it is working fine.

/sap/opu/odata/sap/ZUI5_MAIN_SRV/salesColl_saveInvoicesSet?$filter=AmountCol eq 1

Where am I going wrong?

Thanks,

Seyed Ismail.

[JyotiD · Accepted solution]

Hi Seyed,

Can you try suffixing 'm' in you decimal value, It works for me.

/sap/opu/odata/sap/ZUI5_MAIN_SRV/salesColl_saveInvoicesSet?$filter=AmountCol eq 1.00m

Regards,

Tarun

[former_member190939 · Accepted solution]

Thank you Tarun, It worked. 🙂

Wondering what does 'm' mean actually...

Seyed Ismail.

[JyotiD · Accepted solution]

Hi Seyed,

Maybe this doc can help you understanding Odata protocol.

Overview (OData Version 2.0) · OData - the Best Way to REST

Regards,

Tarun

[AshwinDutt]

Hello Seyed,

Did you try to pass 1.02 , 1.20 , 1.2 and check ?

Regards,

Ashwin

[former_member190939]

Hello Ashwin,

Similar error.

Property 1.02 not found in type salesColl_saveInvoices

Property 1.20 not found in type salesColl_saveInvoices

Seyed Ismail.

[Pavan_Golesar]

Hi Seyed,

Please try following URI:

/sap/opu/odata/sap/ZUI5_MAIN_SRV/salesColl_saveInvoicesSet?$filter=AmountCol eq '1.00'

Does this work?

--

PG

[former_member190939]

Thanks,

Anyways for Edm.Decimal, we should not use '1.00'.

Seyed Ismail.