• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register

4.3 (29 reviews)
( 173 Students )
20 Hours



You will learn the features of SAP HANA database that are relevant to SAP ABAP development on HANA. Leverage the power of HANA with ABAP applications.
( add to cart )
Save 59% Offer ends on 31-Dec-2023
Preview SAP ABAP on HANA course
View Course Curriculum   Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

SAP ABAP on HANA is a development of traditional ABAP (Advanced business application programming) on the HANA platform. SAP ABAP on HANA has column-based tables, open SQL as compared to the previous ABAP SQL with limited feature.


SAP ABAP HANA has taken a quantum leap in SAP technology that aims at digitization of the whole economy, not only in new custom development projects but also in the existing applications. ABAP remains as an important language for many custom developments and SAP business applications. All SAP products are moving to SAP HANA, this demands SAP ABAP NetWeaver Application Server to leverage the features and capabilities of the SAP HANA database.


ABAP for SAP HANA refers to all developments which leverage the power of SAP HANA within ABAP applications. In this course, the instructor introduces you to the fundamental skills needed to understand  ABAP development for SAP HANA programming concepts and start creating your own ABAP for HANA programs. ABAP continues to be a crucial language for several customized advancements and SAP company applications. Invade of ABAP 7.4, resulted in various enhancements to the ABAP language, which permits composing streamlined ABAP code and getting benefits of SAP HANA. This is one of the most valued and respected professional requirements for professionals who build cutting-edge business applications leveraging the proven, reliable ABAP technology as well as the robust in-memory capabilities by SAP HANA.



The SAP ABAP on HANA online training course by Uplatz will help you understand how to optimize ABAP applications that provide access to data stored in the SAP HANA Database. Our training covers core data services features for unified data modeling and definition, database-independent programming with open SQL, and simplified control of stored procedures with ABAP – managed database procedures.

The training course aids you to understand the optimization of ABAP (Advanced Business Application Programming) applications that gives access to data saved in the SAP HANA Database. Our training covers features for unified data modeling and definition with core data services, database-independent programming with open SQL, and simplified control of stored procedures with ABAP – managed database procedures.


In this SAP ABAP on HANA course you will be able to learn the basics and introduction of fundamentals of the transition of traditional ABAP on HANA, its architecture, coding guideline for ABAP on HANA, performance analysis, ALV with integrated data accessed, etc. This ABAP on SAP HANA course helps you to master the optimization of ABAP applications that gives access to data stored in the SAP HANA Database.

Our training covers features for unified data modelling and definition with core data services, database-independent programming with open SQL, and simplified control of stored procedures with ABAP – managed database procedures. This professional certification course is also best suited for SAP ABAP Application Developers, SAP ABAP Development Consultants, SAP ABAP Development Architects.

Course/Topic - SAP ABAP on HANA - all lectures

  • In this lecture we will have an introduction on what is SAP HANA and what is in memory database.

    • 1:12:17
  • In this session we will study about getting some hands-on coding experience in SAP HANA and inline declinations.

    • 1:30:57
  • In this session we will study about getting some hands-on coding experience in SAP HANA.

    • 58:18
  • In this session we will g=have a detailed insight on what is core data services.

    • 1:21:27
  • In this lecture we will study about ALV concept IDA with HANA.

    • 1:17:26
  • Here in this lecture we will study about basic concepts of SQL and functions of SQL.

    • 24:56
  • In this lecture we will study about SQL scripts, its functions and stored procedures.

    • 51:32
  • In this lecture we will discuss about different scenarios on stop base structure and debugging structure.

    • 1:06:43
  • In this lecture we will study about designing structure on AMDP editor.

    • 47:02
  • In this lecture we will study about ABAP database connectivity and secondary database connection.

    • 56:16
  • In this lecture we will study about different modelling views.

    • 53:34
  • In this lecture we will perform some coding on ABAP editor.

    • 1:02:33
  • In this lecture we will see how to create columns and restricted parameters.

    • 50:14
  • In this lecture we will see what is SAP HANA content transport management.

    • 36:37
  • Here we will understand how to write queries and hidden values in text.

    • 39:06
  • In this lecture we will talk about the functions of SAP HANA CE

    • 20:16
  • In this lecture we will talk about some features of SAP HANA and SAP NetWeaver Gateway services.

    • 57:04
  • In this lecture we will study about how to create OData services in a nutshell.

    • 56:55
  • In this lecture we will study about different classes and extensions and how to define classes based on your requirement.

    • 1:04:49
  • – In this lecture we go through all the above taught topics as a summary .

    • 22:47
Objectives Back to Top

The main objective of the course is to provide skills on ABAP development for SAP HANA, hence it not cover any SAP HANA modeling or SAP UI5/FIORI development concepts.

Learn features of SAP HANA database which are relevant to ABAP development for SAP HANA.

Design simple and advanced SAP HANA applications with ABAP

Understand the important concepts in ABAP development for SAP HANA

Enhance your existing SAP ABAP skill-set

Helps to get a job in ABAP development for SAP HANA

SAP HANA features

Code to Data Paradigm

ABAP Development Tool (ADT Eclipse)

ABAP Core Data Services ( CDS ) views

ABAP managed database procedures ( AMDP )

ABAP Database Conectivity ( ADBC )

ALV IDA ( Integrated Data Access )

Select-options with AMDP

Select-options with CDS Views

Creation of CDS based SAP FIORI List Report Application

VDM Virtual Data Models with CDS Views

Install Develop Environment, SAP HANA Studio and ABAP Development Tools for SAP NetWeaver. Detect and analyze the performance of your ABAP coding

Integrate native SAP HANA objects

Syllabus Back to Top

Unit 1: Introduction

1.   SAP HANA Basics and Technical Concepts

2.   Introducing the SAP HANA Studio

3.   ABAP and SAP HANA

4.   Introducing the ABAP Development Tools (ADT)


Unit 2: Database Independent Code-to-Data

1.   Classical Open SQL and Its Limitations

2.   New Open SQL

3.   Core Data Services in ABAP

4.   Associations in Core Data Services

5.   Core Data Services with Input Parameters

6.   Incorporating Authorization Checks with CDS


Unit 3: SQL and SQL Script Basics for SAP HANA

1.   Reading data from a table or view

2.   Calculated Columns and Functions

3.   Duplicate Elimination

4.   Sorting and limiting result sets

5.   The WHERE clause

6.   Aggregating and grouping data

7.   SQL Script basics


Unit 4: SAP HANA specific Code-to-Data

1.   ABAP Database Connectivity (ADBC)

2.   Native SQL Syntax

3.   ABAP-Managed Database Procedures

4.   Debugging ABAP-Managed Database Procedures

5.   Core Data Services with Table Function


Unit 5: SAP HANA Proxy Objects

1.   Creating and using External Views

2.   Database Procedure Proxies

3.   HANA Transport Container


Unit 6: Advanced Topics

1.   Using SAP HANA Full-Text Search in ABAP

2.   Enabling input fields for type-ahead search

3.   SAP List Viewer (ALV) for SAP HANA

Certification Back to Top

Get a Course Completion Certificate on successfully completing the course.

Career & Jobs Back to Top
Interview Questions Back to Top

Q1) What is the improvement dialect utilized by SAP HANA?



Q2) Name the practical framework SAP HANA bolsters.

More than 70% of clients run the SAP workloads on Linux by the utilisation of the SUSE Linux Enterprise Server, which is the best OS decision for SAP HANA.


Q3) Clarify the Parallel Processing about SAP HANA. 

Using the column information stockpiling tactic, the capacity in SAP HANA is isolated steeply. The columnar tactic permits straight looking and accumulation of information as opposed to two-dimensional information structure. On the off chance that more than one section is to be prepared, each errand is doled out to the assorted processor. Section divisions prepared by the various processors collimate activities into one segment.


Q4) What is SAP HANA?

SAP HANA is an in-memory registering motor (IMCE) utilized for on-going preparing of enormous volumes of information and fabricating and conveying true applications. Receiving the line based and section based DB innovation, SAP HANA is a progressed social DB item overhauled by SAP SE. With this elite logical (HANA) framework, the huge information exists on the primary memory and not on the solid circle. It replaces the onus of information upkeep independently on the heritage framework and rearranges the errands of chairpersons in this advanced world.


Q5) Define the rundown points of interest of utilizing SAP HANA database. 

With the HANA innovation, you can make gen-next applications giving successful and proficient outcomes in the digital economy.

By utilizing scorch information in memory, SAP HANA bolsters:

·       Smooth exchange process and blame tolerant examination

·       Easy and basic activities utilizing an open-source, brought together stage in the cloud

·       High-level Data Integration to get too gigantic measures of information

·       Advanced instruments for the top to bottom examination of the present, past and what's to come.


Q6) List down the benefits and bad marks of utilizing line based tables. 

No information tactic can be quicker than push based in the event that you need to examine, process and recover single record at a time.

a) Line based tables that are helpful when there’s a particular request for getting to finish record.
b) It’s favoured while the table comprises less amount of lines.
c) This information stockpiling and preparing approach is simpler and powerful with no conglomerations and quick looking.


The information recovery and preparing activities include the entire column, despite the fact that all the data isn't valuable.


Q7) Say what is the part of the tirelessness layer in SAP HANA?

SAP HANA has an in-memory figuring motor and accesses the information straightaway with no reinforcement. To stay on the safe side of losing information in case there is an equipment disappointment or power cut off, the diligence layer that comes as a guardian angel stores every one of the information in the hard drive which isn't unstable.


Q8) Say what is displaying studio?

Modelling studio in HANA plays out different errands like:

1. Declares the tables which are put away in HANA, initial segment is to get the meta-information and after that timetable information replication employments
2. Manage Data Services for entering the information from the SAP Business Warehouse as well as from different frameworks
3. Manage ERP cases association; the present discharge does not bolster interfacing with a few ERP occurrences
4. Use information administration for the demonstrating
5. Do demonstrate in HANA itself

6. Essential licenses for the SAP BO information administrations


Q9) Specify what the unique pressure strategies are.

There are three diverse pressure procedures

1. Run-length encoding
2. Cluster encoding
3. Dictionary encoding


Q10) Specify what idleness is.

Latency is eluded to the time span to imitate information from the source framework to the objective framework.


Q11) Clarify what are change rules. 

Transformation administer the control indicated in the propelled replication setting exchange for the source table to such an extent that information is changed amid the replication procedure.


Q12) What is the upside of SLT replication?

SAP SLT chips away at trigger based approach; this kind of approach doesn't have any quantifiable execution affect in the source framework

a) It offers to separate ability and change
b) It empowers continuous information replication, reproducing just related information into HANA from non-SAP and SAP source frameworks
c) It is completely incorporated with HANA studios
d) Duplication from a few source frameworks to one HANA framework is permitted additionally from one source framework to various HANA frameworks is permitted.


Q13) Clarify how you can maintain a strategic distance from un-fundamental data from being put away?

To maintain a strategic distance from un-essential data from being put away, you need to delay the replication by halting the outline related employment


Q14) Specify what is the part of ace controller work in SAP HANA?

The activity is orchestrated on request and is in charge of

? Creating databases trigger in logging table into all the source framework
? Creating Synonyms
? Creating new passages in the administrator tables of the SLT server when a table is repeated/stacked


Q15) Clarify what would happen in case the replication gets postponed for a more drawn out timeframe or framework blackout of SLT or HANA framework. 

If the duplication is postponed for a more drawn out timeframe, the span of the logging table’s increases.


Q16) Specify the part of the exchange director and session.

The exchange principle coordinates databank exchanges and also keeps a record of the running and the closed exchanges. At the point when it is exchanged and is moved back or submitted, that is when the exchange director informs all the including stockpiling motors of the occasion so that they can be run on important activities.


Q17) Clarify the way in which you can stay away from the un-fundamental logging data being discarded.

You can dodge the unimportant logging of the data from being put away by delaying all the replication by ceasing the patterns related employment.


Q18) Clarify how SQL explanation is handled.

Inside the HANA databases, each SQL articulation is actualized in the orientation of the exchange. A new session is dispensed to another exchange.


Q19) Name the different segments of SAP HANA.

The different components of SAP HANA are:

• SAP HANA Studio
• SAP HANA Appliance
• SAP HANA Application Cloud


Q20) What are the distinctive sorts of changeless permit enters in HANA framework?

There are two sorts of perpetual License keys for HANA framework −

1. Unenforced − If unenforced permit key is introduced and utilisation of HANA framework surpasses the permit measure of memory, activity of SAP HANA isn't influenced by this situation.
2. Enforced − If Enforced permit key is introduced and utilisation of HANA framework surpasses the permit measure of memory, HANA framework gets bolted. In the event that this circumstance happens, HANA framework must be restarted or another permit key ought to be asked for and introduced.


Q21) What is the distinction amongst Catalogue and Content tab?

Catalogue −This contains RDBMS matters like compositions, tables, sees, systems, and so forth. You can open the SQL supervisor and plan catalogue objects.
Content − It is utilized to keep up configuration time storehouse. You can make new bundles, and outline Information seen in HANA framework. Different perspectives can be made under substance tab to encounter business prerequisite and for performing diagnostic intelligence on the highest point of the content.


Q22) How you can interface SAP HANA to Microsoft Excel?

MDX Provider is utilized to interface MS Excel to SAP HANA database framework. It gives the driver to interface HANA framework to Excel and is additionally used for information demonstrating. You can utilize Microsoft Office Excel 2010/2013 for availability with HANA for both 32 bit and 64 bit Windows.


Q23) How does SAP HANA bolster import from a nearby document?

Go to File → Import, You will see underneath choice

This is utilized to import information from a level document like .xls or.csv record. Tap on Next → Choose Target System → Define Import Properties.

Select Source document by perusing neighbourhood framework. It also gives a choice on the off chance that you need to keep pushing the header. It likewise gives an opportunity to make another table under existing Schema or in the event that you need to import information from a record to a current table.


Q24) What table write is favored in SAP HANA Administration: segment based or push-based? 

Since logical applications require large accumulations and coordinated information preparing, segment-based tables are favored in SAP HANA. The information in the segment is put away like this consistently empowering quicker and less demanding coherence and recovery. In this manner, columnar capacity is favored on most OLAP (SQL) questions. Push-Based tables drive clients to peruse and get to all the data in succession, despite the fact that you require information from few as well as particular sections.


Q25) Clarify the idea of Persistence Layer.

The tirelessness layer in SAP HANA handles all logging activities and exchanges for secured reinforcement and information re-establishing. This layer oversees information put away in the two lines and segments and gives unfaltering spare focuses. Based on the idea of steadiness layer of SAP's social database, it guarantees effective information re-establishment. Other than overseeing log information on the circle, HANA's determination layer permits read and compose information tasks through all stockpiling interfaces.


Q26) Clarify SLT.

SLT extends to the SAP Landscape Transformation alluding to the trigger – based replication. SLT duplication grants information exchange from cause to target, where the cause could be SAP as well as non-SAP while the objective framework must be SAP HANA along with HANA database. Clients can achieve information replication from numerous causes. The three duplication procedures upheld by the HANA are:

• SAP Business Objects Data Services (BODS)
• SAP HANA Direct Extractor Connection (DXC)


Q27) Name the duplication employments in SAP HANA.

·       Master Job (IUUC_MONITOR_)

·       Information Load Job (DTL_MT_DATA_LOAD__)

·       Ace Controlling Job (IUCC_REPLIC_CNTR_)

·       Movement Object Definition Job (IUCC_DEF_MIG_OBJ_)

·       Access Plan Calculation Job (ACC_PLAN_CALC__)


Q28) Define how IMDB/HANA replaces ORACLE.

When a business suite starts running on the IMDB, the Oracle will not be required anymore by the SAP clients who purchased the HANA. This won't be affecting any of it in the short run since the people who would be buying HANA today would still need an Oracle ERP system.


Q29) How much do HANA cost?

Though SAP hasn't revealed the amount required for buying HANA, yet the cost is to be estimated to be around somewhere from $100k - $200K per TB. Apart from these, there are additional costs such as permitting cost which is decided based on every client premise.


Q30) Detail all the license key which are required in the HANA system along with their validity.

The different license keys which are required for the HANA systems are:

a) PermanentLicenseKey
b) Temporary License Key

The Temporary License keys are installed automatically during the installation of the HANA database. These keys are only valid for 90 days and before the expiration of it, you should opt for the permanent license key from the SAP marketplace.

Q1. What are the payment options?
A1. We have multiple payment options: 1) Book your course on our webiste by clicking on Buy this course button on top right of this course page 2) Pay via Invoice using any credit or debit card 3) Pay to our UK or India bank account 4) If your HR or employer is making the payment, then we can send them an invoice to pay.

Q2. Will I get certificate?
A2. Yes, you will receive course completion certificate from Uplatz confirming that you have completed this course with Uplatz. Once you complete your learning please submit this for to request for your certificate https://training.uplatz.com/certificate-request.php

Q3. How long is the course access?
A3. All our video courses comes with lifetime access. Once you purchase a video course with Uplatz you have lifetime access to the course i.e. forever. You can access your course any time via our website and/or mobile app and learn at your own convenience.

Q4. Are the videos downloadable?
A4. Video courses cannot be downloaded, but you have lifetime access to any video course you purchase on our website. You will be able to play the videos on our our website and mobile app.

Q5. Do you take exam? Do I need to pass exam? How to book exam?
A5. We do not take exam as part of the our training programs whether it is video course or live online class. These courses are professional courses and are offered to upskill and move on in the career ladder. However if there is an associated exam to the subject you are learning with us then you need to contact the relevant examination authority for booking your exam.

Q6. Can I get study material with the course?
A6. The study material might or might not be available for this course. Please note that though we strive to provide you the best materials but we cannot guarantee the exact study material that is mentioned anywhere within the lecture videos. Please submit study material request using the form https://training.uplatz.com/study-material-request.php

Q7. What is your refund policy?
A7. Please refer to our Refund policy mentioned on our website, here is the link to Uplatz refund policy https://training.uplatz.com/refund-and-cancellation-policy.php

Q8. Do you provide any discounts?
A8. We run promotions and discounts from time to time, we suggest you to register on our website so you can receive our emails related to promotions and offers.

Q9. What are overview courses?
A9. Overview courses are 1-2 hours short to help you decide if you want to go for the full course on that particular subject. Uplatz overview courses are either free or minimally charged such as GBP 1 / USD 2 / EUR 2 / INR 100

Q10. What are individual courses?
A10. Individual courses are simply our video courses available on Uplatz website and app across more than 300 technologies. Each course varies in duration from 5 hours uptop 150 hours. Check all our courses here https://training.uplatz.com/online-it-courses.php?search=individual

Q11. What are bundle courses?
A11. Bundle courses offered by Uplatz are combo of 2 or more video courses. We have Bundle up the similar technologies together in Bundles so offer you better value in pricing and give you an enhaced learning experience. Check all Bundle courses here https://training.uplatz.com/online-it-courses.php?search=bundle

Q12. What are Career Path programs?
A12. Career Path programs are our comprehensive learning package of video course. These are combined in a way by keeping in mind the career you would like to aim after doing career path program. Career path programs ranges from 100 hours to 600 hours and covers wide variety of courses for you to become an expert on those technologies. Check all Career Path Programs here https://training.uplatz.com/online-it-courses.php?career_path_courses=done

Q13. What are Learning Path programs?
A13. Learning Path programs are dedicated courses designed by SAP professionals to start and enhance their career in an SAP domain. It covers from basic to advance level of all courses across each business function. These programs are available across SAP finance, SAP Logistics, SAP HR, SAP succcessfactors, SAP Technical, SAP Sales, SAP S/4HANA and many more Check all Learning path here https://training.uplatz.com/online-it-courses.php?learning_path_courses=done

Q14. What are Premium Career tracks?
A14. Premium Career tracks are programs consisting of video courses that lead to skills required by C-suite executives such as CEO, CTO, CFO, and so on. These programs will help you gain knowledge and acumen to become a senior management executive.

Q15. How unlimited subscription works?
A15. Uplatz offers 2 types of unlimited subscription, Monthly and Yearly. Our monthly subscription give you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews each month. Minimum committment is for 1 year, you can cancel anytime after 1 year of enrolment. Our yearly subscription gives you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews every year. Minimum committment is for 1 year, you can cancel the plan anytime after 1 year. Check our monthly and yearly subscription here https://training.uplatz.com/online-it-courses.php?search=subscription

Q16. Do you provide software access with video course?
A16. Software access can be purchased seperately at an additional cost. The cost varies from course to course but is generally in between GBP 20 to GBP 40 per month.

Q17. Does your course guarantee a job?
A17. Our course is designed to provide you with a solid foundation in the subject and equip you with valuable skills. While the course is a significant step toward your career goals, its important to note that the job market can vary, and some positions might require additional certifications or experience. Remember that the job landscape is constantly evolving. We encourage you to continue learning and stay updated on industry trends even after completing the course. Many successful professionals combine formal education with ongoing self-improvement to excel in their careers. We are here to support you in your journey!

Q18. Do you provide placement services?
A18. While our course is designed to provide you with a comprehensive understanding of the subject, we currently do not offer placement services as part of the course package. Our main focus is on delivering high-quality education and equipping you with essential skills in this field. However, we understand that finding job opportunities is a crucial aspect of your career journey. We recommend exploring various avenues to enhance your job search:
a) Career Counseling: Seek guidance from career counselors who can provide personalized advice and help you tailor your job search strategy.
b) Networking: Attend industry events, workshops, and conferences to build connections with professionals in your field. Networking can often lead to job referrals and valuable insights.
c) Online Professional Network: Leverage platforms like LinkedIn, a reputable online professional network, to explore job opportunities that resonate with your skills and interests.
d) Online Job Platforms: Investigate prominent online job platforms in your region and submit applications for suitable positions considering both your prior experience and the newly acquired knowledge. e.g in UK the major job platforms are Reed, Indeed, CV library, Total Jobs, Linkedin.
While we may not offer placement services, we are here to support you in other ways. If you have any questions about the industry, job search strategies, or interview preparation, please dont hesitate to reach out. Remember that taking an active role in your job search process can lead to valuable experiences and opportunities.