SAP Note 22963 - Rounding problems in condition basis

Symptom:

If the condition unit is different from the sales unit, rounding errors may occur in pricing.

1. Example:

The base unit of measure and the sales unit of a material are KG. The price PR00 is 100.00 EUR for each American pound (LB). 4536 KG equals 10000 LB. Then you create an order with the quantity of 0.5 KG. The net value is then 1.102 LB * 100 EUR/1 LB = 110.20 EUR. However, the exact value is 110.23 EUR (rounded up from 110.229 EUR).

2. Example:

A material has the base unit of measure L (liter). As alternative units of measure, FL (bottles) and KAR (boxes) are used. The conversion factors are 5 FL = 1 L and 10 KAR = 96 L.
The price PR00 is 200.00 EUR for each box. An order for one bottle is created. The net value of the order is then 0.021 KAR * 200 EUR/1 KAR = 4.20 EUR. However, the correct value is 1/48 KAR * 200 EUR/1 KAR = 4.17 EUR.

Other terms

Pricing, rounding, quantity conversion, pound

Reason and Prerequisites

In the standard pricing, a condition basis with only 3 decimal places is used. For uneven conversion factors, this results in rounding problems.

Solution

In a condition value formula, the condition basis is recalculated with more accuracy, and this condition basis is used to determine a more accurate condition value. As in the standard system, currency translations that may be performed are carried out in Customizing of the condition types depending on the indicator "Currency translation" before or after the multiplication.

Restrictions

1. Do not attach the formula described below as calculation value formula 602 to subtotal lines in the pricing procedure.

2. The rounding logic according to the rounding rule in Customizing of the condition types (TXPRF) does not work; commercial rounding is always used (TXPRF = " ").

Procedure described in detail
Create a new condition value formula in the customer namespace (for example, 602) (transaction VOFM), and assign this condition value formula to the relevant condition type in the pricing procedure (transaction V/08).
To use the table T006 in the formula, you must change LV61ATOP for the specified releases.

Note that the solution outlined here is a workaround and is not included in the standard system. Inquiries and problem messages concerning this topic are not processed by regular support, but by consulting, and are subject to separate remuneration.