Hand-on Training based on ABPAP on HANA with content like NATIVE HANA, HANA MODELLING, CDS VIEWS, AMDP, ADBC, ALV IDA
ABAP on HANA Training Tutorial A to Z concepts
What you’ll learn
- NATIVE HANA.
- HANA MODELLING.
- AMDP.
- ADBC.
- CDS VIEWS.
- ALV IDA.
Course Content
- Introduction, Pre-requisite, ECC vs ABAP HANA vs S/4HANA & C2D vs D2C –> 2 lectures • 26min.
- Architecture & Use cases of HANA –> 3 lectures • 38min.
- Hana studio overview –> 4 lectures • 57min.
- SQL Statement – CREATE & INSERT – With Not Null & Primary Key Constraints –> 3 lectures • 46min.
- Create, Drop & Re-Impose Constraint and how to check System View Constraint –> 4 lectures • 57min.
- Unique constraint, composite primary key, remove the coulmn –> 6 lectures • 1hr 1min.
- Foreign key constraint, Delete rule cascade, Update rule – restrict –> 3 lectures • 50min.
- Referential Integrity without Foreign key, Trigger creation –> 2 lectures • 39min.
- Referential integrity 2nd rule –> 2 lectures • 23min.
- Database view (Projection & selection), Updatable view, Read only view –> 3 lectures • 48min.
- Instead of Trigger on DatabaseView –> 3 lectures • 45min.
- Joins (Inner, Left, right, full) , tabl & view creation using UI –> 2 lectures • 35min.
- SEQUENCES –> 3 lectures • 43min.
- Index – Unique index, BTree Index, CPBTree Index –> 3 lectures • 41min.
- Procedure –> 4 lectures • 56min.
- Procedure (using cursor & Loop End Loop) –> 2 lectures • 33min.
- Procedure (Cursor FOR LOOP) –> 2 lectures • 36min.
- Procedure (Table Type) –> 2 lectures • 36min.
- Procedure (Handler Block) –> 1 lecture • 28min.
- Procedure (Array – ARRAY_AGG, UNNEST, CARDINALITY) –> 1 lecture • 37min.
- Procedure E.g. & Column View –> 1 lecture • 31min.
- Standard way of creating Procedure –> 1 lecture • 46min.
- User Defined Functions –> 1 lecture • 1hr 4min.
- Synonym –> 1 lecture • 21min.
Requirements
ABAP on HANA Training Tutorial A to Z concepts
************
We are working on recording the videos, Database object Development is completed, within 1-2 days, all will be uploaded, then we will start with AMDPs. and We will try to upload at least 2 videos everyday for remaining topics like AMDP, ADBC, CDS VIEWS, HANA MODELLING, ALV IDA.. so please be with us. Our target is to complete this module in next 1 month.
*************
ABAP (development) for SAP HANA refers to all developments which leverage the power of SAP HANA within ABAP-based applications. In this context, the SAP HANA platform is the primary database underlying the ABAP platform. This system deployment option is supported with AS ABAP 7.4 onwards.
If you are already well versed with Normal ABAP programming, you need to understand the power of SAP HANA [High-performance ANalytic Appliance] before proceeding further.
ABAP Core Data Service (CDS):
CDS represents SAP’s next generation of data definition and access for database-centric applications. Technically, CDS uses and extends SQL to capture the business intent.
ABAP Managed Database Procedures (AMDP) for SAP HANA:
AMDP provide a class-based framework for creating and calling SAP HANA database procedures and functions from the ABAP environment – i.e. AMDP procedures and AMDP functions. The ABAP platform is the sole master regarding the lifecycle management (creation, update, deletion and transport) of such SAP HANA entities.
ADBC:
ADBC is an API for the Native SQL interface of the AS ABAP that is based on ABAP Objects. The ADBC methods can be used to pass Native SQL statements to the database interface. The make it possible to
- send database-specific SQL commands to a database system and process the result
- establish and administer database connections.
ALV with IDA
ALV with IDA (SAP List Viewer with Integrated Data Access) helps tables that contain very large quantities of data to be displayed on the UI.
DATABASE OBJECTS DEVELOPMENT
Tables, views, sequences, synonyms, procedures, functions, constraints, indexes, arrays etc…
Objectives
1. Insights on ABAP Development Tools
2. Gain knowledge on Database Independent Code-to-data
3. Understand SQL and SQLScript Basics for SAP HANA
4. Learn Reading data from a table or view
5. Gain knowledge Sorting and limiting data result sets
6. Understand the concept of detecting and analyzing the performance of your ABAP Database Connectivity (ADBC)
7. Learn how to debug ABAP-Managed Database Procedures
8. Understand how to implement SAP HANA Full-Text Search in ABAP
Pre-requisites
It is recommended that the trainee should have the following:
1. Basic Knowledge of ABAP Programming
2. Basic Programming skills
3. Knowledge of Open SQL
4. A general understanding of SAP HANA would be beneficial
Who should attend this Training?
1. ABAP Application Developers
2. ABAP Development Consultants
3. ABAP Development Architects