Why Do Some FLOAT Field Values Contain More Decimal Places in My Destination Than in SAP HANA?

Question

Why do some FLOAT field values contain more decimal places in my destination than in SAP HANA?

Environment

• Connector: SAP ERP on HANA
• Field data type: FLOAT

Answer

FLOAT field values appear in SAP HANA with a limited or defined number of decimal places. However, SAP HANA stores these values using scientific notation with many more decimal places, and we sync the values as they're stored. As a result, the values you see in your destination may contain more decimal places than you see in SAP HANA.

Use the DB02 transaction in the SQL editor to see the exact stored value of a FLOAT field value. See SAP's Database Administration Functions documentation for more information.

Use one of the following options to ensure the value appears in your destination with the same number of decimal places:

• In SAP HANA, update the applicable field data type to DECIMAL.
• Utilize dbt transformations to change the field data type to DECIMAL.
• Limit the number of decimal places displayed in your destination by applying casting functions to queries.
• Create a view of the destination table with a casting function that limits the number of decimal places displayed.