SAP Certified Development Associate – SAP HANA 2.0 SPS05
In this blog, you will find some personal suggestions about how to get certified as SAP Certified Development Associate – SAP HANA 2.0 SPS05.
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.
Topics and Weight
Both the exam and the associated trainings for the C_HANADEV_17 certification for SAP HANA 2.0 SPS 05 are very similar to its predecessor C_HANADEV_16 for SAP HANA 2.0 SPS 04. What’s new and what’s changed?
There have been no changes to the topic areas and relative weights.
Minor changes were made to the HA450 course but this mostly concerns reshuffling of the content; six lessons from the appendix made their way back into the course again as Unit 2.
The same applies to the other source of input: HA300; some figures we updated, a bit of text added, some reshuffling, but overall the course is very similar.
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 HA450 training courses did not require a lot of changes.
For more information about the SPS 05 release, see
SAP HANA Cloud and SAP Business Application Studio
The SAP Certified Development 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).
When any of these terms are mentioned as answers, it is probably the wrong one!
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
- DEV = Development
- IMP = Implementation
- TEC = Technology
With HANAIMP, this certification shares the HA300 course, in particular the calculation view and SQLScript topic areas.
Earlier versions of the exam referenced previous SAP HANA releases.
- C_HANADEV_16 > SPS04
- C_HANADEV_15 > SPS03
- C_HANADEV_14 > SPS02
- C_HANADEV_13 > SPS01
- C_HANADEV_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.
Most material is sourced by the HA450 training, the modeling-related topics come from HA300, and the SQLScript topics from HA150 (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 HA450.
How to Prepare
When you have the time and budget, take the SAP Training courses. Nothing beats a 2 week+ focus with hands-on exercises and training environment.
- HA150 – SQLScript for SAP (SPS05) – 3 days
- HA300 – Modeling (SPS05) – 5 days
- HA450 – Application Development for SAP HANA (SPS05) – 4 days
Note that the courses have as prerequisite
- HA100 – SAP HANA – 360° Introduction – 3 days
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. You can logon and mark your progress.
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.|
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 learning journey shows a visualisation of the courses to take (as listed above). You can logon and mark your progress.
The latest update was for SPS 04 (2019).
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.
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. They cover all the core topics with references for additional study material, together with a glossary and hundreds of sample questions.
There is no success guide for the C_HANADEV exam but there is one for C_HANAIMP and C_HANATEC. The guide for the application associate exam covers many topics also found in the above-mentioned course although not all. The guide for the technology associate exam covers the material from HA100 but the main focus is on HA200, which is not part of C_HANADEV.
- SAP HANA 2.0 Certification Guide: Application Associate Exam | C_HANAIMP_15
- SAP HANA 2.0 Certification Guide: Technology Associate Exam | C_HANATEC_17
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 Development Center (Free)
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