Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SAP ABAP On HANA | Native HANA | AMDP | CDS |
Rating: 4.4 out of 5(33 ratings)
276 students

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

SAP ABAP On HANA, with Native HANA , Stored Procedures, ADBC, AMDP, CDS
Created bySree Harsha Reddy
Last updated 5/2024
English
English [Auto],

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

Course content

5 sections • 38 lectures • 15h 57m total length

  • ABAP On HANA Introduction29:54

    This ABAP on HANA introduction explains HANA as an in-memory database and application, compares data-to-code and code-to-data, and shows code pushdown using CDS views, AMDP, SQL script programming, and AMD.

  • Working with HANA studio, Schema, Table creation , Data Insertion etc..42:17

    In this session you will learn how to work with HANA studio, what is perspective , Catalog, Schema , system schema. How to create tables and how to insert data into the tables and many more. All these are basics to learn the advanced concepts of ABAP On HANA.

  • FOREIGN KEY CONSTRAINT, ON DELETE CASCADE,DELETE RESTRICT32:33

    In this session you will learn about foreign key relation ship in ABAP on HANA, what is on delete cascade and delete restrict. How to alter or how to add any constraint to the table etc

  • Comments , Triggers28:35

    In this session you will learn about comments and how to create comments. Global temp table and local temp table. Triggers and and more etc

  • Sequence, Triggers few more examples , Introduction to Procedures30:21

    In this session you will learn about sequence, couple of examples for sequence. One more example of trigger with the combination of sequence. Introduction to procedures with demo programs.

  • Procedures with and without parameters like IN, Out , IN & OUT13:39

    In this session you will learn about procedures, how to create procedures with or without parameters.

  • Procedure to retrieve data from DB table and assign to local internal table5:31

    Create procedures to retrieve data from a database table, assign results to a local internal table, and call them to fetch products data.

  • Procedure parameter referring to DB Table, Table Type Creation using UI40:42
  • Generating column view with input parameter , If Endif, Case Endcase, While end38:00
  • Cursors, cursor for loop38:21

    Explains cursors in SAP ABAP on HANA: declare, open, fetch, close; shows a transfer_data procedure splitting employees into manager and non-manager with 5% and 10% salary increments.

  • Static SQL, Dynamic SQL, SQL functions, DATETIME functions , Number Functions46:07

    In this session you will learn about static SQL, select statement assigned to local variable but not executed, seect statement assigned to local variable and executed. Dynamically constructed select query. Dynamically constructed select query and where clause. Dropping a procedure. SQL functions , data type conversion functions. Date time functions. number functions . String functions.

Requirements

  • GOOD Knowledge in ABAP and OOPS ABAP is required

Description

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


Who this course is for:

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

Report abuse