$30 off During Our Annual Pro Sale. View Details »

ML/PA/AI with ABAP

PhilMAD3
April 26, 2019

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.

PhilMAD3

April 26, 2019
Tweet

More Decks by PhilMAD3

Other Decks in Technology

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