SAP ABAP On HANA | Native HANA | AMDP | CDS |

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

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

Standard SQL Functions

STORED PROCEDURES

Creating Stored Procedures

Creating Database Procedure Proxies

Consuming Stored Procedure from ABAP Reports

Scalar Functions

Table Functions

ABAP HANA

(PRE-REQUISITES: ABAP PROGRAMMING)

3

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

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

CDS Views with Functions and Arithmetic Expressions

CDS Views with Joins and Associations

CDS view Implemented in AMDP Table Functions