ABAP ON HANA COURSE CONTENT-
 
SAP HANA Introduction
Features and Architecture of HANA Database
 
ABAP HANA Introduction
Role of ABAP consultants in SAP HANA Data to Code Vs Code to Data Approach Introduction to HANA Studio
 
Native HANA Development
Introduction to SQL and Database Objects Schema
Row Store Table Vs Column Store Table Database Tables – CRUD Operations Transaction Control Statements
Order By, Group By, Having, Where Clauses Primary key and Foreign Key Constraints Global Vs Local Temporary Tables
Defining and Managing Triggers Sequences
Synonyms
Altering Database Objects Table Types
Procedures Functions
Temporary Internal Tables Conditional and Looping statements Cursors
Exception Handling Views
Arrays Joins Indexes
SQL Functions
 
STORED PROCEDURES
 
Creating Stored Procedures Creating Database Procedure Proxies
Consuming Stored Procedure from ABAP Reports Scalar Functions
Table Functions
ADBC (ABAP DATABASE Connectivity)
Introduction to ADBC Framework
Consuming Select Queries in ABAP Reports using ADBC Parameter Binding in Queries using ADBC
Consuming Stored Procedures using ADBC
Parameter Binding in Stored Procedures using ADBC Accessing DDL and DML statements using ADBC
 
AMDP (ABAP Managed Database Procedures)
 
Introduction to AMDP and ADT
Creating AMDP’s
Consuming AMDP’s from ABAP Reports
AMDP Vs Stored Procedures Passing Parameters to AMDP
Select-option functionality in AMDP
 
IDA (Integrated Data Access)
 
Traditional ALV Vs ALV IDA Report Development using ALV IDA
Manipulating Field catalog and Toolbar in ALV IDA Parameters and Select-Options in ALV IDA
 
CDS (CORE DATA Services)
 
Introduction and Components of CDS Views CDS simple views
Consuming CDS views from ABAP Reports and ALV IDA Reports CDS views with parameters
Interactive ALV
Select-option functionality in CDS views
CDS Views with Functions and Arithmetic Expressions CDS Views with Joins and Associations
CDS view Table Functions
Exposing CDS Views as ODATA Service CDS View Extension

 
HANA MODELING
 
Introduction to HANA Modeling
Creating Attribute, Analytic, Graphical Calculation Views Creating External Views for HANA Modeling Views
Consuming External Views from ABAP Reports
Creating Graphical Calculation views integrating with Table Functions