How To Fix R7B136 - Inexactitudes d'arrondi avec type données FLOAT pour AMOUNT et QUANTITY

SAP Error Message - Details

• Message type: E = Error

• Message class: R7B - BW Metadata (InfoCube, InfoObject, InfoObject catalog)

• Message number: 136

• Message text: Inexactitudes d'arrondi avec type données FLOAT pour AMOUNT et QUANTITY

Quelle est la cause de ce problème?

ABAP data type FLOAT is an implementation of the IEEE data type DOUBLE.
In most databases<(>,<)> this data type is also implemented according to
the IEEE specification.
This data type is a floating point data type with mantissa and exponent
encoded in base 2. Because the conversion from base 10 to base 2 is
technically not possible without loss of accuracy for many numbers,
using FLOAT always results in rounding inaccuracies. Examples include
0.15, 25.5 and many more. They cannot be expressed exactly as FLOATs.
SAP Note 2798 describes some of the effects of this behavior. A decimal
shift can cause rounding inaccuracies for example.
All arithmetic operations on FLOAT cause additional inaccuracies. A
simple addition of 2 values has an inaccuracy in the last digit (15).
For 10 additions<(>,<)> you lose 1 digit in accuracy. For 100 additions
<(>,<)> 2 digits are lost, and for 1<(>,<)>000,000 additions 6 digits
are lost. The result of database aggregation SUM on 1 million records
has a remaining accuracy of 8 digits instead of 14 digits. Aggregating 1
billion rows means that only 5 digits will be correct.
Data type FLOAT is therefore not suitable for business-relevant data
like amounts and quantities<(>,<)> where exact results are required (for
example financial key figures).

Réponse du système

The system raises a warning if this key figure is defined. The key
figure is used as defined.

Comment corriger cette erreur?

Check the key figure definition and change it if used in
business-relevant scenarios. Suitable data types are the ones that the
system proposes by default when you create a key figure. These types use
decimal packed numbers and do not have the specific rounding
inaccuracies of FLOAT.

Procédure pour les administrateurs système

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Extrait du message d'erreur du système SAP. Copyright SAP SE.