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.
More SAP tools
See allKeep exploring
Free tools
- SAP Variant Condition Pricing CalculatorAdd variant surcharges to a base price, apply discount and see unit margin, order value and the discount at which margin disappears.
- SAP SD Condition Record Load WorksheetPrepare 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.
- SAP Variant Condition Pricing WorksheetPlan variant condition surcharges per characteristic value before you load them into SAP pricing, and total the configured price for test cases.
ERP fixes and how-tos
- SAP Pricing Error: Condition Record Missing for PR00 in a Sales OrderMandatory condition PR00 missing in a sales order? Use pricing analysis, check pricing procedure determination and create the condition record in VK11.
- SAP MM price determination: pricing procedure, condition types and fixing wrong PO pricesHow SAP MM determines purchase prices: the RM0000 calculation schema, condition types like PB00, schema determination, and how to fix a wrong price in ME21N.
- SAP MM Pricing Procedure Configuration (Calculation Schema, M/08)Configure the SAP MM pricing procedure (calculation schema): condition types, M/08, schema groups and determination, MEK1 condition records and account keys.