3389733 - AMDP scripts and rounding in BW Transformations

The resulting values of an AMDP script/routine are not rounded as expected.
A typical example when the decimal type output field has lower number of decimals than the decimal or float type input fields.

For example if there is something like this in the AMDP script:

outtab = SELECT
...
FAMOUNT2 * FFLOAT AS FCALC1,
...

where:

• FAMOUNT2 is of type DEC 17,3 and has the value 1.789
• FFLOAT is of type FLOAT and has the value  1.000000000000000E+00
• FCALC1 is of type DEC 17,2

The result will be 1.78 despite the rounded value should be 1.79.

• SAP BW/4HANA
• SAP Netweaver 7.50
• SAP BW 7.5x

amdp, script, routine, round, rounding, round off, float, floating,  , KBA , BW4-DM-TRFN , SAP HANA execution in Transformation and DTP , BW-WHM-DST-TRF , Transformation , HAN-DB-SCR , SAP HANA SQL Script , Problem