Course Detail

Course Description

Introduction

SAP HANA Basics and Technical Concepts
Pre-requisites
Introducing the SAP HANA Studio
ABAP and SAP HANA
Introducing the ABAP Development Tools (ADT)
Architecture

Architecture
Presistent Layer
Backup & Recovery
HANA-SQL (HA150)

Reading Data From A Table
Aggregating Data
Reading Data From Multiple Tables, i.e UNIONs, JOINs,Sub Querries
Joins – Cartesion, Inner, Outer Joins
Understanding NULL Values
Changing Data Stored in Tables
Defining How Data Is Stored(CREATE, ALTER , DROP )
Defining Data Access(GRANT, REVOKE)
Taking ABAP to SAP HANA

SAP HANA as Secondary Database– Access via Open SQL
Preparing ABAP Code for SAP HANA
Guided Performance Analysis
Improve Open SQL Statements Using The SQL Trace (ST05)
Performance Rules and Guidelines for SAP HANA
Database Independent Code-to-Data

Classical Open SQL and Its Limitations
New Open SQL
Core Data Services in ABAP
Associations in Core Data Services
Core Data Services with Input Parameters
Incorporating Authorization Checks with CDS
SAP HANA specific Code-to-Data

ABAP Database Connectivity (ADBC)
Native SQL Syntax
ABAP-Managed Database Procedures
Debugging ABAP-Managed Database Procedures
Consuming SAP HANA Objects in ABAP

Working with Views in SAP HANA Studio
Consuming SAP HANA Views using Native SQL
Working with Database Procedures in SAP HANA Studio
Calling SAP HANA Procedures in ABAP
SAP HANA Proxy Objects

Accessing SAP HANA Views via ABAP Dictionary External Views
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

Advanced Topics

Using SAP HANA Full Text Search
ABAP List Viewer with Integrated Database Access (ALV IDA)
ALV Optimized for SAP HANA to Display an External View
Optimizing a Report with CDS View and ALV IDA
Modeling(HA-300)

Creating business rules
Glide record
Information Views
Dimension Calculation Views
Measures in Calculation Views
CUBE with Star Join Calculation View
Combine Two Data Sources with a Union Node
Understanding Deprecated Graphical Views
Implement Currency Conversion in a Calculation View

Data Provisioning

Uploading Data from Flat Files
SAP Data Services
SAP LandScape Transformation Replication Server(SLT)
SAP Direct Extractor Connection(DXC)
Catalog ui policies
Order guide
Record prodcucer