SAP BOM Component Scrap and Requirements Worksheet
Component requirement quantities in SAP depend on order quantity, BOM base quantity and several scrap percentages. This worksheet lets you test those numbers row by row before loading a BOM or reviewing why an order shows a particular component quantity.
| Component | UoM | Order quantity | BOM base qty | Component qty in BOM | Component scrap % | Assembly scrap % | Required quantity | Unit cost | Extended cost | |
|---|---|---|---|---|---|---|---|---|---|---|
262.65 | $3,730 | |||||||||
1,040.3 | $884 | |||||||||
405.5625 | $130 | |||||||||
339.9 | $14 | |||||||||
2,060 | $124 |
Both scrap percentages are applied as multiplicative markups. In SAP, assembly scrap increases the requirement of all components of the assembly, and component scrap increases the requirement of one component. Confirm the exact behavior, including network scrap and operation scrap, in your own system before relying on it. Tweak the quantity column for a different order size and export to Excel.
BOM and reservation check
Optional: compare expected component requirements with what your SAP orders actually reserve.
Optional. The tool and every export work without this. No spam.
How to use this worksheet
Add one row per BOM component. Enter the order quantity, the BOM base quantity and the component quantity as stored in the BOM item (STPO-MENGE). Add the component scrap percentage from the item and the assembly scrap percentage from the MRP 4 view of the parent material. The worksheet calculates the required quantity and the extended cost, then totals the cost.
- Delete the sample rows and paste your own or add rows one by one.
- Export to Excel to share with the BOM owner or costing team.
How scrap enters the calculation
The base requirement is order quantity divided by BOM base quantity times item quantity. Component scrap, set on the item (and optionally in the MRP 4 view of the component), adds a percentage to that component only. Assembly scrap, set in the MRP 1 or MRP 4 view of the parent, scales up every component of the parent in the BOM explosion. Operation scrap on routing operations is a third type and is not included here.
Reading the output
Compare the required quantity with the quantity on the production order reservation (COOIS component view or CO03). A difference usually means that the scrap indicator, a different BOM alternative, or a different lot size applied. The extended cost helps you see which components carry the scrap penalty, and scrap on high value items deserves attention first.
- Check for the relevancy to costing and BOM item category (stock item vs non stock).
- Material with a fixed quantity indicator does not scale with order size.
Common mistakes
Entering scrap twice, once in the item and once in the material master, inflates requirements. Wrong base quantity (for example BOM base 100 with item quantity per piece) is the other classic. Also remember that the unit of measure of the BOM item may differ from the base unit of the component.
Frequently Asked Questions
What is the difference between assembly scrap and component scrap?
Assembly scrap is a percentage on the parent that increases the requirement for all of its components. Component scrap is a percentage on one BOM item that increases only that component.
Where do I maintain assembly scrap?
In the MRP 1 view of the parent material master (field Assembly scrap, MARC-AUSSS). Component scrap is in the BOM item (CS02) and a component scrap default can be maintained in MRP 4.
Does MRP use these scrap values?
Yes. MRP uses assembly and component scrap when exploding the BOM to create dependent requirements, and the production order reservation takes over the same values at order creation.
Why do my numbers differ from the SAP order?
The order may use a different BOM alternative, lot size, rounding, operation scrap, or a recalculated explosion date. Check the order header BOM selection and the reservation list.
Netray can read BOM and order reservation data from SAP and flag components whose reserved quantity does not match the expected explosion, read-only and for review.
Related Tools
SAP PP Production Order Variance Calculator
Break the difference between target and actual production order cost into price, usage, rate and efficiency variances.
SAPSAP PP Operation Lead Time Scheduling Calculator
See how queue, setup, processing, teardown, wait and move times add up to operation lead time for any lot size.
SAPSAP PP Master Data Change Request Template
A controlled change form for BOMs, routings, work centers and MRP data with impact assessment, approvals and rollback.
More SAP tools
See allKeep exploring
Free tools
- SAP PP Economic Production Quantity Lot Size CalculatorFind the cost-minimizing lot size for an in-house part using setup cost, holding cost and production rate, and see how setup cost moves it.
- SAP PP Database Tables ReferenceA lookup of the main SAP PP database tables, what each holds and the key fields to join on.
- SAP PP Kanban Quantity and Container CalculatorSize an SAP kanban control cycle: how many kanbans of what quantity cover demand during replenishment, plus the maximum inventory they imply.
ERP fixes and how-tos
- Phantom Assembly in SAP PP: Setup, Example and MRP BehaviourSet up a phantom assembly in SAP PP with special procurement key 50. Worked example showing the BOM, MRP explosion and how the production order behaves.
- SAP PP End to End Configuration: Steps, IMG Paths and Process FlowSAP PP end to end configuration in order: organizational structure, master data, MRP, order types, confirmation, costing and settlement, with IMG paths and tcodes.
- Planning Strategy 40 in SAP PP, with a Worked ExamplePlanning strategy 40 (planning with final assembly) with a worked MTS example: PIR consumption, MRP results in MD04, setup and common mistakes in SAP PP.
Guides
- ERP Requirements for Electronics Manufacturers: What EMS Providers and OEMs Actually NeedERP requirements for electronics manufacturers: BOM and AML management, component lifecycle, traceability, compliance, costing, and AI agents for EMS and OEMs.
- How to Quote PCB Assembly From a Customer BOMStep by step PCB assembly quoting from a customer BOM: part matching, price breaks, lead time risk, overage and attrition, and quote validity for EMS shops.
AI on your ERP
- AI on SAP Business One for Electronics Manufacturers: BOMs, Shortages and TraceabilityPrivate AI on SAP Business One for electronics makers: multi-level BOM questions, component shortages, lot and serial traceability, RoHS and obsolescence checks.
- AI for EMS and PCBA Manufacturers Running SyteLine, Epicor, or NetSuiteAI for EMS and PCBA manufacturers on SyteLine, Epicor, or NetSuite: automate BOM scrubbing, AVL checks, and obsolescence alerts, grounded in your own ERP data on-prem.
Software
- Z2DataZ2Data is a component and supply chain intelligence platform for electronics risk, compliance and lifecycle data. See modules, integrations and alternatives.
- SiliconExpertSiliconExpert is an electronic component intelligence service covering lifecycle, compliance and cross-references. See modules, integrations and alternatives.