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 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 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.



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_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.


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

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

  • DEV = Development

  • IMP = Implementation

  • TEC = Technology

Related Exams

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 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.

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.

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 HA450.

How to Prepare

SAP Training

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.

Note that the courses have as prerequisite

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. 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.


There are several courses about SAP HANA development available on the free openSAP platform including one dedicated to the exam preparation by thomas.jung and rich.heilman.

The latest update was for SPS 04 (2019).

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

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.

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 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? 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.