Ansicht
Dokumentation

ABAPSELECT_ALLOW_PRECISION_LOSS - SELECT ALLOW PRECISION LOSS

- ALLOW_PRECISION_LOSS

... ALLOW_PRECISION_LOSS( SUM( $[DISTINCT$] sql_exp )

Effect

The ALLOW_PRECISION_LOSS statement can improve the performance of an aggregate expression agg_exp at the cost of accuracy of the result. This function should only be used on decimal values and when loss of precision is acceptable. Currently, SUM is the only supported aggregate expression.

Note

A different result is not necessarily obtained when using the ALLOW_PRECISION_LOSS statement to sum up decimal values. A different result and simultaneous improvement in performance is only obtained during certain complex operations. One example is when operations are carried out in a different order to reduce the total number of operations. See the executable example below for further details.

Aggregate function, allow precision loss