# SAP PM Spare Parts Kitting and Reservation Worksheet > Source: https://netray.co/tools/sap-pm-spare-parts-kitting-reservation-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track which parts each maintenance order needs, what is on hand, what is short and what it costs to buy, before the kit is picked. ## Category sap ## Erp SAP ECC / S/4HANA ## Industry Manufacturing ## Audience - Maintenance planner - Storeroom clerk - Buyer ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Order **Key:** order **Type:** text #### Material **Key:** material **Type:** text #### Description **Key:** desc **Type:** text #### Required qty **Key:** req **Type:** number #### Unrestricted stock **Key:** stock **Type:** number #### Unit cost **Key:** cost **Type:** number **Format:** currency #### Kit status **Key:** status **Type:** select **Options:** - Not started - Partially picked - Kit complete - On order - Cancelled #### Needed by **Key:** needed **Type:** date #### Shortfall **Key:** short **Type:** number **Expr:** max(req - stock, 0) **Format:** number #### Cost to buy **Key:** buy **Type:** number **Expr:** max(req - stock, 0) * cost **Format:** currency #### Coverage **Key:** cover **Type:** number **Expr:** if(gt(req,0), min(stock / req, 1) * 100, 100) **Format:** percent **Rows:** **Order:** 4000118723 **Material:** BRG-6310-2RS **Desc:** Deep groove ball bearing 6310 **Req:** 2 **Stock:** 4 **Cost:** 38.5 **Status:** Kit complete **Needed:** 2026-11-02 **Order:** 4000118723 **Material:** SEAL-HPU-FLG **Desc:** Pump flange seal kit **Req:** 1 **Stock:** 0 **Cost:** 62 **Status:** On order **Needed:** 2026-11-02 **Order:** 4000118724 **Material:** FLT-HYD-10M **Desc:** Hydraulic filter element **Req:** 4 **Stock:** 3 **Cost:** 47.25 **Status:** Partially picked **Needed:** 2026-11-03 **Order:** 4000118725 **Material:** COUP-GR-48 **Desc:** Gear coupling hub 48 mm **Req:** 1 **Stock:** 0 **Cost:** 215 **Status:** Not started **Needed:** 2026-11-04 **Order:** 4000118726 **Material:** BELT-B85 **Desc:** V-belt B85 **Req:** 3 **Stock:** 12 **Cost:** 14.9 **Status:** Not started **Needed:** 2026-11-05 **Totals:** #### Total cost to buy **Key:** buy **Agg:** sum **Format:** currency #### Total units short **Key:** short **Agg:** sum **Format:** number **Summary:** #### Average kit coverage **Key:** avg_cov **Expr:** avg_cover **Format:** percent **Notes:** Copy lines from the order component list or from a reservation report, and update stock before each kit review. Stock should be unrestricted-use stock for the issuing storage location, minus other reservations if you want true availability. ## Content **Intro:** Most delays on maintenance jobs come from a part that nobody confirmed. This worksheet lets the planner and storeroom see, before the job, which components are covered and which need a purchase. **Sections:** #### How to use the worksheet **Body:** List every component line from the released orders you plan to execute in the next one or two weeks. Enter the required quantity from the order and the current unrestricted stock for the storage location. The sheet works out the shortfall, the cost to buy and the coverage per line. Sort by needed-by date and chase the shortfalls first. Update the kit status as parts are picked and staged, and export to Excel to share with purchasing. **Bullets:** - Check stock after other reservations, not just the physical count - Include the supplier lead time in your conversation with buyers - Stage the kit in a labelled bin per order #### How SAP reservations behave **Body:** When a component is added to a maintenance order, SAP creates a reservation, and the order release triggers an availability check depending on configuration. Goods are issued to the order, normally by movement type 261, and the cost lands on the order. A non-stock item creates a purchase requisition rather than a reservation. The reservation and the stock figure change daily, so this sheet is a working snapshot, not a record. #### Common mistakes **Body:** Planners often check availability once at order creation and never again. Others read total stock when most of it is reserved for other jobs, or ignore stock held in a different storage location. A third issue is parts issued directly without an order reference, which breaks cost history. Re-run this check after each release, and agree who owns the shortage list daily during busy periods. **Cta:** Netray can build a read-only agent that reads reservations and stock from SAP and prepares this shortage list every morning for the planner to review. **Faq:** #### What movement type issues parts to a maintenance order? **Answer:** Movement type 261 is the standard goods issue to an order, and 262 reverses it. Plants may use their own movement types for specific cases, so check your configuration. #### How is a non-stock item handled? **Answer:** A non-stock component on an order triggers a purchase requisition, not a stock reservation. The buyer sources it and goods are received directly against the order, so there is nothing in stock to count. #### Where do I get the stock figures? **Answer:** Use a stock overview such as MMBE, or an availability report by storage location. Subtract other reservations if you need what is truly free. #### What does coverage mean? **Answer:** It is the share of the required quantity that stock can cover, capped at 100 percent. A line at 50 percent has half the parts needed, and the job should not start without a plan for the rest. ## Search terms sap pm kitting worksheet, maintenance parts staging checklist, sap reservation tracking excel, parts shortage list maintenance, sap pm component availability check, work order parts kit template, maintenance planner parts sheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json