SAP Knowledge Base Article - Preview

2639497 - Unexpected decimal places in HANA Studio


The result in HANA Studio shows unexpected decimal places.

For example, a field has data type DECIMAL(20, 5), when you select it, it shows fewer decimal places.


While you may find the result is different in hdbsql.


Also when you convert it to varchar or nvarchar data type, the result has correct decimal places.


Due to this issue, you may get unexpected result of decimal precision by 'Data Preview' during modeling.



  • HANA Platform 1.0
  • HANA Platform 2.0


SAP HANA 1.0, platform edition ; SAP HANA studio 1.0 ; SAP HANA studio 1.5 ; SAP HANA, platform edition 2.0


unexpected result; wrong result; decimal; decimal places; precision; data preview; HANA studio; hdbsql , KBA , HAN-STD-ADM-DBA , SAP HANA Studio (Eclipse) Admin Tooling , HAN-DB , SAP HANA Database , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.