# SAP Subcontracting Component Tracking Worksheet > Source: https://netray.co/tools/sap-subcontracting-component-tracking-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track components sent to a subcontractor, expected consumption and what should still be on their premises. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP MM consultant - Buyer - Inventory controller - Production planner ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Subcontract PO **Key:** po **Type:** text #### Component **Key:** component **Type:** text #### Qty per finished unit **Key:** bom_qty **Type:** number #### Qty sent (541) **Key:** sent **Type:** number #### Finished units received (101) **Key:** fg_received **Type:** number #### Expected consumption **Key:** consumed **Type:** number **Expr:** bom_qty * fg_received **Format:** number #### Expected at vendor **Key:** expected **Type:** number **Expr:** sent - bom_qty * fg_received **Format:** number #### Vendor reported stock **Key:** counted **Type:** number #### Variance **Key:** variance **Type:** number **Expr:** counted - (sent - bom_qty * fg_received) **Format:** number #### Unit cost **Key:** unit_cost **Type:** number **Format:** currency #### Variance value **Key:** var_value **Type:** number **Expr:** variance * unit_cost **Format:** currency **Rows:** **Po:** 4500128001 **Component:** Housing blank HB-220 **Bom qty:** 1 **Sent:** 500 **Fg received:** 320 **Counted:** 178 **Unit cost:** 14.5 **Po:** 4500128001 **Component:** Insert M6 brass **Bom qty:** 4 **Sent:** 2000 **Fg received:** 320 **Counted:** 718 **Unit cost:** 0.32 **Po:** 4500128044 **Component:** Shaft blank SB-18 **Bom qty:** 1 **Sent:** 300 **Fg received:** 300 **Counted:** 4 **Unit cost:** 9.8 **Po:** 4500128044 **Component:** Seal ring SR-18 **Bom qty:** 2 **Sent:** 620 **Fg received:** 300 **Counted:** 20 **Unit cost:** 1.1 **Po:** 4500128090 **Component:** PCB panel PNL-77 **Bom qty:** 1 **Sent:** 150 **Fg received:** 90 **Counted:** 62 **Unit cost:** 22 **Totals:** #### Net unit variance **Key:** variance **Agg:** sum **Format:** number #### Net variance value **Key:** var_value **Agg:** sum **Format:** currency **Summary:** #### Lines tracked **Key:** abs_note **Expr:** count **Format:** integer **Currency:** $ **Notes:** Expected stock at the vendor is quantity sent less BOM quantity times finished units received. In SAP, components provided to a subcontractor are posted with movement type 541 and consumed when the finished goods receipt is posted. Scrap and yield loss show up as variance, so agree an allowed scrap rate in the contract. ## Content **Intro:** Material you send to a subcontractor still belongs to you and sits in SAP as special stock at the vendor. This worksheet reconciles components issued with finished goods received so you know what should be on the vendor's floor and what is missing. **Sections:** #### How to use the worksheet **Body:** Add a row for each component on a subcontract purchase order. Enter the BOM quantity per finished unit, the quantity sent, the finished units received so far and the stock the vendor reports on hand. The sheet computes expected consumption, expected stock at the vendor, the variance and its value. A positive variance means the vendor holds more than expected, while a negative one means material is missing, scrapped or consumed without a receipt. Export to Excel for the monthly reconciliation. #### The SAP subcontracting flow **Body:** A subcontract PO uses item category L and a BOM of components. Components are transferred to the vendor with movement type 541, which moves them from your unrestricted stock to subcontractor stock without leaving your ownership. When you post the goods receipt of the finished product, SAP consumes the components with movement type 543 based on the BOM. The ME2O transaction shows component requirements and stock at each subcontractor, and MB5O lists stock provided to vendors. #### Reading variances **Body:** A small negative variance usually reflects normal scrap, which the contract should cap. Large or repeated differences point to missing material, wrong BOM quantities or receipts posted at the wrong quantity. If the BOM is wrong, consumption posts incorrectly every time and the variance grows steadily. Value the variance at unit cost and set a threshold above which the vendor must explain it. Reconcile at least monthly and before year-end. #### Common mistakes **Body:** Forgetting to post 541 for material physically shipped leaves book stock in your warehouse that is not there. Posting finished goods without checking the BOM overstates or understates consumption. Treating subcontractor stock as your own unrestricted stock in planning causes MRP to promise material that is on another site. Finally, vendors rarely count unless asked, so schedule a counted confirmation each period. **Cta:** Netray can build a read-only subcontractor stock reconciliation from your SAP data so this runs without manual entry. **Faq:** #### Which movement type sends components to a subcontractor? **Answer:** Movement type 541 transfers components to subcontractor stock. Consumption is posted automatically with 543 when the finished goods receipt is entered against the subcontract PO item. #### Where do I see stock at a subcontractor? **Answer:** Transaction ME2O shows requirements and stock provided to each subcontractor, and MB5O lists stock provided to vendors. Special stock O is the stock category for subcontractor stock. #### How do I handle scrap at the vendor? **Answer:** Agree scrap allowances in the contract, then either charge the vendor for excess scrap or post a component adjustment through a defined process. Leaving the variance unexplained creates inventory errors. #### Can I enter consumption manually? **Answer:** Yes, SAP allows components to be adjusted at goods receipt in the subcontracting component screen. Use it when actual usage differs from the BOM, and record why. ## Search terms sap subcontracting worksheet, subcontractor stock reconciliation, sap 541 movement type, sap subcontracting components excel, subcontract stock tracking, sap me2o subcontracting stock, subcontracting reconciliation template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json