ABAP on HANA (Premium)



 Use COUPON s4hanapro

Course Content :

Introduction to SAP HANA

  • Introduction to IMCE (In-Memory Computing Engine)
  • Row v/s Column Store
  • Software and Hardware advancements
  • Evolution to SAP HANA – 1.0 to 2.0
  • Usage of SAP HANA with SAP Products o As secondary DB
  • BW on HANA
  • ABAP on HANA
  • Setup you SAP ABAP on HANA instance in CAL
  • Connection to your HANA system via HANA Studio
  • SQL Console
  • Introduction to HANA Users
  • SAP HANA Information Modeling
  • o Attribute Views
  • o Analytic Views
  • o Calculation Views
  •  Graphical Calculation Views
  •  Scripted Calculation Views
  • Decision Table
  • With value update
  • Without value update
  • Concept of currency conversion
  • Concept of Dimensions and Measures
  • SQL Scripting in SAP HANA
  • SAP HANA Anonymous blocks
  • Scripted procedures in SAP HANA
  • Procedures with parameters
  • User Defined functions in SAP HANA
  • Reuse functions for SQL queries.


  •  Introduction to ADT (ABAP Development Tools)
  • ABAP on eclipse
  • ABAP project in eclipse
  • Working with ADT shortcuts, inline view
  • Optimizing developer efficiency with ADT
  • Introduction to schema of ABAP in SAP HANA
  • Evolution of SAP Netweaver and capabilities
  • Open SQL Enhancements in SAP HANA
  • Introduction to DDL, DML, DCL, DQL
  • New syntax in ABAP
  • Inline data declaration
  • Dynamic memory references
  • SQL statements with escaping of host variables
  • Introduction to EPM Data model
  • Consuption of SAP HANA Objects in ABAP
  • View Proxies
  • Procedure proxies
  • Transporting of dependent objects
  • Lifecycle management
  • HANA transport container
  • New tooling updates in ABAP
  • SQL monitor SQLM
  • Code inspector variants
  • Data migration points
  • Static checks with SQL performance – SWLT
  • SQL Performance worklist monitor.

Advanced features of SAP ABAP on HANA

  • Introduction to code-to-data paradigm
  • Code push down to Database
  • Integration cloud system to HANA Cloud Platform using Cloud Connector
  • Performance improvement using SAP HANA
  • ABAP Database Connectivity API (ADBC)
  • Open Item analysis scenario using ADBC
  • ABAP Managed Database Procedures (AMDP)
  • Core Data Services (CDS) Views
  • CDS Introduction
  • CDS Associations
  • CDS View on View
  • S/4 HANA CDS VDM(Virtual Data Model)
  • Basic/Interface Views
  • Composite Views
  • Consumption Views
  • CDS Annotations
  • ObjectModel Annotations
  • OData Annotations
  • Analytical Annotations
  • EndUser annotations
  • UI Annotations
  • o CDS View Table Functions
  • o CDS DCL (Authorizations and secure programming)
  • o Consuming CDS in Analytical Tools
  • SAP ABAP Improved ALV IDA (Integrated Data Access)
  • Full Text Search with SAP HANA
  • Fuzzy search for search helps with SAP HANA

End to End Implementation

  1. Implementation of End to end OIA (Open Item Analysis) scenario using all techniques in ABAP on HANA
  2. Implementation of Fiori App of Master-details
  3. ALP (Analytic List Page) Implementation using CDS UI annotations
  4. Complementary OOPS ABAP Session on RTTS.