SAP Knowledge Base Article - Preview

3681968 - Decimal data type display difference between HANA Studio and HANA Database Explorer

Symptom

  • Decimal values are stored differently in the cloud environment compared to the on-premises system.
  • In the on-premises system, inserting '0' for a decimal (10,2) stores it as 0, whereas in the cloud environment, the same decimal (10,2) is stored as 0.00.
  • This discrepancy causes data validation issues.


Read more...

Environment

  • HANA Cloud Services HANA Cloud

Product

SAP HANA Cloud 1.0

Keywords

decimal data type, hana studio, hana database explorer, data validation, cloud environment, on-premises system, discrepancy, decimal storage, command line interface, hana cloud, data type behavior , KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , Problem

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.