# SAP PM Measuring Point and Counter Readings Worksheet > Source: https://netray.co/tools/sap-pm-measuring-point-counter-readings-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log counter readings for running hours or cycles, compute daily usage and the days left until a performance-based service is due. ## Category sap ## Erp SAP ECC / S/4HANA ## Industry Manufacturing ## Audience - Maintenance planner - SAP PM consultant - Reliability engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Equipment **Key:** equipment **Type:** text #### Measuring point **Key:** point **Type:** text #### Point type **Key:** kind **Type:** select **Options:** - Counter - Measuring point #### Unit **Key:** unit **Type:** select **Options:** - H - CYC - KM - BAR - DEGC #### Previous reading **Key:** prev **Type:** number #### Current reading **Key:** curr **Type:** number #### Days between readings **Key:** days **Type:** number #### Service interval **Key:** interval **Type:** number #### Counter at last service **Key:** since **Type:** number #### Usage since previous **Key:** delta **Type:** number **Expr:** curr - prev **Format:** number #### Usage per day **Key:** rate **Type:** number **Expr:** if(gt(days,0), (curr - prev) / days, 0) **Format:** decimal #### Remaining to service **Key:** left **Type:** number **Expr:** since + interval - curr **Format:** number #### Days to service **Key:** daysleft **Type:** number **Expr:** if(gt((curr - prev) / max(days,1), 0), (since + interval - curr) / ((curr - prev) / max(days,1)), 0) **Format:** days **Rows:** **Equipment:** Air compressor C-101 **Point:** C101-RH **Kind:** Counter **Unit:** H **Prev:** 18420 **Curr:** 18588 **Days:** 7 **Interval:** 4000 **Since:** 16000 **Equipment:** Injection press IM-07 **Point:** IM07-CYC **Kind:** Counter **Unit:** CYC **Prev:** 2410000 **Curr:** 2459000 **Days:** 7 **Interval:** 500000 **Since:** 2000000 **Equipment:** Forklift FL-03 **Point:** FL03-HRS **Kind:** Counter **Unit:** H **Prev:** 6120 **Curr:** 6168 **Days:** 7 **Interval:** 250 **Since:** 6000 **Equipment:** CNC mill VF-4 **Point:** VF4-SPINDLE **Kind:** Counter **Unit:** H **Prev:** 9210 **Curr:** 9262 **Days:** 7 **Interval:** 2000 **Since:** 8000 **Equipment:** Hydraulic unit HPU-02 **Point:** HPU02-PRESS **Kind:** Measuring point **Unit:** BAR **Prev:** 180 **Curr:** 176 **Days:** 7 **Interval:** 0 **Since:** 0 **Totals:** #### Total usage this period **Key:** delta **Agg:** sum **Format:** number **Summary:** #### Average usage per day per point **Key:** avg_rate **Expr:** sum_delta / max(count,1) / 7 **Format:** decimal **Notes:** Counters accumulate and drive performance-based maintenance plans. Measuring points that are not counters (pressure, temperature) record a value, so set the service interval to 0 and ignore the remaining columns. Replace the sample rows with your own. ## Content **Intro:** Performance-based maintenance only works if somebody reads the meters and the numbers reach SAP. This worksheet gives you a clean sheet to plan the measuring points, log readings and see which counter will hit its service threshold first. **Sections:** #### How to use the worksheet **Body:** List each counter or measuring point you maintain, with the unit and the service interval from the maintenance strategy. Each week enter the previous and current reading and the days between them. The sheet computes usage per day and projects how many days remain until the next service, assuming the current rate holds. Sort by days to service to build the next call-up list. Export to Excel to compare against what SAP shows in its measurement document history. **Bullets:** - One row per measuring point, not per machine - Counter points are created in IK01, readings entered in IK11 - Use the same unit that is stored on the measuring point #### How SAP treats counters **Body:** A counter measuring point holds a cumulative total and SAP derives the difference between readings. The counter has an overflow value, so a rollover needs a counter replacement entry, not a negative difference. A performance-based maintenance plan uses the annual estimate or the actual readings to forecast the next call-up date. Poor reading discipline causes the forecast to drift, which is why plans call early or late. The projected date on this sheet is a sanity check, not a replacement for the plan. #### Common mistakes **Body:** Plants often create the measuring point but never schedule who reads it. Others enter the reading with the wrong date, which wrecks the usage rate. A counter replaced during a rebuild needs a new counter or a documented reset. Finally, copying one annual estimate to every similar machine hides the fact that spare machines run far fewer hours. **Bullets:** - Verify the reading date, not the entry date - Document counter replacements and rollovers - Review annual estimates once a year against actual usage **Cta:** If readings come from PLCs, historians or MES, Netray can help feed them to SAP measurement documents with an approval step. We only recommend it when manual rounds are a real bottleneck. **Faq:** #### What is the difference between a counter and a measuring point? **Answer:** A counter accumulates, such as running hours or cycles, and SAP uses the difference between readings. A plain measuring point records a value at a moment, such as pressure or temperature, and is compared with limits for alerts. #### Which transactions do I use? **Answer:** IK01 creates a measuring point, IK02 changes it, and IK11 enters a measurement document. Counters can also be read through mobile apps or uploaded in bulk through standard measurement document interfaces. #### How accurate is the days-to-service figure? **Answer:** It is a straight-line projection from the last interval. If usage is seasonal or the machine was idle, the figure is off. Treat it as a planning aid and let the SAP plan do the formal scheduling. #### Can I paste this into a SAP upload? **Answer:** You can reuse the equipment, point and reading columns as a source for your own upload template. Check your system's measurement document upload format and test in a non-production client first. ## Search terms sap pm measuring point worksheet, sap ik11 measurement document template, counter reading log excel, performance based maintenance plan sap, running hours log template, sap ik01 measuring point list, meter reading sheet maintenance --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json