ABAPSELECT_ALLOW_PRECISION_LOSS - SELECT ALLOW PRECISION LOSS

BAL Application Log Documentation   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

- 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

rdisp/max_wprun_time - Maximum work process run time   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 1515 Date: 20230207 Time: 090642     sap01-206 ( 34 ms )