ML/PA/AI with ABAP

Showing how to use SAP HANA PAL by using ABAP managed objects. Presented at the SAP Inside Track Madrid, 26th of April 2019.

Transcript

1. USING ML/PA/AI IN ABAP SAP Inside Track Madrid, 26.4.2019 Philipp Nell
2. PART OF SOMETHING BIGGER SULZER IN THE WORLD Montvale (USA) Hyderabad (Indien) Budapest/Szeged (Ungarn) Magdeburg Stuttgart Ingolstadt München Stuttgart, München, Ingolstadt, Magdeburg Madrid (Spanien)  Locations in different continents  Global services
3. Sulzer España, April 2019 4 USING MACHINE LEARNING COMPONENTS FOR THE “INTELLIGENT ENTERPRISE” Clustering Classification Regression Association Time Series Miscellaneous Statistics Machine learning methods, also applicable for data from ERP systems and data lakes. Special challenge: Analysis across system boundaries (virtual or with replication) • Natural Language Processing based on neural networks incl. • Incident classification with semantic normalization • Real-time analysis of the evolution of problem classes Integration of Deep Learning (i.e. Tensorflow) in different environments, see #sitBCN 2018
4. Sulzer España, April 2019 5 WHY THIS SPEECH?  Applying AI/ML/PA techniques with non-integrated functionality requires  Extraction and import of externally determined results to the ML environments  Productive use requires continuous verification of results determined with the point above and production-ready model adjustments  Heterogeneous technologies/programming environments based on different knowledges
5. Sulzer España, April 2019 6 MISSION OBJETIVE DO ML/AI/PA within ABAP using standard means
6. Sulzer España, April 2019 7  that there is a Python driver available for SAP HANA? BY THE WAY: DID YOU KNOW…
7. Sulzer España, April 2019 8  SAP HANA (Examples of the shown scenario require HANA 2.0.2 or higher)  SAP ABAP 7.5.x (i.e. ECC 6.0 EHP, S/4HANA, BW on HANA, BW/4HANA)  Abap Development Tools in Eclipse  Understanding of the basics of ML/AI/PA  Documentation of  ABAP,  ABAP CDS,  SQL Script and  PAL   REQUIRED COMPONENTS FOR OUR SCENARIO
8. Sulzer España, April 2019 9 TODAY’S RECIPE On-the-fly PAL-based ABC classification, consumable by the end user  For today’s cooking, we will need  3 ABAP CDS Views  1 AMDF  1 SAP HANA PAL procedure  1 BW on HANA (i.e. ABAP NW 7.50)  1 HANA DB 2.0.2 or higher  Data: SBOOK, SCUSTOM,…  1 ADT in Eclipse  1 Analytical Frontend
9. Sulzer España, April 2019 10 THE HANA PAL METHOD “ABC CLASSIFICATION” (Sales) Data Parameters PERCENT_A = e.g. 70% PERCENT_B = e.g. 20% PERCENT_C = e.g. 10% • All customer which are responsable for 70% of the revenue are class A, • the next group of customers responsible for the next 20% are class B, • the rest is class C ABC classification Result Customer ID Class A|B|C
10. Sulzer España, April 2019 11 OVERVIEW OF THE PROCESS Get the data Prepare the data (here currency conversion to group currency) Feed the PAL procedure Combine the result with other data Analyze the result
11. Sulzer España, April 2019 12 PREPARING THE DATA VIA CDS VIEW 1 CONVERTING AMOUNTS TO A SINGLE TARGET CURRENCY
12. Sulzer España, April 2019 13 DATA AND PARAMETERS
13. Sulzer España, April 2019 14 ABAP CDS WITH HANA TABLE FUNCTION
14. Sulzer España, April 2019 15 ABAP CDS VIEW FOR ANALYSIS
15. Sulzer España, April 2019 16 ANALYZING THE RESULT IN ANALYSIS FOR OFFICE
16. Sulzer España, April 2019 17 ¿QUESTIONS?
17. Sulzer España, April 2019 18 THANK YOU!
18. Sulzer España, April 2019 19 APPLYING OUR MODEL