# SAP SD Condition Record Load Worksheet > Source: https://netray.co/tools/sap-sd-condition-record-load-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer 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. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP SD consultant - Pricing analyst - Data migration lead ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Condition type **Key:** ctype **Type:** select **Options:** - PR00 - K004 - K005 - K007 - KF00 - Z001 #### Access (key combination) **Key:** table **Type:** select **Options:** - Customer/Material - Material - Price list/Material - Customer - Material group #### Sales org **Key:** salesorg **Type:** text #### Dist. channel **Key:** chan **Type:** text #### Customer / price list **Key:** customer **Type:** text #### Material **Key:** material **Type:** text #### Amount **Key:** amount **Type:** number **Format:** currency #### Per **Key:** per **Type:** number #### UoM **Key:** uom **Type:** select **Options:** - EA - KG - M - PC - L #### Value per 1 UoM **Key:** unit_price **Type:** number **Expr:** amount / per **Format:** currency #### Valid from **Key:** from **Type:** date #### Valid to **Key:** to **Type:** date **Rows:** **Ctype:** PR00 **Table:** Material **Salesorg:** 1000 **Chan:** 10 **Material:** MAT-1001 **Amount:** 125 **Per:** 1 **Uom:** EA **From:** 2027-01-01 **To:** 9999-12-31 **Ctype:** PR00 **Table:** Material **Salesorg:** 1000 **Chan:** 10 **Material:** MAT-2040 **Amount:** 840 **Per:** 100 **Uom:** M **From:** 2027-01-01 **To:** 9999-12-31 **Ctype:** PR00 **Table:** Customer/Material **Salesorg:** 1000 **Chan:** 10 **Customer:** 100234 **Material:** MAT-1001 **Amount:** 118.5 **Per:** 1 **Uom:** EA **From:** 2027-01-01 **To:** 2027-12-31 **Ctype:** KF00 **Table:** Customer **Salesorg:** 1000 **Chan:** 10 **Customer:** 100234 **Amount:** 45 **Per:** 1 **Uom:** EA **From:** 2027-01-01 **To:** 9999-12-31 **Ctype:** K005 **Table:** Customer/Material **Salesorg:** 1000 **Chan:** 10 **Customer:** 100877 **Material:** MAT-3300 **Amount:** 12 **Per:** 1 **Uom:** EA **From:** 2027-01-01 **To:** 2027-06-30 **Totals:** #### Sum of amounts **Key:** amount **Agg:** sum **Format:** currency **Summary:** #### Condition records **Key:** records **Expr:** count **Format:** integer **Primary:** true **Notes:** Percentage discounts (such as K005 in percent) and values entered per 100 or per 1,000 units should be reviewed before load: the computed column divides the amount by the Per field and is meaningful for currency values only. Condition type codes are examples, check your pricing procedure. ## Content **Intro:** Pricing data usually reaches SAP from a spreadsheet. Use this worksheet to lay out condition records with the key fields in order, see the per-unit value, and export a clean sheet for your upload method. **Sections:** #### How to use the worksheet **Body:** Add one row per condition record. Choose the condition type and the access, enter the key values such as sales org, channel, customer and material, then the amount, the pricing unit (Per), the unit of measure and the validity dates. The Value per 1 UoM column checks your price scale. Export to Excel and map columns to your load tool, whether that is LSMW, the S/4HANA migration cockpit, or manual entry in VK11. #### How condition records work **Body:** A condition record stores a value for a condition type under a key defined by an access sequence. For PR00 the access sequence normally looks for a customer-specific price first, then a price list, then a general material price. The Per and UoM fields define the pricing quantity, so 840 per 100 M is 8.40 per metre. Validity dates must not overlap for the same key unless you want SAP to delimit them. **Bullets:** - Most specific key is read first - Per defines the pricing quantity - Valid-to of 9999-12-31 means open ended - Scales need separate scale lines in VK11 #### Checking the result **Body:** Sort by material and look for duplicate keys, empty validity dates and units that differ between records of the same material. If a customer price is higher than the list price, confirm that is intended. Currency, unit conversions and rounding in the pricing procedure can change the price shown on the order, so always test two or three records in VA01 with the pricing analysis. #### Common mistakes **Body:** Common faults are loading records against the wrong sales org, mixing price per unit with price per 100, loading percentages into a value condition type, and ignoring that the condition type is not in the pricing procedure assigned to the customer. A record can be perfect and still never be found if the access sequence or procedure is missing the key field. **Cta:** If you load large price lists often, Netray can help build a validated, read-only comparison between your spreadsheet and the live condition tables before you upload. **Faq:** #### Can I upload this directly to SAP? **Answer:** The export is a clean Excel layout. You then map it to your upload method, such as the S/4HANA migration cockpit, LSMW or a recorded VK11 batch. The column names are intentionally generic so they can be mapped. #### What does Per mean in a condition record? **Answer:** Per is the quantity the amount applies to, together with the unit of measure. An amount of 840 per 100 M means 840 for every 100 metres. It is the pricing unit, not the order quantity. #### Why is my price not found on the order? **Answer:** Check the pricing procedure includes the condition type, the access sequence includes your key, the validity covers the pricing date, and the customer pricing procedure and document pricing procedure resolve to the procedure you expect. #### What is PR00? **Answer:** PR00 is the standard price condition type delivered with the SAP pricing procedure RVAA01. Many companies copy it or add their own Z condition types, so confirm the code in your own system. ## Search terms sap condition record upload excel, sap pr00 price upload template, sap vk11 mass upload, sap pricing condition load sheet, sap condition records migration template, sap price list excel template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json