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 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
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)
SAP HANA 2.0 SPS 05
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
- A Field Guide to SAP (HANA) Development | How to Get Started or Keep on Going without Getting Lost
- SAP HANA 2.0 and 1.0 – What’s the difference?
About the Exam
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)
- C = Associate (consultant)
- E = Associate add-on (expert)
- P = Professional
SAP HANA certification types
- IMP = Implementation
- TEC = Technology
- DEV = Development
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 training.sap.com/certification/validity. In general, the certifications are valid for two years.
For the certification FAQs, see
- SAP Global Certification FAQ – Overview
- SAP Global Certification FAQ – Exam Process
- SAP Global Certification FAQ – Post-Exam Process
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.
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
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
- HA100 – SAP HANA – 360° Introduction – 3 days
Not required but for those a little rusty on their SQL and SQLScript knowledge, consider course
- HA150 – SQLScript for SAP HANA – 3 days
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.
- WHAIMP – SAP HANA Modeling – SAP Blended Learning Academy
- SAP HANA Blended Learning Academy (Certification: C_HANAIMP)
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.
On the exam page, there is a link to a sample exam similar to the real one from.
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.
- SAP HANA (filter)
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.
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 HANA Development Metro Map
- SAP HANA Development Information Atlas
- SAP HANA Developer Quick Start Guide
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? Post as comment.
Useful? Give us a like and share on social media. Thanks!
If you would like to receive updates, connect with me on
For the author page of SAP Press, visit