Goals

  • This course will prepare you to:
    • develop more concise and well-performing ABAP programs using new features of the ABAP programming language
    • develop and optimize ABAP applications that access data stored in the SAP HANA Database

Audience

  • Application Consultant
  • Developer
  • Developer Consultant

Prerequisites

Essential

  • Basic Knowledge of SAP HANA
  • BC400
  • BC401
  • Experience in ABAP Programming, esp. Open SQL (joins, views, aggregations)

Recommended

  • TheHA100course provides a good understanding of SAP HANA and it is highly recommended for participants who want to attend this course
  • HA150
  • BC404

Course based on software release

  • SAP HANA 2.0 SPS 00,
  • SAP BW 7.5
  • SAP BASIS 7.5

Content

  • Introduction
    • Understanding SAP HANA and how it impacts the ABAP development paradigm
    • Introduction to ABAP Development Tools (also known as ABAP in Eclipse)
  • 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
  • Database Independent Code-to-Data
    • New 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 views in ABAP using native SQL and ADBC
    • Consuming SAP HANA database procedures using native SQL and ADBC
  • SAP HANA Proxy Objects
    • Creating and using External Views
    • Database Procedure Proxies
    • HANA Transport Container
  • Advanced Topics
    • Using SAP HANA Full Text Search in ABAP
    • Enabling input fields for type-ahead search
    • SAP List Viewer (ALV) for SAP HANA