An introduction to ABAP CDS Views and an application to duplicate search on S/4 HANA

We present the technique of ABAP CDS Views on SAP HANA. This modelling technique allows us to construct complex multi-layered views with features like associations, access controls, calculated fields and much more.
As an application we show how a duplicate search or fuzzy search for Business Partners can be implemented on S/4 HANA.

Transcript

1. An introduction to ABAP CDS Views and an application to duplicate search on Business Partner in S/4 HANA Dr. Benedict Baur, self-employed October 2019 Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 1 / 9 #HANAdevs
2. About me SAP-Enthusiast and Mathematician (i) Business Intelligence: SAP Business Warehouse, SAP HANA native (ii) Master Data Management: Material Master, Business Partner, Customer-/Vendor-Integration (iii) (Advanced) Analytics: Machine Learning, Data Science (iv) Self-employed from November 2019 Contact Mail: benedict.baur@mail.de Xing (Dr. Benedict Baur) Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 2 / 9 #HANAdevs
3. The S/4 HANA Challenges Data challenge Data is distributed along several data tables and customizing tables. Major part of runtime/development effort: Selecting data, connecting and enriching (e.g. calculations). Challenge: Speed up logic by execution in HANA rather than ABAP. Build reusable components / data model UI/API challenge Build responsive, dynamic Fiori-/HTML5-apps rather than Web Dynpro/SAP GUI. Expose data and services to external cloud-based applications. DevOp challenge Authorization: Adapt existing role concept Transport management, Version control Integrated automatic testing environment for data and application logic Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 3 / 9 #HANAdevs
4. ABAP CDS - the sun of the S/4 universum Annotations UI, oData, Access Control Projection Calculated fields, CASE, Aggregation From CDS, AMDP, Associ- ation, JOIN, UNION Dev Eclipse, ABAP Transport, Authorization, Unit Testing Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 4 / 9 #HANAdevs
5. Example Data model: Business partner with address and roles Enrichment layer BP MAIN with label Calculated fields Label for BP Composition layer BP Main Basic inter- face views BP Roles BP General BP Address numbers Central Ad- dress info Persistent layer BUT100 BUT000 BUT020 ADRC Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 5 / 9 #HANAdevs
6. Duplicate search on business partners Challenge and Use Case (i) Duplicate means: A real business partner is given by several distinct master data records in the ERP. (ii) This has severe impact on business processes and data analysis (iii) Build a firewall of data quality: Upon creation of a new business partner check whether it already exists in the system ⇒ avoid creation of duplicates Strategy Implement a fuzzy search on existing business partner data using CDS. Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 6 / 9 #HANAdevs
7. Implementation of the duplicate search Consumption/API layer BAdI for Tcode BP oData ABAP / Fiori Result view BPSearchResult CDS with parameters Conduct Fuzzy search SearchBPFuzzy AMDP / SQLScript Search model BP with Address CDS Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 7 / 9 #HANAdevs
8. Conclusion Construct duplicate search with less ABAP coding effort. Model business entities as CDS views comprising data from several tables. Reusable data model. Not all database operations are supported (Fuzzy, String operations) Lot of features to be explored (200 annotations) Have to switch between different languages: ABAP, CDS, Open SQL, SQLScript ABAP is not dead, yet live :-). Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 8 / 9 #HANAdevs
9. Bibliography Core Data Services f¨ ur ABAP (Renzo Colle, Ralf Dentzner, Jan Hrastnik, SAP Press Rheinwerk Verlag, Bonn, 2017) Tutorial for Business partner and partner relations: http://www.cadaxo.com/high- class-development/abap-cds-views-6-schritte-zum-verstaendnis/ SAP HANA Academy: https://blogs.sap.com/2016/03/30/sap-hana-academy-learn- how-to-use-core-data-services-in-sap-s4-hana/. Introduction to ABAP CDS views: https://blogs.sap.com/2017/09/09/abap-core- data-services-introduction-abap-cds-view/ Comparison CDS for ABAP/HANA native: https://blogs.sap.com/2015/07/20/cds-one-model-two-flavors/. Multi series tutorial: https://sapyard.com/category/tutorial/abap-cds/. Dr. Benedict Baur, self-employed ABAP CDS and duplicate search October 2019 9 / 9 #HANAdevs