# SAP Variant Condition Pricing Worksheet > Source: https://netray.co/tools/sap-variant-condition-pricing-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Plan variant condition surcharges per characteristic value before you load them into SAP pricing, and total the configured price for test cases. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP VC consultant - SD pricing consultant - Product configurator ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Variant condition key **Key:** vckey **Type:** text #### Characteristic **Key:** characteristic **Type:** text #### Characteristic value **Key:** value **Type:** text #### Surcharge basis **Key:** basis **Type:** select **Options:** - Fixed amount - Percent of base - Per unit #### Base price **Key:** base **Type:** number **Format:** currency #### Surcharge **Key:** surcharge **Type:** number **Format:** currency #### Configured price **Key:** line **Type:** number **Expr:** base + surcharge **Format:** currency **Rows:** **Vckey:** PUMP_MOTOR_15KW **Characteristic:** MOTOR_POWER **Value:** 15 kW **Basis:** Fixed amount **Base:** 4200 **Surcharge:** 650 **Vckey:** PUMP_MOTOR_22KW **Characteristic:** MOTOR_POWER **Value:** 22 kW **Basis:** Fixed amount **Base:** 4200 **Surcharge:** 1100 **Vckey:** PUMP_SEAL_MECH **Characteristic:** SEAL_TYPE **Value:** Mechanical **Basis:** Fixed amount **Base:** 4200 **Surcharge:** 280 **Vckey:** PUMP_MAT_SS316 **Characteristic:** WETTED_MATERIAL **Value:** SS316 **Basis:** Percent of base **Base:** 4200 **Surcharge:** 840 **Vckey:** PUMP_PAINT_RAL **Characteristic:** PAINT_COLOR **Value:** Special RAL **Basis:** Fixed amount **Base:** 4200 **Surcharge:** 120 **Totals:** #### Total surcharge **Key:** surcharge **Agg:** sum **Format:** currency #### Average configured price **Key:** line **Agg:** avg **Format:** currency **Summary:** #### Average uplift over base **Key:** uplift **Expr:** if(gt(avg_base,0), avg_surcharge / avg_base * 100, 0) **Format:** percent **Notes:** Variant conditions in SAP are condition records on a variant condition key assigned to a characteristic value. Use one row per value, keep the key short, and record the basis so the condition type setup matches. ## Content **Intro:** In SAP Variant Configuration, price differences between options are usually carried by variant conditions, not by separate materials. This worksheet lets you list every characteristic value that moves the price, its variant condition key and the surcharge, then check the configured price before anyone touches the condition records. **Sections:** #### How to use the worksheet **Body:** Add one row for each characteristic value that changes price. Enter the variant condition key you plan to assign in the characteristic value (the key is stored on the value and picked up by the pricing procedure through the condition type for variant pricing, commonly VA00). Enter the base price and the surcharge, and the worksheet shows the configured price and the average uplift. Export to Excel to hand the list to the pricing team. **Bullets:** - One row per value, not per characteristic - Keep the key unique and readable - Record the basis so percent and fixed amounts are not mixed up - Use the same values you will use in your test sales orders #### The method behind variant pricing **Body:** A configured sales order item carries the selected characteristic values. For each value that has a variant condition key, pricing reads the matching condition record for the key and adds the amount to the price of the configurable material. The base price comes from the material price condition (for example PR00), the surcharge from the variant condition type. Because the keys are read at pricing time, a missing record does not stop the order, it silently prices at zero for that value. #### Reading the result **Body:** The configured price column is base plus surcharge for a single option. The summary shows the average uplift as a percent of the base, which is a quick sanity check against the price list approved by sales. If one row shows an uplift far from the others, check whether it should be a percentage condition. Always test the full combination in a sales order, because variant conditions add up across all selected values. #### Common mistakes **Body:** The most frequent defect is a characteristic value with a variant condition key but no valid condition record for the sales organisation, distribution channel or date. Others are reusing one key across values with different prices, forgetting currency conversion for export price lists, and changing a key after records exist. Keep this worksheet under version control with the transport it belongs to. **Cta:** If you maintain variant conditions across many configurable materials and want checks run against live condition records, we can build a read-only comparison against your system. **Faq:** #### What is a variant condition key in SAP? **Answer:** It is a key assigned to a characteristic value that pricing uses to find a variant condition record. When the value is selected in a configuration, pricing reads the record for that key and adds the amount to the item price. #### Can variant conditions be percentage based? **Answer:** Yes. The condition type determines the calculation type, so you can set up fixed amount, percentage or quantity based variant conditions. Record the basis in the worksheet so the condition type chosen matches what pricing agreed. #### Why does my configured item price at zero for an option? **Answer:** Usually there is no valid condition record for the key in the sales area and date, or the key was not assigned to the value. Check the pricing analysis on the order item and the key on the characteristic value. #### Does this replace the SAP condition record screens? **Answer:** No. It is a planning and review aid. You still create the condition records in SAP. The worksheet helps you agree keys and amounts and export them for review first. ## Search terms SAP variant condition pricing, SAP VA00 variant condition, SAP variant pricing excel, SAP VC pricing worksheet, SAP configurable material pricing, SAP variant condition key, SAP VK11 variant condition, SAP characteristic surcharge --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json