Prerequisites
To apply for the SAP ABAP ON HANA Training, you need to either:
- Should have basic computer knowledge
- Proficiency in using operating systems like Windows.
- An aspirant should have basic skills in database concepts and SQL.
- Basic programming skills (depending upon the course).
- Aspirants should have good knowledge of SAP software and its various modules.
Module 1: Introduction
- SAP HANA Basics and Technical Concepts
- Introducing the SAP HANA Studio
- ABAP and SAP HANA
- Introducing the ABAP Development Tools (ADT)
Module 2: SQL and SQL Script Basics for SAP HANA
- Reading data from a table or view
- Calculated Columns and Functions
- Duplicate Elimination
- Sorting and limiting result sets
- The WHERE clause
- Aggregating and grouping data
- SQL Script basics
Module 3: Taking ABAP to SAP HANA
- Accessing SAP HANA as a Secondary Database
- Tools to detect potential functional and performance issues when migrating to SAP HANA:
- Code Inspector and ABAP Test Cockpit
- ABAP Trace and ABAP Profiler
- SQL Trace
- Tools to prioritize performance issues:
- SQL Monitor
- SQL Performance Tuning Worklist
- Performance Rules and Guidelines for ABAP in the context of SAP HANA
Module 4: SAP HANA specific Code-to-Data
- ABAP Database Connectivity (ADBC)
- Native SQL Syntax
- ABAP-Managed Database Procedures
- Creating and using ABAP-Managed Database Procedures
- Debugging ABAP-Managed Database Procedures
- Core Data Services with Table Function
Module 5: Database Independent Code-to-Data
- Classical Open SQL and Its Limitations
- New Open SQL
- Core Data Services in ABAP
- Associations in Core Data Services
- Core Data Services with Input Parameters
- Incorporating Authorization Checks with CDS
Module 6: Consuming SAP HANA Objects in ABAP
- Consuming SAP HANA views in ABAP using native SQL and ADBC
- Consuming SAP HANA database procedures using native SQL and ADBC
Module 7: Advanced Topics
- Using SAP HANA Full-Text Search in ABAP
- Enabling input fields for type-ahead search
- SAP List Viewer (ALV) for SAP HANA
Module 8: Case Study on Optimizing a Report on Flight Customer Revenue
- Optimizing a Report with CDS View and ALV IDA
Module 9: SAP HANA Proxy Objects
- Creating and using External Views
- Database Procedure Proxies
- HANA Transport Container
Module 10: Conclusion
- Summarize all the points discussed.
