SAP Rounding Profiles in SD

SAP Logo

While researching solutions for a client, I learned quite a bit about SAP’s rounding capabilities.  In my experience, I haven’t encountered a situation where this EXACT functionality would be necessary, but I’m sure it will come in handy for a few of you folks out there.  Let’s find out a bit more about SAP Rounding Profiles.

WHAT ARE SAP ROUNDING PROFILES?

If you’ve found this post, you probably already know a bit about them, but here’s a run-down.  In an order entry context, rounding profiles allow you to set up rules capable of automatically adjusting Sales Order quantities at time of order entry.  Why would you want to do this?  Here’s an example:

You have a product in inventory with a base unit of Case (CS).  For most customers, you do not wish to have any limitations for how they order — one case, two cases, whatever.  But let’s say you have certain customers who order a lot of product and due to logistics requirements you wish for them to order this item in pallet quantities (PAL).  You can assign a rule to that customer/material combination which will automatically adjust the Sales Order quantities to match what’s in a pallet.

Another example would be if you wish to round order quantities up or down to more closely align with your desired units of measure.  Let’s say a pallet of a particular item consists of 100 cases.  A customer submits an order for 90 cases.  Instead of building 90% of a pallet, you wish to just round the customer’s order up to 100 cases and ship a full pallet.  The same can be done if the order is for 105 cases; you can round down in this case.

SAP Rounding Profiles: Getting Technical

There are three types of Rounding Profiles available to you:

ROUNDING-006
An example of a static rounding profile containing multiple sets of rules.
ROUNDING-005
Results from the Static Rounding Profile Simulation for our example.

A Static rounding profile is the most simple and straightforward.  You establish one or more sets of Threshold Values and Rounding Values.  Once your order meets the Threshold Value, SAP will automatically round up to the Rounding Value.  You can maintain as many rows as you want in each rounding profile to meet your needs.  Let’s say that you want the customer to be able to purchase in increments of 1.  However, after they reach 5 units, you want them to purchase in increments of 10.  Lastly, after reaching 40 units, you want the customer to order in increments of 25 units.  Check out the above screenshot to see the sets or rules to accomplish this.  Clicking on the Simulation button will allow you to test the effects of your rules for a range of quantities.

A Dynamic profile offers a significantly different set of features.  However, before discussing the profile, it is important to understand the use of Rounding Rules… [content missing] …down automatically.  For example, you can specify a rule which automatically rounds up when a customer orders 90+ percent of a pallet.  Let’s use an example:

A material has a base unit of Eaches, but is also sold in Cases (24 EA), Layers (10 CAS), and Pallets (20 LAY).  To keep it simple, let’s assume that you want to establish 90% thresholds for all Units of Measure.  When a customer orders in quantities equaling or exceeding 90% of a Case (21.6 Eaches), then SAP will automatically round up to a case.  When a customer orders in quantities equaling or exceeding 90% of a Layer (9 Cases), then SAP will automatically round up to a Layer.  Finally, when a customer orders in quantities equaling or exceeding 90% of a Pallet (17 LAY), SAP will automatically round up to a Pallet.    The Rounding Profile has a similar function to round down.  So, if a customer orders in quantities less than 10% OVER a Case (26.4 Eaches), then SAP will round down to 1 Case.  …and so on.

Dynamic Rounding Profile
Dynamic Rounding Profile

Once created, these rounding rules can be assigned to the Dynamic Rounding Profiles.  The Dynamic Profiles can be assigned in a couple of different ways — directly on the material master or through a Customer Material Info Record.

Rounding-Prof-002
Rounding Methods with customer-specific options

Paired with a Rounding Rule, the Dynamic Profile also contains a mandatory Rounding Method.  The Rounding method contains several options for handling line item rounding.  It’s important to note that three custom Methods are available for customization — see Note 303613 for details.

Like the Static profile, the Dynamic profile also includes a Simulation function to test the setup prior to implementation, which is nice.

There is a third rounding profile option called Qty t/b added/subtracted.  Curiously, this option is not fully explained in the IMG configuration documentation.  I’m not going to speculate what this profile is capable of; if you’re reading this and you *DO* know, please let us know in the comments.

WRAP-UP

These rounding capabilities are incredibly powerful and — especially thanks to customer-specific options — incredibly flexible.  I could see these being heavily used for warehouse transactions as well as sales transactions where special rounding agreements exist with customers.  The handy simulation feature makes it easy to play around with without being fully committed to creating profiles.  Check it out and let me know what you think.

9 thoughts on “SAP Rounding Profiles in SD

  1. when i am executing an ecatt, getting a pop-up asking that rounding data already exists, round order quantity?

    but i didn’t created any rounding profile.
    due to this my ecatt is getting failed.
    my concern here is how can i deactivate the default rounding profile assigned to that material.

    1. If there is no rounding profile for that material in your Sales Area, there are some other places to look. Check the ‘Delivery Unit’ field on the Sales Org 1 tab; the order will force the customer to purchase in certain increments — like quantities of 10, for example. Also check the Customer Material Info Record (CMIR); there is a customer/material specific rounding profile maintainable here too. If you don’t find anything there, it may be a ‘UoM Group’ setting on the inforecord or customer master. Good luck!

  2. Is there a way to set some type of rounding profile by material number and not just for a specific customer?

    1. There is a rounding profile on the material master. It will most likely involve some config to establish your preferred rounding rules. Then you just set it on the material master — not sure which view, but probably a Sales view. The CMIR’s profile will Trump the Material one.

  3. hello, in you case of dynamic rounding profile, which rounding method is selected? where to set the value like 24EA, and 90%?

Leave a Reply

Your email address will not be published. Required fields are marked *