Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert

SAP Certified Application Associate - SAP HANA 2.0 SPS05

In this blog, you will find some personal suggestions about how to get certified as SAP Certified Application Associate - SAP HANA 2.0 SPS 05.

This exam is available as of December 2020.

For the posts about the SAP HANA 2.0 SPS 05 exams, see

For the posts about SAP HANA Cloud exams, see

For the posts about the ABAP specialisation exam, see

For the posts about the SAP Business Technology (SAP Cloud Platform) exams, see

For the posts about SAP NetWeaver (SAP BASIS) exam, see

About braindumps and cheat sheets, see

Questions? Post as comment.

Useful? Give us a like and share on social media.


Latest update: April 2021 - added Blended Learning Academy

Interested to learn more? You are invited to join the LinkedIn Special Interest Group (SIG)

What's New

Topics and Weight

Both the exam and the associated trainings for the C_HANAIMP_17 certification for SAP HANA 2.0 SPS 05 are very similar to its predecessor C_HANAIMP_16 for SAP HANA 2.0 SPS 04. What's new and what's changed?

The topic areas and weight has been altered slightly

  • Two topic areas have been merged. The advanced analytics technologies SAP HANA spatial, graph, series data, text analysis, predictive, and hierarchy functions are now a single category reducing the weight of the HA301 course (see below).

  • SQL and SQLScript downgraded from 8%-12% to < 8% (from 6-10 question to < 6)

  • Optimizing the performance of models from 8%-12% to > 8% (from 6-10 question to > 10)


We already pointed out in a previous post that the focus for SAP HANA 2.0 SPS 05 was to provide a  rock-solid release for a five year maintenance window and not to introduce many new features (mainly targeted for SAP HANA Cloud) and we saw this reflected in the list of entries for the What’s New guide: 40 pages instead of 80 when compared to the previous two releases (even down to 21 pages when we leave out the SAP HANA cockpit administration tool).

As consequence, the HA300 and HA301 training courses did not require a lot of changes. Some figures we updated for HA300, some text added, and some sections reshuffled but overall the course is very similar. The HA301 course is identical (no changes).

For more information about the SPS 05 release, see

SAP HANA Cloud and SAP Business Application Studio

The SAP Certified Application Associate - SAP HANA 2.0 SPS05 only concerns SAP HANA platform on-premises and does not cover SAP HANA Cloud.

This also applies to the tool SAP introduced in 2020 for cloud-based application development: SAP Business Application Studio. The App Studio (or BAS) provides an extension for native SAP HANA database development.

For the exam, all questions reference the SAP Web IDE for SAP HANA.

SAP HANA Studio and SAP HANA XS Classic

SAP HANA studio as modeling tool was already removed from the exam and course material some editions ago. Not does the exam cover the SAP HANA XS Classic (XSC) model, the SAP HANA repository, questions about _SYS_REPO, or any related material (e.g. SAP HANA Live).

For an update and overview on the topic, see

About the Exam 

Associate Level

Information about the exam is published on the SAP Training website. This is also where you can book the exam (or get a Certification Hub subscription)

Certification levels

  • C = Associate (consultant)

  • E = Associate add-on (expert)

  • P = Professional

SAP HANA certification types

  • IMP = Implementation 

  • TEC = Technology

  • DEV = Development

Related Exams

With HANADEV, this certification shares the HA300 course, in particular the calculation view and SQLScript topic areas.

With HANATEC, this certification shares the HA100 course (see below), for the technology and deployment topic.

Earlier versions of the exam referenced previous SAP HANA releases.

  • C_HANAIMP_16 > SPS04

  • C_HANAIMP_15 > SPS03

  • C_HANAIMP_14 > SPS02

  • C_HANAIMP_13 > SPS01

  • C_HANAIMP_12 > SAP HANA 1.0 SPS12 (Edition 2016)


You can check the validity of the certifications at In general, the certifications are valid for two years.

For the certification FAQs, see

To take the exam visit SAP Training and select Access the Certification Hub.


Once you passed the exam, you will receive a digital badge from Acclaim

See the FAQ for more information about SAP Global Certification Digital badges.

About the Questions

Topics and Weight

Information about the topic areas covered is listed on the exam information page.

Compared to the previous edition, the list has been “simplified”.

Apart from the Advanced Analytical Processing topic, all topic areas reference course HA300 - SAP HANA 2.0 SPS05 Modeling. For advanced analytical processing, course HA301 is listed. For the technology and deployment scenarios, HA100 (see below).

Note the small print:

SAP reserves the right to update the exam content (topics, items, weighting) at any time.

Make sure to check the exam page when starting your preparation.

Topic Areas

Course Index

You can download the course index from the training page(s). This provides a more detailed list of the topics covered on the exam.

Below part of the course index for HA300.

How to Prepare

SAP Training

When you have the time and budget, take the SAP Training courses. Nothing beats a 3+3 day focus with hands-on exercises and training environment.

Note that these courses have as requirement

Not required but for those a little rusty on their SQL and SQLScript knowledge, consider course

As listed on the topic areas, most of the exam questions are sourced from the HA300 training. This is by far the most important material for study.

For those going for a certification upgrade, note that SAP HANA studio, SAP HANA Live, SAP HANA XS classic, and all related topics no longer feature on the exam.

SAP Blended Learning Academy

For this certification, SAP Training also proposes a guided modular training program that combines virtual live classroom learning units with instructors (SAP Live Class) with self-study learning via the SAP Learning Hub as well as access to the training systems (SAP Live Access) and ends in the SAP consultant certification (Certification in the Cloud). Complete duration is about 3 months.

SAP Learning Hub

Alternatively, consider a subscription for the SAP Learning Hub and/or Certification Hub.

For those new to the Learning Hub, you can try before you buy.

Sample Questions

On the exam page, there is a link to a sample exam similar to the real one from.

Learning Journey

The learning journey shows a visualisation of the courses to take (as listed above). You can logon and mark your progress.

The tiles for each of the courses show the available formats: classroom and e-books. When subscribed to the learning hub, you also have access to an SAP HANA system for hands-on exercises (Live Access). The assessment contains the sample questions from the course.

The tiles for each of the courses show the available formats: classroom and e-books.

Note that although recommended, the SAP Training courses are not a prerequisite to take the exam.


In the Expand your skills section of the Learning Journey several openSAP courses are listed for a deeep-dive into SAP HANA Spatial, SAP HANA Graph, and other topics. This will be beyond the scope of the exam.

For upcoming, running, and past courses about SAP HANA, you can filter the openSAP course catalog.

The most recent one was from 2020.

The remainder of the courses are getting a bit stale as they are from 2018 or older.


SAP Certification Success Guide by SAP PRESS

Whether you take the official training courses or not, the SAP PRESS Certification Success Guide(s) remain an excellent preparation for the exam. The book covers all the core topics with references for additional study material, together with a glossary and hundreds of sample questions.

The third edition of the success guide dates from 2019 and targeted the SPS 03 release. For SPS 04 and C_HANAIMP_16 an appendix is available as product supplement.

You can download an appendix from the Product supplements section with an update for the SPS 04 topics data masking and anonymization.

Additional Resources

Documentation - SAP Help Portal

The Development section of SAP HANA platform on the SAP Help Portal lists 20+ guides and this covers way more material than you need to know.

To help you find your way around, try the

SAP Community and SAP Developers

Of course, the tutorials from the SAP Development Center also provide a great learning opportunity. This is also the place to download the free SAP HANA, express edition or find out how you can run this in a cloud environment.

Note that the focus these days is on SAP HANA Cloud, which in some domains works slightly differently. For more information, visit

Share and Connect

Questions? Please post as comment.

Useful? Give us a like and share on social media.


If you would like to receive updates, connect with me on

For the author page of SAP PRESS, visit

Over the years, for the SAP HANA Academy, SAP’s Partner Innovation Lab, and à titre personnel, I have written a little over 300 posts here for the SAP Community. Some articles only reached a few readers. Others attracted quite a few more.For your reading pleasure and convenience, here is a curated list of posts which somehow managed to pass the 10k-view mile stone and, as sign of current interest, still tickle the counters each month.