Course Description
This course is based on software release HANA 1.0 SPS08, application server ABAP 7.40 SPS9.
What You'll Learn
- Develop and optimize ABAP applications that access data stored in the SAP HANA database
- Who Needs to Attend
- Developers and development consultants
- Roles involved with implementing or reviewing program code to optimize ABAP based applications for SAP HANA
Prerequisites
- HA100 - SAP HANA - Introduction
- BC400 - ABAP Workbench Foundations
- BC401 - ABAP Objects
- Experience in ABAP programing (procedural and object-oriented)
- Open SQL Details (joins, view, aggregations)
- HA150 - SQL Basics for HANA is highly recommended
- BC404 - ABAP Programming in Eclipse is highly recommended
- SAP HANA - Introduction (HA100v09)
- ABAP Workbench Foundations (BC400v15)
- ABAP Objects (BC401v15)
- SQL Basics for HANA (HA150v7)
Follow-On Courses
There are no follow-ons for this course.
Course Outline
1. Technical concepts of SAP HANA
2. Introduction to HANA Studio
3. Introduction to ADT
4. 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
5. Tools to Prioritize Performance Issues: SQL Monitor, SQL Performance Tuning Worklist
6. Performance Rules and Guidelines for ABAP in the Context of SAP HANA
7. Optimizing ABAP by Accessing SAP HANA as a Secondary Database:
Using Native SQL and ADBC (ABAP Data Base Connectivity)
Consuming SAP HANA Views and Database Procedures in ABAP Using Native SQL and ADBC
8. Optimizing ABAP Using SAP HANA as Primary Database:
Using New Open SQL
Defining Advanced Views Using Core Data Services (CDS) and CDS Associations in ABAP
Creating, Using and Debugging ABAP Managed Database Procedures
Creating and Using External Views
HANA Transport Container
9. Using SAP HANA Fuzzy Search in ABAP
10. Enabling Input Fields for Type-Ahead Search
11. SAP List Viewer (ALV) for SAP HANA