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