Using Machine Learning Algorithms on data residing in SAP ERP Application to predict equipment failures

  • Authors

    • Manu Kohli
    2018-05-16
    https://doi.org/10.14419/ijet.v7i2.28.12952
  • CBM, Clustering, Condition based monitoring, Corrective Maintenance, Enterprise Resource Planning, Equipment failure, ERP, HANA, Machine Learning, Plant Maintenance, Predictive Maintenance, Reliability Maintenance, SAP

  • Abstract

    Asset intensive Organizations have searched long for a framework model that would timely predict equipment failure. Timely prediction of equipment failure substantially reduces direct and indirect costs, unexpected equipment shut-downs, accidents, and unwarranted emission risk. In this paper, the author proposes a model that can predict equipment failure by using data from SAP Plant Maintenance module. To achieve that author has applied data extraction algorithm and numerous data manipulations to prepare a classification data model consisting of maintenance records parameters such as spare parts usage, time elapsed since last completed maintenance and the period to the next scheduled maintained and so on. By using unsupervised learning technique of clustering, the author observed a class to cluster evaluation of 80% accuracy. After that classifier model was trained using various machine language (ML) algorithms and subsequently tested on mutually exclusive data sets with an objective to predict equipment breakdown. The classifier model using ML algorithms such as Support Vector Machine (SVM) and Decision Tree (DT) returned an accuracy and true positive rate (TPR) of greater than 95% to predict equipment failure. The proposed model acts as an Advanced Intelligent Control system contributing to the Cyber-Physical Systems for asset intensive organizations.

     

  • References

    1. [1] Fraser K, Hvolby HH & Tseng TL, “Maintenance Management Models: A Study of the Published Literature to Identify Empirical Evidence: A Greater Practical Focus is Neededâ€, International Journal of Quality & Reliability Management, Vol.32, No.6, (2015), pp. 635-664, available online: https://doi.org/10.1108/IJQRM-11-2013-0185, last visit:26.04.2018

      [2] Kohli M, Incident Management with SAP EHS Management, Rheinwerk Publishing, (2015), pp:1-132.

      [3] Bore CK (2008), Analysis of Management Methods and Application to Maintenance of Geothermal Power Plants. United Nations University, Geothermal Training Programme, 1-52.

      [4] Hayen R, SAP R/3 Enterprise Software: An Introduction, McGraw-Hill/Irwin, (2006), pp:1-192.

      [5] Yasar A & Ozer G, “Determination the Factors that Affect the Use of Enterprise Resource Planning Information System through Technology Acceptance Modelâ€, International Journal of Business and Management, Vol.11, No.10, (2016), pp:91-108.

      [6] Columbus L, “Erp market share update: Sap solidifies market leadershipâ€, Forbes, available online: https://www.forbes.com/sites/louiscolumbus, Retrieved on December, 2013.

      [7] Wang Y (2013), Effects of implementation of sap on management accounting: Case: Dongfeng motor corporation, University of Applied Sciences, 1-88.

      [8] Garrido S, “Types of Maintenance programsâ€, available online: http://www.mantenimientopetroquimica.com/en/typesofmaintenance.html, Retrieved on January, 2017.

      [9] Stengl B & Ematinger R, SAP R/3 Plant Maintenance: Making it Work for your Business, Pearson Education, (2001), pp:1-368.

      [10] Birkner MD, Kalantri S, Solao V, Badam P, Joshi R, Goel A, Pai M & Hubard AE (2007), Creating diagnostic scores using data-adaptive regression: An application to prediction of 30-day mortality among stroke victims in a rural hospital in India. Therapeutics and clinical risk management 3, 457-484.

      [11] Qiang G, Zhe T, Yan D & Neng Z, “An Improved Office Building Cooling Load Prediction Model Based on Multivariable Linear Regressionâ€, Energy and Buildings, Vol.107, (2015), pp.445-455.

      [12] Yu F, “Accounting Transparency and the Term Structure of Credit Spreadsâ€, SSRN Electronic Journal, Vol.75, No.1, (2005), pp:53-84.

      [13] Missourisandt, “Erp share by fortune 2000 companiesâ€, available online: http://erp.mst.edu, Retrieved on January, 2017.

      [14] Sikka V, Färber F, Lehner W, Cha SK, Peh T & Bornhövd C, “Efficient Transaction Processing in SAP HANA Databaseâ€, Proceedings of the 2012 international conference on Management of Data - SIGMOD '12, ACM, New York, NY, USA, (2012), pp:731-742, https://doi.org/10.1145/2213836.2213946.

      [15] Prasad Nepal M & Park M, “Downtime Model Development for Construction Equipment Managementâ€, Engineering, Construction and Architectural Management, Vol.11, No.3, (2004), pp. 199-210, available online: https://doi.org/10.1108/09699980410535804

      [16] Colen IF & Brito J, “Building facades maintenance support systemâ€, Proceedings of The XXX IAHS World Congress on Housing, Vol.9, No.13, (2002).

      [17] Fu C, Ye L, Liu Y, Yu R, Iung B, Cheng Y & Zeng Y, “Predictive Maintenance in Intelligent-Control-Maintenance-Management System for Hydroelectric Generating Unitâ€, IEEE Transactions on Energy Conversion, Vol.19, No.1, (2004), pp.179-186.

      [18] Tsang AH, “Conditionâ€Based Maintenance: Tools and Decision Makingâ€, Journal of Quality in Maintenance Engineering, Vol.1, No.3, (1995), pp:3-17, available online: https://doi.org/10.1108/13552519510096350

      [19] Lee J, Bagheri B & Kao HA, “A Cyber-Physical Systems Architecture for Industry 4.0-Based Manufacturing Systemsâ€, Manufacturing Letters, Vol.3, (2015), pp.18-23, available online: https://doi.org/10.1016/j.mfglet.2014.12.001

      [20] Young T, Fehskens M, Pujara P, Burger M & Edwards G, “Utilizing Data Mining to Influence Maintenance Actionsâ€, 2010 IEEE AUTOTESTCON, Vol.1, No.5, (2010).

      [21] Liao W, Wang Y & Pan E, “Single-Machine-Based Predictive Maintenance Model Considering Intelligent Machinery Prognosticsâ€, The International Journal of Advanced Manufacturing Technology, Vol.63, No.1, (2012), pp.51-63.

      [22] Pan E, Liao W & Xi L, “A Joint Model of Production Scheduling and Predictive Maintenance for Minimizing Job Tardinessâ€, The International Journal of Advanced Manufacturing Technology, Vol.60, No.9, (2011), pp.1049-1061.

      [23] Wagstaff K, Cardie C, Rogers S & SchrÖdl S, “Constrained K-means Clustering with Background Knowledgeâ€, Proceedings of the Eighteenth International Conference on Machine Learning (ICML 2001), Williams College, Williamstown, MA, USA, (2001), pp. 577-584.

      [24] Murè S, Comberti L & Demichela M, "How Harsh Work Environments Affect the Occupational Accident Phenomenology? Risk Assessment and Decision Making Optimisationâ€, Safety Science, Vol. 95, (2017), pp. 159-170, available online: https://doi.org/10.1016/j.ssci.2017.01.004

      [25] Kuo R, Ho L & Hu C, “Integration of Self-Organizing Feature Map and K-means Algorithm for Market Segmentationâ€, Computers & Operations Research, Vol.29, No.11, (2002), pp. 1475-1493, available online: https://doi.org/10.1016/S0305-0548(01)00043-0

      [26] Lake P & Crowther P (2013), In-memory databases. Concise Guide to Databases, Undergraduate Topics in Computer Science, Springer, 183-197.

      [27] Colombo AW, Karnouskos S & Bangemann T, “Towards the Next Generation of Industrial Cyber-physical Systemsâ€, In Industrial cloud-based cyber-physical systems, Springer International Publishing, (2014), pp.1-22.

      [28] Fan Q & Fan H, “Reliability Analysis and Failure Prediction of Construction Equipment with Time Series Modelsâ€, Journal of Advanced Management Science, Vol.3, No.3, (2015), pp. 203-210, last visit:26.04.2018

      [29] Geitner FK & Bloch HP, “Machinery Component Failure Analysisâ€, Machinery Failure Analysis and Troubleshooting, Oxford (2012), pp.87-293.

      [30] Vladareanu V, Dumitrache I, Vladareanu L, Sacala IS, Tont G & Moisescu MA, “Versatile Intelligent Portable Robot Control Platform Based on Cyber Physical Systems Principlesâ€, Studies in Informatics and Control, Vol.24, No.4, (2015), pp.409-418, last visit:26.04.2018

      [31] Vladareanu L, Tont G, Ion I, Munteanu MS & Mitroi D, "Walking Robots Dynamic Control Systems on an Uneven Terrainâ€, Advances in Electrical and Computer Engineering, Vol.10, No.2, (2010), pp:145-152.

      [32] Swedepump, Lifespan of Centrifugal Pump, FLYGT, (2017), Retrieved from http://www.swedepump.by/files/1587870.pdf

      [33] Salzberg SL, “On Comparing Classifiers: Pitfalls to Avoid and a Recommended Approachâ€, Data mining and knowledge discovery, Vol.1, No.3, (1997), pp. 317-328, available online: https://doi.org/10.1023/A:1009752403260, last visit:26.04.2018

  • Downloads

  • How to Cite

    Kohli, M. (2018). Using Machine Learning Algorithms on data residing in SAP ERP Application to predict equipment failures. International Journal of Engineering & Technology, 7(2.28), 312-319. https://doi.org/10.14419/ijet.v7i2.28.12952

    Received date: 2018-05-17

    Accepted date: 2018-05-17

    Published date: 2018-05-16