SAP Knowledge Base Article - Public

3537245 - SAC OData query returns wrong decimal value

Symptom

When running SAC OData (CL_NAT_GENERIC_DPC) query, decimal value is wrong.
For example:

"Additi_Quan1" : "105" 105 is returned as decimal value, which is wrong, correct value should be "Additi_Quan1" : "105.XX"

Environment

  • Analytics Cloud
  • SAP Gateway (OData)

Reproducing the Issue

Run SAC OData (CL_NAT_GENERIC_DPC) query.

Cause

AnalyticsDetails.query.decimals annotation is missing in CDS view definition.

Resolution

Refer to below help docs to ensure AnalyticsDetails.query.decimals is correctly used:

AnalyticsDetails.query.decimals
https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/fc/596c7cb366440a84f9d41f7710d6ca/frameset.htm

General explanation
https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361387482.html 

See Also

https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/fc/596c7cb366440a84f9d41f7710d6ca/frameset.htm
https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361387482.html 

Keywords

AnalyticsDetails.query.decimals, CL_NAT_GENERIC_DPC, decimal, Edm.Decimal, Additi_Quan1, Additi_Quan1_F, Quantity, Quantity_F , KBA , OPU-GW-COR , Framework , BW-BEX-OT-BICS-EQ , oDATA Query / (Easy Query) , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions