3 Days
HANA 2.0 SPS04


In this course, learn how you can use SAP HANA and new features in the ABAP programming language to optimise existing ABAP code and to develop innovative ABAP applications to enhance your business.

This course is for developers and consultants who are familiar with programming database access using ABAP and ABAP Objects programming and want to learn how to use SAP HANA to speed up such access.

The course covers many new ABAP features for database access that are not limited to SAP HANA as underlying database.

This course is based on software release:

  • SAP HANA 2.0 SPS04

Key Topics

Detailed Info
  • Introduction
  • Database Independent Code-to-Data
  • Consuming SAP HANA Objects in ABAP
  • Taking ABAP to SAP HANA
  • SAP HANA specific Code-to-Data
  • Advanced Topics
Skills Gained
Key Topics
Target Audience

Skills Gained

This course will prepare you to:

  • Develop more concise and well-performing ABAP programs using new features of the ABAP programming language
  • Develop and optimise ABAP applications that access data stored in the SAP HANA Database

Key Topics


  • Understanding SAP HANA and how it impacts the ABAP development paradigm
  • Introduction to ABAP Development Tools (also known as ABAP in Eclipse)


  • 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 prioritise performance issues: SQL Monitor, SQL Performance Tuning Worklist
  • Performance Rules and Guidelines for ABAP in the context of SAP HANA

Database Independent Code-to-Data

  • Enhanced Open SQL
  • Defining advanced views using Core Data Services (CDS) and CDS Associations in ABAP
  • Incorporating Authorization Checks with CDS in ABAP

SAP HANA specific Code-to-Data

  • Using native SQL and ABAP Data Base Connectivity (ADBC)
  • Creating, using and debugging ABAP Managed Database Procedures

Consuming SAP HANA Objects in ABAP

  • Consuming SAP HANA objects in ABAP using native SQL and ADBC
  • Creating and using External Views
  • Database Procedure Proxies

Advanced Topics

  • ABAP Transport of SAP HANA Objects (HTC and HTA)
  • Using SAP HANA Full Text Search in ABAP
  • Enabling input fields for type-ahead search
  • SAP List Viewer (ALV) optimised for SAP HANA

Target Audience

  • Application Consultant
  • Developer
  • Developer Consultant




Print course details

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Email Course Outline
Request a Callback

Enter your details below and we'll email you a pdf of the course outline.

Enter your details below and one of our team will give you a call to answer any questions you may have.

Pre-Course Requirements

This course has requirements which must be completed before commencing.
Please click here to view.