# SAP PM Maintenance BOM and Spare Parts Cost Worksheet > Source: https://netray.co/tools/sap-pm-maintenance-bom-spare-parts-cost-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Plan the maintenance BOM for an asset: parts, item category, criticality and cost, ready to load into CS01 or use as a stocking review. ## Category sap ## Erp SAP ECC / S/4HANA ## Industry Manufacturing ## Audience - Maintenance planner - Spares planner - SAP PM consultant ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Item **Key:** item **Type:** text #### Material number **Key:** material **Type:** text #### Description **Key:** desc **Type:** text #### Item category **Key:** cat **Type:** select **Options:** - L Stock item - N Non-stock item - T Text item #### Criticality **Key:** crit **Type:** select **Options:** - A Critical - B Important - C Routine #### Qty installed **Key:** qty **Type:** number #### UoM **Key:** uom **Type:** select **Options:** - EA - SET - M - L - KG #### Unit cost **Key:** cost **Type:** number **Format:** currency #### Min stock **Key:** min **Type:** number #### Lead time (days) **Key:** lead **Type:** number #### Installed value **Key:** ext **Type:** number **Expr:** qty * cost **Format:** currency #### Min stock value **Key:** stockval **Type:** number **Expr:** min * cost **Format:** currency **Rows:** **Item:** 0010 **Material:** BRG-6310-2RS **Desc:** Deep groove ball bearing 6310 **Cat:** L Stock item **Crit:** A Critical **Qty:** 2 **Uom:** EA **Cost:** 38.5 **Min:** 2 **Lead:** 14 **Item:** 0020 **Material:** SEAL-HPU-FLG **Desc:** Pump flange seal kit **Cat:** L Stock item **Crit:** A Critical **Qty:** 1 **Uom:** SET **Cost:** 62 **Min:** 1 **Lead:** 21 **Item:** 0030 **Material:** FLT-HYD-10M **Desc:** Hydraulic return filter element 10 micron **Cat:** L Stock item **Crit:** B Important **Qty:** 2 **Uom:** EA **Cost:** 47.25 **Min:** 4 **Lead:** 7 **Item:** 0040 **Material:** BELT-B85 **Desc:** V-belt B85 **Cat:** L Stock item **Crit:** C Routine **Qty:** 3 **Uom:** EA **Cost:** 14.9 **Min:** 3 **Lead:** 5 **Item:** 0050 **Desc:** Local vendor gasket cut to size **Cat:** N Non-stock item **Crit:** C Routine **Qty:** 1 **Uom:** EA **Cost:** 9 **Min:** 0 **Lead:** 3 **Totals:** #### Total installed value **Key:** ext **Agg:** sum **Format:** currency #### Total minimum stock value **Key:** stockval **Agg:** sum **Format:** currency **Summary:** #### Average lead time (days) **Key:** avg_lead **Expr:** avg_lead **Format:** decimal **Notes:** Item category L means a stock item with a material master, N is a non-stock item entered as free text. Maintenance BOMs usually use BOM usage 4, plant maintenance. Verify item categories and BOM usage in your own configuration before loading. ## Content **Intro:** A maintenance BOM links an asset to the parts that keep it running, so the planner picks components instead of typing part numbers on every order. This worksheet helps you build one and see what it costs to hold the spares. **Sections:** #### How to use the worksheet **Body:** Start with the machine's OEM parts list and strip it down to what you actually replace. Give each part an item number, the material number if it exists, and decide whether it is a stock item or a non-stock item bought on demand. Record criticality, installed quantity, unit cost, a minimum stock and the supplier lead time. The sheet totals installed value and the money tied up in minimum stock, which is the figure finance will ask about. **Bullets:** - Include only parts that are replaced, not every screw on the drawing - Mark a part A when its failure stops the line and the lead time is long - Keep descriptions identical to the material master #### How it maps to SAP **Body:** In SAP the BOM is created with CS01 and assigned to a piece of equipment or a functional location. Components are then picked from the BOM into the component list of a maintenance order, and the reservation drives the goods issue, normally movement type 261 to the order. Spare parts normally use material type ERSA. The A, B and C ranking is not a SAP field but is often stored as ABC indicator or a classification characteristic so reports can filter by it. #### Common mistakes **Body:** Copying the whole OEM list creates a BOM nobody trusts. Others set minimum stock for everything, tying up cash in parts that never fail. A third error is creating non-stock items for parts that are used repeatedly, which means no history and no purchasing agreement. Review the A-class parts first with a short criticality discussion, and compare the minimum stock value with your actual consumption history before approving. **Cta:** If you want to check which BOM components were really consumed, Netray can read order history and component usage from SAP read-only and suggest which parts to add or remove. **Faq:** #### What BOM usage do maintenance BOMs use? **Answer:** Most plants use BOM usage 4, plant maintenance, for equipment and functional location BOMs, though some use production BOM usage 1. It is a configuration choice, so confirm with your SAP team. #### Stock item or non-stock item? **Answer:** Use a stock item when the part has a material master and you want inventory control and history. Use a non-stock item for one-off parts bought only when the job needs them. Repeated use is the signal to create a material. #### How do I decide minimum stock? **Answer:** Base it on usage over the lead time plus a safety margin, and on the cost of downtime if it is missing. Critical, long-lead parts may justify holding one spare even if they rarely fail. #### Can I upload this sheet to SAP? **Answer:** Use it as source data for your own BOM upload, such as a LSMW or migration cockpit template. Column names here are generic, so map them to your upload format and test in a sandbox first. ## Search terms sap pm maintenance bom template, equipment bom spare parts list excel, sap cs01 bom usage 4 plant maintenance, spare parts list template, critical spares list excel, sap pm bom upload sheet, maintenance bom worksheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json