SAP SD Pricing Condition Price Calculator
Pricing is the most configured part of SAP SD, and consultants constantly need a quick way to check what a procedure will do to a line before touching customizing. This calculator walks one order line through list price, stacked discounts, a surcharge, freight and tax.
Your numbers
Amount on the PR00 condition record.
The 'per' value on the condition record, for example 1 or 100.
Depends on the From/To steps and condition base in your pricing procedure.
Your results
Simplified model of a pricing procedure. Your real procedure may use different from/to steps, rounding, scales and subtotals.
Margin and effective discount vs customer discount
Sweeps Customer discount (K007) from 0 to 40, holding your other inputs fixed.
Pricing procedure review
Send us an anonymised procedure and we will point out redundant steps and base mismatches.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Enter the PR00 amount and its pricing unit, the order quantity and the percentage discounts that your procedure would find through condition records. Choose whether discounts are taken sequentially on the running subtotal or all against the gross value. The outputs show the effective discount, net value, invoice total and margin against standard cost. Move the customer discount slider and watch the chart to see how fast margin erodes.
- Use the pricing unit for conditions maintained per 100 or per 1000
- Switch the discount base to compare two procedure designs
- Freight and tax sit after net value, as in most procedures
The logic behind it
In a pricing procedure each step has a condition type, a from/to range, a subtotal and a calculation type. Percentage conditions are calculated on a base: either the gross subtotal or the running subtotal if the From column points at an earlier subtotal line. With sequential discounts of 5, 3 and 2 percent, the effective discount is 1 minus the product of the three remaining factors, slightly lower than the plain sum of 10 percent.
Worked example
At 1250 per unit for 200 units the gross value is 250,000. Sequential discounts of 5, 3 and 2 percent give an effective discount of about 9.7 percent, so the discounted value is near 225,700. A 1.5 percent surcharge lifts the net value to about 229,100. Against a standard cost of 780 the margin is close to 31.9 percent. Raise the customer discount to 15 percent and the margin drops sharply.
Common mistakes
The usual errors are mixing up the condition base, forgetting that a condition record can have a scale, and ignoring the pricing unit. Also remember that real procedures exclude some conditions from the net value, such as statistical conditions, and that rounding rules and currency decimals can change the cents.
- Check the From column of every discount step
- Check condition exclusion groups
- Do not compare margin against moving average price if the company uses standard price
Frequently Asked Questions
Does this replace transaction VK13 or the pricing analysis?
No. It is a design and teaching aid. The pricing analysis in the sales order shows exactly what the system did for one item, and VK13 displays condition records. Use this tool to test ideas on paper before configuring.
Why is the effective discount lower than the sum?
When discounts are taken sequentially, each one applies to an already reduced value. Three discounts of 5, 3 and 2 percent multiply to 90.3 percent remaining, a 9.7 percent total discount, not 10 percent.
Can it model scales or minimum prices?
Not directly. Run it once per scale level and compare. Minimum price conditions can be tested by checking whether the net value per unit falls below your floor value.
Which currency does it use?
The page shows dollars for display only. The arithmetic is currency neutral, so enter amounts in your document currency.
If your pricing procedure has grown to dozens of steps and nobody can explain a price, we can build a read-only assistant over your condition tables that explains how any item price was reached.
Related Tools
SAP SD Volume Rebate Accrual Calculator
Model a tiered volume rebate agreement: year-to-date accrual, forecast payout and the effect of retroactive versus incremental scales.
SAPSAP SD Milestone Billing Plan Calculator
Split a contract value across milestones, clear an advance proportionally and see the net invoice and retention for each step.
SAPSAP SD Condition Record Load Worksheet
Prepare price and discount condition records row by row, check the per-unit value and export to Excel for LSMW, migration cockpit or manual VK11 entry.
SAPSAP SD Credit Exposure Simulator
Add up the components of credit exposure and test whether a new sales order would exceed the credit limit.