Sap Abap On Hana | Native Hana | Amdp | Cds |

SAP ABAP On HANA, with Native HANA , Stored Procedures, ADBC, AMDP, CDS

What you'll learn

Native HANA Development

Stored Procedures

ADBC (ABAP DATABASE Connectivity)

AMDP (ABAP Managed Database Procedures)

IDA (Integrated Data Access)

CDS (CORE DATA Services)

HANA Modeling

Requirements

GOOD Knowledge in ABAP and OOPS ABAP is required

Description

SAP HANA IntroductionFeatures and Architecture of HANA DatabaseABAP HANA IntroductionRole of ABAP consultants in SAP HANAData to Code Vs Code to Data ApproachIntroduction to HANA StudioNative HANA DevelopmentIntroduction to SQL and Database ObjectsRow Store Table Vs Column Store TableDatabase Tables – CRUD OperationsTransaction Control StatementsOrder By, Group By, Having, Where ClausesPrimary key and Foreign Key ConstraintsGlobal Vs Local Temporary TablesDefining and Managing TriggersSequencesSynonymsAltering Database ObjectsTable TypesProceduresFunctionsTemporary Internal TablesConditional and Looping statementsCursorsException HandlingViewsArraysJoinsIndexesStandard SQL FunctionsSTORED PROCEDURESCreating Stored ProceduresCreating Database Procedure ProxiesConsuming Stored Procedure from ABAP ReportsScalar FunctionsTable FunctionsABAP HANA(PRE-REQUISITES: ABAP PROGRAMMING)3ADBC (ABAP DATABASE Connectivity)Introduction to ADBC FrameworkConsuming Select Queries in ABAP Reports using ADBCParameter Binding in Queries using ADBCConsuming Stored Procedures using ADBCParameter Binding in Stored Procedures using ADBCAccessing DDL and DML statements using ADBCAMDP (ABAP Managed Database Procedures)Introduction to AMDP and ADTCreating AMDP’sConsuming AMDP’s from ABAP ReportsAMDP Vs Stored ProceduresPassing Parameters to AMDPSelect-option functionality in AMDPCDS (CORE DATA Services)Introduction and Components of CDS ViewsCDS simple viewsConsuming CDS views from ABAP Reports and ALV IDA ReportsCDS views with parametersCDS Views with Functions and Arithmetic ExpressionsCDS Views with Joins and AssociationsCDS view Implemented in AMDP Table Functions

Overview

Section 1: Native HANA Development

Lecture 1 Working with HANA studio, Schema, Table creation , Data Insertion etc..

Lecture 2 FOREIGN KEY CONSTRAINT, ON DELETE CASCADE,DELETE RESTRICT

Lecture 3 Comments , Triggers

Lecture 4 Sequence, Triggers few more examples , Introduction to Procedures

Lecture 5 Procedures with and without parameters like IN, Out , IN & OUT

Lecture 6 Procedure to retrieve data from DB table and assign to local internal table

Lecture 7 Procedure parameter referring to DB Table, Table Type Creation using UI

Lecture 8 Generating column view with input parameter , If Endif, Case Endcase, While end

Lecture 9 Cursors, cursor for loop

Lecture 10 Static SQL, Dynamic SQL, SQL functions, DATETIME functions , Number Functions

Section 2: Consuming Stored Procedures of HANA DB in ABAP Reports (ADBC) (Procedure Proxy)

Lecture 11 Steps to use ADBC ( Working with ADBC )

Lecture 12 Creating Database procedure proxy Part 1

Lecture 13 Creating Database procedure proxy and consuming in report program Part 2

Lecture 14 Consuming Stored Procedure in ABAP Reports using ADBC

Lecture 15 Consuming modified stored procedure in ABAP reports

Lecture 16 Exception Handling in ABAP On HANA

Lecture 17 Functions and types of functions

Lecture 18 ARRAYS in ABAP On HANA

Lecture 19 One more example using ARRAYs , Functions, Procedures

Lecture 20 Order by clause , group by clause , Having clause , Delete, Truncate, commit,

Lecture 21 Database Views

Lecture 22 CE FUNCTIONS IN ABAP ON HANA

Lecture 23 CE FUNCTIONS PART 2

Section 3: AMDP (ABAP MANAGED DATABASE PROCEDURE)

Lecture 24 AMDP Introduction and sample program

Lecture 25 Passing Parameters to AMDP

Lecture 26 Select-option functionality in AMDP

Section 4: CDS ( Core Data Services ) Views

Lecture 27 Simple/sample program on CDS views

Lecture 28 CDS views with parameters CDS Views with Functions and Arithmetic Expressions

Lecture 29 CDS View with multiple parameters, association, and consuming in report

Lecture 30 CDS Table functions

For ABAP Developers who want to upgrade their skills to ABAP On HANA