ABAP ON HANA With Fiori&OOdata Online Training

ABAP ON HANA With Fiori&OOdata Course Details

Introducing the development environment

  • Introduction to SAP HANA and SAP HANA Studio
  • Understand the impact of SAP HANA on ABAP application development
  • Introduction to ABAP Development Tools (ABAP in Eclipse)
  • Advanced Techniques for ABAP Programming for SAPHANA
  • ABAP and ABAP Project in eclipse

ABAP Development Tools (ADT)

  • Installation of ABAP Development tools
  • ADT in Development System
  • ADT tool debugging


  • Basic Concepts of SQL
  • Fetching Data from Tables / Views
  • Retrieving Data from Multiple Tables
  • Modification of Data from Tables
  • Data Storage techniques
  • Accessing Data using Views


  • SAP HANA as Secondary Database– Access via Open SQL
  • Preparing ABAP Code for SAP HANA
  • Guided Performance Analysis
  • Performance Rules and Guidelines for SAP HANA


  • Introduction to SAP FIORI
  • SAP Fiori Design Principles
  • SAP Fiori Architecture
  • SAP Fiori Launchpad and SAP Fiori Designer
  • Creating Tiles, Catalog, Group, Roles for adding Application to Fiori.

SAP Netweaver Gateway Using OData Service

  • Creating OData Service in SAP Netweaver Gateway (Code Based)
  • Reading and filtering data (Code Based)
  • Development life cycle of SAP Netweaver Gateway
  • Hub deployment and Embedded Deployment
  • Creating, Updating, deleting Entry of OData Service. (Code Based)
  • Function Import (Code Based)
  • File Upload and download (Code Based)
  • Map to Data Source
  • Service Generation using RFC
  • Testing Gateway services

Data Dictionary

  • ABAP Dictionary Introduction
  • Data Elements
  • Domains
  • Data Base Tables
  • Structures
  • Table Maintenance Generator
  • Views
  • Search Help
  • Lock Objects

Data Types in ABAP
Programming Structure in ABAP

  • Selection Screen – Parameter,Slect-option, Ranges
  • Internal Table and WorkArea
  • Line Type and Row Type
  • Exceptionsc
  • Internal table Operators
  • Variants
  • SQL Statement
  • Package and Transport Request

Database Independent Code-to-Data

  • Classical Open SQL and Its Limitations
  • New Open SQL
  • Improve Open SQL Statements Using the SQL Trace (ST05)

SAP HANA Proxy Objects

  • Calling SAP HANA Procedures via ABAP Database Procedure Proxies
  • Transport of SAP HANA Objects via HTC & HTA
  • Create a SAP HANA Transport Container (HTC) for a Delivery Unit

SAP HANA- OO ABAP concepts

  • Visibility (public/protected/private)
  • Static instance/variables, constants
  • Static /instance methods, method parameters
  • Inheritance, Interface, interface methods

SAP Net weaver Application server ABAP Architecture

  • Code push down
  • Transport of native Development Objects
  • Application Cases and Deployment Options

ABAP Core Data services and annotations

  • Enhanced ABAP Development with Core Data Services (CDS)
  • CDS Views created inner join to display the data
  • Associations in Core Data Services
  • Core Data Services with Input Parameters
  • Incorporating Authorization Checks with CDS
  • ALV Optimized for SAP HANA to Display an CDS View
  • Optimizing a Report with CDS View and ALV IDA

SAP HANA specific Code-to-Data

  • ABAP Database Connectivity (ADBC)
  • Native SQL Syntax
  • ABAP Report with new data declaration syntaxes on 7.40
  • ABAP Report on HANA using ADBC

Consuming HANA Views in ABAP

  • Working with Views in SAP HANA Studio
  • Consuming Attribute View using External View.
  • Consuming Attribute View using Native SQL
  • Consuming Analytic View/Calculation View in ABAP


  • Generating OData Service using ABAP CDS Views
  • Developing SAPUI5 application using ABAP CDS Views

Consuming HANA Procedures in ABAP

  • ABAP connectivity and integration
  • Working with Database Procedures in SAP HANA Studio
  • Integrating Native Procedures with ABAP
  • Runtime and error Analysis with SAP HANA
  • Consuming HANA artifact Stored Procedure using ABAP Proxy Procedure.

Consume HANA artifact Stored Procedure by Calling it in ABAP Code.

ABAP Managed Database Procedures in ABAP HANA

  • Top-down and Bottom-up Approach
  • ABAP-Managed Database Procedures
  • AMDP Methods in CDS Views
  • Creating, using and debugging ABAP Managed Database Procedures
  • Debugging ABAP-Managed Database Procedures with select-options & parameters display ALV report
  • AMDP with select options

Runtime and Error Analysis with SAP HANA

  • Overview of the Tools Available
  • Troubleshooting
  • Dump Analysis
  • Debugging and Tracing in SQL Script
  • ABAP Code Analysis
  • Checks and Check Variants
  • Checks in the Development Infrastructure
  • Global Check Runs in the System

Advanced Topics

  • Using SAP HANA Full Text Search
  • ABAP List Viewer with Integrated Database Access (ALV IDA)
  • Technical Architecture
  • Error-Tolerant Search
  • SAP Components and Products for Search
  • Sample Technical Specification of ABAP on HANA Project
  • ABAP Test Cockpit Setup & Exemption Process



SAP Certified Development Associate – SAP Fiori Application Developer

WhatsApp chat