Static Rounding Profiles
Use
Static rounding profiles are used when you want to round up to a multiple of a unit of measure without changing the unit of measure. However, static rounding profiles can only be used to round up rather than round down quantities.
If you want to have the system round up and down, depending on the quantity, and even have it change the unit of measure where possible, you have to use dynamic rounding profiles. For more information, see Dynamic Rounding Profiles.
Prerequisites
You must define a rounding profile in Customizing. For more information, see Master Data and Customizing for Quantity Optimizing.
Features
A static rounding profile comprises threshold and rounding values, whereby every threshold value is assigned a rounding value. In rounding off, the system starts with the highest level in the rounding profile. It processes all the levels below that, carrying out the calculation until the procedure is stopped or until the lowest level is reached. The lowest level is processed differently, as the rounding logic is different here than in the other levels.
The steps in the procedure are as follows:
As long as the lowest level has not been reached:
It divides the quantity required into whole numbers by the rounding value of the current level.
It then checks whether the remainder is equal to or greater than the threshold value of the current level.
If yes:
It rounds up the quantity required to the next multiple of the rounding value of the current level and stops there.
If no:
It repeats the procedure with the next lower level.
If the lowest level has been reached:
It checks whether the quantity required is equal to or greater than the threshold value of the lowest level.
If yes:
It rounds up the quantity required to the next multiple of the rounding value of the first level and stops there.
If no:
It does not change the quantity required and stops there.
Example
Starting point
The base unit of measure for an article is kilogram, and for small quantities under 2 kg should not be rounded up or down. Quantities greater than 2kg should be rounded up to units of 100kg if rounding accounts for less than 200 kg.
Relevant static rounding profiles
The following static rounding profile covers the requirements above
Level |
Threshold values |
Rounding value |
1 |
2 |
100 |
2 |
301 |
500 |
Effect of the rounding profile (for quantities of 1 to 1000)
The following table illustrates how the static rounding profile creates quantity intervals from 1 to 1000. These intervals each have a particular value to which quantities are rounded off.
Quantity from |
To |
Rounded quantity |
1 |
1 |
1 |
1,5 |
1,5 |
1,5 |
3 |
100 |
100 |
101 |
200 |
200 |
201 |
300 |
300 |
301 |
500 |
500 |
501 |
600 |
600 |
601 |
700 |
700 |
701 |
799 |
800 |
801 |
1000 |
1000 |
Rounding procedure for a quantity of 2215 kilograms
With a quantity of 2215 kilograms, the procedure would be as follows:
...
1. The system would start at level 2, dividing the requirement quantity of 2215 by 500 (the rounding value for level 2).
2. The result is 4, with the remainder of 215 being smaller than 300 (the threshold value for level 2), so the system proceeds to the next smallest level (level 1).
3. The lowest level is level 1. The requirement quantity of 2215 is larger than 3 (threshold value of level 1), so the system rounds up the quantity to 2300.