• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
Job Meter = High


30 Hours
Self-paced Training (pre-recorded videos)
USD 17 (USD 140)
Save 88% Offer ends on 31-Dec-2023
SAP ABAP on HANA course and certification
88 Learners

About this Course

SAP ABAP (Advanced Business Application Programming) is a popular enterprise programming language for SAP application, where the coding is done irrespective of underlying database. With an evolution of HANA database, the companies have replaced rest other databases with HANA database. The HANA database has fast access and compress the data. So, basically organizations have shifted their coding strategy to HANA in order to attain all the benefits of HANA.
The process of improving the existing program code to HANA compatibility is referred as SAP ABAP on HANA or SAP ABAP for HANA.


ABAP remains a key language as many SAP business applications and custom developments are written in ABAP, with SAP HANA ABAP there are numerous improvements to the ABAP language, which allow writing streamlined ABAP code and benefitting from SAP HANA.

SAP ABAP on HANA is referred to as administration of the SAP system.
SAP HANA is the newly created ERP solution from the SAP. SAP HANA is merged with a combination of hardware and software components. SAP HANA has unparalleled adoption by the SAP customers across the globe. HANA is the latest ERP solution in memory, column-oriented, relational database, and platform developed by SAP SE which can be implemented in office premises or through cloud. SAP HANA basically combines hardware and software, integrating varied components such as SAP HANA database, SAP SLT (System Landscape Transformation), Replication server, and Sybase. It is future generation memory business platform and speeds up analytics and applied on a single and in-memory platform.

Why ABAP for HANA? Below given are the few reasons why to choose SAP HANA:

Real Time – SAP HANA provides real-time data provision and reporting.
Speed – SAP HANA provide high processing speed on massive chunk of data because of the in-memory technology.
Any source type – SAP HANA can handle different data source which includes structured or un-structured data from SAP or non-SAP source.
Cloud – SAP HANA and database can be moved to the cloud environment.
Simple – SAP HANA reduces human efforts behind data aggregation, Indexing and mapping.
Cost-effective – SAP HANA assures to reduce the IT cost of an organization.

This comprehensive SAP ABAP on HANA course by Uplatz is designed for both the beginners who are trying to learn ABAP on HANA as well as the seasoned ABAP coders who quickly want to switch to ABAP on HANA, and most importantly to provide in-depth knowledge to consultants involved in transition from traditional ABAP to HANA.


Course Objective

The main intent of this SAP ABAP on HANA certification course provided by Uplatz is to showcase an overview of the new coding techniques in SAP ABAP post introduction of HANA database. The SAP ABAP on HANA training course provides valid guidelines on what basis an ABAP developer should implement the new coding techniques.

By the end of this training you will:
- Understand the core concepts of SAP’s HANA ABAP module.
- Be able to apply the knowledge learned to progress in your career as an associate level SAP HANA ABAP Technical consultant.


Target Audience

·       Newbie coders
·       SAP ABAP Developers
·       SAP Consultants
·       SAP Project team members
·       SAP Consultants to expand their skills
·       Application Developers



Course Details & Curriculum

Lesson 00 - Introduction:

- Introductions to SAP HANA
- Introduction to ABAP for HANA

Lesson 01 - System Requirement and system set up:

- SAP HANA ADT Installation on HANA Studio
- Overview of HANA studio
- Overview of ABAP development environment in eclipse
- Adding system in HANA studio
- Creating package in HANA Studio
- Setup environment in eclipse for ABAP development
- ABAP perspective in SAP HANA

Lesson 02 - Architecture for ABAP for HANA

- Evolution and architecture
- Overview for ABAP meets HANA
- Code to data paradigm

Lesson 03 - ABAP development change for HANA

- Coding guide line for ABAP On HANA
- Performance Impact
- SQL Foot Prints in your productive system
- Performance Analysis
- ALV For HANA and Other improvement

Lesson 04 - New in ABAP Development environment

- Open SQL Enhancement
- Introduction to advance view building in ABAP for HANA
- Core data service
- SAP HANA Usage in ABAP
- ABAP managed database procedure
- ALV with integrated data access on SAP HANA
- Core data service with input parameter


E_HANAAW_14 (SAP Certified Development Specialist - ABAP for SAP HANA 2.0)

The SAP certified Development Specialist – ABAP for HANA is an online certified exam conducted by SAP, the known market leader in enterprise software. SAP ABAP on HANA certification is useful in validating the experience and knowledge of programming ABAP for HANA who are looking out for a scope of improvement in the SAP ABAP development consultant job profile. The SAP ABAP on HANA training certified course develops dual knowledge learnt related through theory and practical, where the SAP development specialist can impart through the learnt stuff in the assigned project.


The "SAP Certified Development Specialist - ABAP for SAP HANA 2.0" certification exam validates that the candidate has the knowledge of programming ABAP for SAP HANA required by the profile of an SAP ABAP development consultant. This ABAP for SAP HANA certificate builds on both the basic knowledge gained in related ABAP-for-HANA training and documentation, as well as on practical experience gained as a member of a SAP HANA team, where the candidate would apply this knowledge practically in projects. It is highly recommended that you have passed one of these certification exams for the "SAP Certified Development Associate - ABAP with SAP NetWeaver" (C_TAW12_70, C_TAW12_71, C_TAW12_731, C_TAW12_74, C_TAW12_750).


Career Path

The SAP ABAP for HANA course provides wide range of job opportunities owing its popular technology. The leading IT companies hire SAP HANA ABAP consultants because of in-memory database and administration capabilities. There is a high demand for SAP HANA ABAP skills in the industry and as such many highly rewarding opportunities are available in the industry.

The following are the job titles in SAP ABAP on HANA field:

·       SAP ABAP on HANA Consultant
·       SAP ABAP HANA Engineer
·       SAP ABAP HANA Architect
·       SAP HANA Administrator
·       SAP HANA Business Analyst
·       SAP ABAP/HANA Data Modeler
·       SAP HANA Project Manager


Job Prospects

The SAP HANA ABAP consultant draws an average salary from $90,000 per annum to $150,000 per annum based on seniority level. Since ABAP programmers are in high demand in the industry and with the efficiencies and benefits of HANA infrastructure the SAP ABAP on HANA consultants and developers command high growth potential.



Interview Questions


1) What is SAP HANA?

HANA is defined as High Performance Analytical Appliance, a​​ full transactional​​ RDBMS system given by SAP consisting of IMCE (In-Memory Computing Engine) which combine row based and column-based architecture. It​​ can do both OLTP and OLAP in a single box​​ which includes both Hardware and Software Innovations. ​​ It is also known as Hybrid Database System.


2) Points to be considered when Migrating to HANA?

·       Native SQL statements​​ will not work​​ –​​ it will result into​​ Runtime error – Dumps

·       If you have some indication to Database – not showstopper.

·       If you are doing a search based on non-pk columns in data based and you have not used ORDER BY clause in SQL statement, it can produce problems.

·       Direct access to database cluster/pool tables


3)      What are​​ the​​ Guidelines to be followed for SQL performance on ABAP on HANA?

·       Keep result set small

·       Minimize the number of data transfers

·       Minimize the amount of data transfer

·       Minimize the search overhead on database

·       Don’t overhead db with unnecessary operations

·       Discard the rows based on check, exit statements in a loop

·       Use proper ‘where’ clause to minimize the dataset

·       Make use of joins and sub-queries

·       Never do select *. Instead use specific column names mainly during aggregation such as sum, count, etc.

·       Try to read db tables based on index

·       Avoid redundant storage

·       Sort data in program

·       Use buffering


4)  What is Normalization in ABAP on HANA?

Normalization concept means to reduce the redundancy of data.


5) What is ABAP Test Cockpit in ABAP on HANA?

Code inspector/ATC checks are static code findings against guidelines. These findings won’t help you to prioritize your list of improvements. You need real-time performance data to find which is the first program to fix.


6) Class to calculate runtime in ABAP on HANA?



7) How to specify client field in Native Query?



9) What is the Tcode for EPM scenario?

SEPM_DG – Data Generator


10)   What are​​ different​​ Code-pushdown techniques in ABAP on HANA?

-- SQL Queries​​ _ imperative and declarative logic​​ (use literals, arithmetic, logical expression inside the queries​​ and using expressions like CEIL, FLOOR, ABS, TRUNC, FRAC can be part of Open SQL statements)

-- CDS Views

-- AMDP: ABAP Managed Data Procedures​​

-- Information Models​​ and consuming those in ABAP using proxy​​ object techniques


11) What are Entry points in SAP ABAP on HANA?

Different ways in which an SQL query is getting called are called Entry points. E.g., Program, Background job, Function Module, etc.


12) What are inline declarations in ABAP on HANA?

Inline declarations​​ is a​​ new way of declaring variables and field symbols at operand positions.


·       DATA(text) = `…`.

·       LOOP AT itab INTO DATA(wa).

·       FIND … IN … MATCH COUNT DATA(cnt).



13) When do you use​​ “GROUP BY” ​clause in HANA SQL statements?

While using aggregate functions in a SELECT QUERY, all the columns that do not belong to aggregate-functions should be put in GROUP BY Clause.


14)   What is the transaction code to check​​ Schema name?



15)   Can multiple ABAP systems connect to ABAP Database?

Yes. ​​ HANA 1.0​​ SP09 onwards.


16)   What is a Catalog in SAP HANA?

A Catalog is a collection of Database Schemas in HANA. ​​ Schema: grouping of all database objects, Schema is a mandatory database object allows companies to use same database keeping data from multiple system​​ where​​ DCL and​​ DB​​ constraints can be managed at schema level.


17)   What is AMDP (ABAP Managed Data Procedures)? ​​ 

This approach is called​​ top-down approach​​ where a procedure is created in ABAP stack​​ NW 7.4 SP05​​ which acts like Master for editing, activating and transporting ( life-cycle) for the procedure object.​​ When it is called for the 1st​​ time corresponding HANA DB procedure gets created to support code-to-data paradigm or code-pushdown to HANA DB.


18)   What is CDS View?

CDS view is basically an abstraction of ABAP to Database layer which allows you to model semantic rich data models (like Information views on HANA DB )​​ on ABAP Stack and on activation it leads to creation of corresponding Database View in DB.​​ It​​ is an enhancement of SQL which provides us DDL for defining semantically rich data models (table/view) and user define types in Database.​​ It is an extension of SQL : i.e. DDL DQL and DCL. The objective behind creating​​ CDS Data Model is that , it will be​​ understood by​​ all SAP products​​ viz​​ SAP Fiori,​​ KPI modeler,​​ BO/BI,​​ BOPF, FPM, IDA​​ Native HANA Apps. 


Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +

Didn't find what you are looking for?  Contact Us