Udemy Business

Teach on 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 |

Name: SAP ABAP On HANA | Native HANA | AMDP | CDS |
Rating: 4.4 (33 reviews)

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
Learn to create ABAP procedures that reference database tables or table types via UI, test them with internal tables, and build column view analyze_sales with date, name, and amount calculations.
Generating column view with input parameter , If Endif, Case Endcase, While end38:00
Generate a dynamic column view using input parameters in ABAP on HANA, and apply if, case, and loop constructs in procedures.
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.

Steps to use ADBC ( Working with ADBC )51:30
Learn to consume HANA stored procedures in ABAP reports using ADBC, covering native SQL, Open SQL, and the database procedure proxy approach with CL_SQL_CONNECTION and CL_SQL_STATEMENT.
Creating Database procedure proxy Part 128:32
Creating Database procedure proxy and consuming in report program Part 237:24
Create a HANA stored procedure in a package, expose it via a database procedure proxy, and consume it from ABAP reports using the ADBC framework, with design-time and runtime objects.
Consuming Stored Procedure in ABAP Reports using ADBC37:10
Learn to consume a stored procedure in ABAP reports using ADBC, with an overview that creates a dynamic internal table to fetch results.
Consuming modified stored procedure in ABAP reports10:38
Modify an existing hana database procedure, synchronize the proxy, and consume the updated procedure in an abap report by supplying an input parameter (department number) and receiving an output.
Exception Handling in ABAP On HANA22:45
Master exception handling in ABAP on HANA by capturing system errors and displaying custom messages; declare exceptions, manage unique constraint violations, and capture standard SQL error codes in procedures.
Functions and types of functions20:42
Learn to create and use scalar and table user-defined functions in SAP ABAP on HANA, compare with stored procedures, and implement parameter handling and return values.
ARRAYS in ABAP On HANA35:20
Explore arrays in ABAP on HANA with hands-on examples, including creating tables, updating commissions via procedures, and using arrays with internal tables and unnest.
One more example using ARRAYs , Functions, Procedures24:56
Create a copy of e_department, define a table type, and implement a function and a procedure that manipulate data with arrays, upsert into the table, and insert results into e_department_copy.
Order by clause , group by clause , Having clause , Delete, Truncate, commit,30:20
Explore how to sort data with order by, group by and having, and manage data with delete, truncate, commit, and rollback in SAP ABAP on HANA.
Database Views10:50
Learn how database views act as virtual tables on base tables to enforce security by hiding table names and column names, and restricting data access, with data populated at runtime.
CE FUNCTIONS IN ABAP ON HANA14:11
Explore C functions in ABAP on HANA, also called calculation functions and calculation engine plan operators, optimized for HANA and faster than SQL, with data source access and relational operators.
CE FUNCTIONS PART 220:19
Explore Hana modeling by massaging data on raw tables with calculations to design graphical views. An attribute view generates a column view stored in the SSIS schema.

AMDP Introduction and sample program26:24
Introduce AMDP, the ABAP managed database procedure framework for Hana. Compare bottom-up and top-down approaches, and demonstrate creating an MDP in ABAP to access a Hana table.
Passing Parameters to AMDP38:23
Explore defining and consuming amdp in sap hana using abap development tools, covering interface prerequisites, by-value parameters, internal table returns, and a sample that fetches sales order header and items.
Select-option functionality in AMDP27:02
Implement select options and ranges in abap report, pass them to amdp method, and retrieve sales order header and item data from the hana database using code-to-data and internal tables.

Simple/sample program on CDS views14:48
Learn to build a simple CDS view in ABAP on HANA using a data definition and the define view template, activate to create a SQL view, and consume it.
CDS views with parameters CDS Views with Functions and Arithmetic Expressions33:13
CDS View with multiple parameters, association, and consuming in report23:06
Learn to build cds views with inner and left outer joins and associations, including parameters, and consume these views in an abap report with alv display.
CDS Table functions17:37
Explore creating an ABAP CDS table function integrated with AMDP and MDB, define its signature, implement in an MDP class, and return a table of concatenated cities per airline.
Consuming CDS Views as OData service Part 16:28

Report Development using ALV IDA13:06
Display a cds view in alv ida format using the ida class to create alv for cds views and show data in full screen with view parameters.
Display CDS view in ALV IDA9:14
Consume the cds view in alv ida to display z_cds_customer data. Create a container object, bind it to a custom control, and use cl_slv_gui_table_idit to render the cds view.
Display Options in IDA ALV13:33
Set the ALV report title, enable zebra pattern via display options, and hide a country column by modifying the field catalog and calling set available fields to refresh the ALV.
Custom Column Headings in ALV IDA4:56
Learn to change a specific ALV IDA column heading and tooltip by using the field catalog's set field header text, passing the field name, new header text, and tooltip.
Using Select Options in ALV IDA9:33
Interactive ALV IDA consuming CDS View29:09
Enable double click on the customer number in the ALV and pass the clicked value to a consuming CDS view to display related sales orders.

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)

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

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

What you'll learn

Explore related topics

Course content

Native HANA Development11 lectures • 5hr 46min

Consuming Stored Procedures of HANA DB in ABAP Reports (ADBC) (Procedure Proxy)13 lectures • 5hr 45min

AMDP (ABAP MANAGED DATABASE PROCEDURE)3 lectures • 1hr 32min

CDS ( Core Data Services ) Views5 lectures • 1hr 35min

ALV with IDA ( Integrated Data Access )6 lectures • 1hr 20min

Requirements

Description

Who this course is for: