What’s New in SAP HANA 2.0 SPS 05
This blog series complements SAP HANA 2.0, An Introduction published by SAP Press.
For the highlights post, see
For the hands-on blogs, see
For the previous posts on this topic, see
Any good? Post a comment, share on social media, and/or give a like. Thanks!
A Strong Foundation for Continued Innovation
Every new support package stack (SPS) release comes with its own theme. We have had Intelligence, Agility, Efficiency for SPS 04 last year, Business Data Platform for the Intelligent Enterprise for SPS 03 in 2018 and the Next Generation Platform for Digital Transformation for SPS 02 in 2017.
For this year it is a A Strong Foundation for Continued Innovation.
A foundation built on a decade of growth. 2020 and SPS 05 also marks SAP HANA’s 10th anniversary. [#SAPHANATurns10 | Facebook].
We already looked at the family album pictures in April:
Release and Maintenance
Predictability versus Innovation
The pace of innovations with SAP HANA has always been high. A bit too high for some customers.
In the spirit of bimodal IT as coined by Gartner, predictability versus innovation, we have witnessed the split between SAP HANA 1.0 and SAP HANA 2.0 with maintenance for the initial release extended to 5 years, now ending in 2021 (no worries, laggards, there is still time left (laggards is the official terminology from the technology adoption lifecycle, no offense).
In 2018, innovation also slowed down for SAP HANA 2.0 as it switched to an annual release cycle. High paced innovation would now come cloud-first and the same year a cloud edition was released: SAP Cloud Platform, SAP HANA Service. Technically, it was the SAP HANA cloud edition database YEAR.XX.XX containing SAP HANA 2.0.
On a side note, and for a bit of fine print, this service was added to two already existing SAP HANA database-as-a-service offerings. They all had one thing in common: VM-based (lift-and-shift). We covered this topic in At Your Service: SAP HANA in the Cloud.
Earlier this year, SAP HANA Cloud was released, replacing for new customers all previous offerings. SAP HANA Cloud is cloud-native, container-based, which translates to a separation of storage and compute (unlike VMs) with as a result elastic scaling. Technically, SAP HANA Cloud is still the cloud edition database but now it is version 4.0. The trial version will be available soon.
With SAP HANA Cloud carrying forwards the banner of innovation, SAP HANA 2.0 on-premises now takes over the role of predictability from SAP HANA 1.0 with five year maintenance extension. Note that unlike 1.0 SPS 12, 2.0 SPS 05 is not the last station. Work on SPS 06 has already started.
- Planned Release of SAP HANA 2.0 SPS05 and Impact on Maintenance for SAP HANA by Bare Said (February 2020)
Predictability typically is not obtained by adding zillion new features and we can see this reflected in the page count of the What’s New Guide: SPS 03 = 80; SPS 04 = 80; SPS 05 = 40. This is not to say there are no new features. Given how condensed new and changed features are described in the guide, one-liners typically, there is still a lot to discover.
Unlike before, we no longer have to choose between predictability and innovation. Hybrid replaces bimodel IT and with SAP HANA Cloud and SAP HANA on-premises you can have both.
For the What’s New release highlights, read the overview blog posts from SAP HANA product management (Vink) and the head of the database development organisation.
- What’s New in SAP HANA 2.0 SPS 05 by Brian Vink
- SAP HANA 2.0 SPS 05: A Strong Foundation for Continued Innovation by Bare Said
- Expedite Your Security Configuration with SAP HANA 2.0 SPS 05 by Melanie Handreck
For the full list, see the What’s New section on the SAP HANA documentation product home page which contains the links to more detailed information and is divided into the sections database enhancements, advanced analytics, application development, and data management.
As with the previous releases, there is also a series of webinars covered by the different product managers and highly recommended. The first one is starting today.
For an overview of this and previous releases, see the product home page on SAP.com.
What’s New – Release Documentation
SAP Help Portal (Documentation)
For more detailed information about what’s new and changed for the different domains, we can consult the documentation. There is a section for each of the guides: Installation and Update, Security, Planning and Design, Administration, etc.
The SAP HANA client has its own “home” on the Help Portal with a separate What’s New
This will also be the case for SAP HANA options, like smart data integration (SDI), dynamic tiering, streaming analytics, etc.
Although tightly integrated with SAP HANA, the SAP HANA cockpit is on its own release cycle and has a dedicated product section on the SAP Help Portal. Support Pack (SP) 12 for SAP HANA cockpit and database explorer was released earlier this month.
SAP Note (Support)
For the latest and more technical information about the software and the documentation, there are SAP Note(s) published on the SAP ONE Support Launchpad site. There is a release note for the platform and for each of the components (database, client, cockpit, etc.). A valid SAP support account (S-user) is required to access the SAP ONE Support Launchpad. For more information, visit support.sap.com.
- 2844322 – SAP HANA Platform 2.0 SPS 05 Release Note
- 2932865 – SAP HANA 2 SPS05 Revision 050.00
- 2835994 – SAP HANA Cockpit 2.0 SP 12
For information about what’s in the box, standard versus enterprise edition, options, etc., see
Besides notes and knowledge base articles, SAP ONE Support Launchpad is also the place to go for the downloads; both the full support package stack (SPS) as the latest revisions for each component (support packages and patches). Related info points to the release notes.
The shortcut URL of its predecessor, the Software Download Center or SWDC still provides a convenient way to access Software Downloads: support.sap.com/swdc.
Another easy way to directly access the software is through the SAP Software Download Center tab of the Product Availability Matrix (PAM). This also points to the release notes and the documentation. make sure to bookmark this resource.
Product Availability Matrix (PAM)
Complete Support Package Stack release (14 GB)
SAP Training and Certification
New courses and certifications for SAP HANA 2.0 SPS 05 will become available later this year.
For information about the previous version, visit
As you are reading the blog post on the community, you are probably already aware of this but in case you came to this page through search, there is also a dedicated topic are on the SAP Community listing all relevant content and the latest blogs and Q&A’s.
SAP HANA 2.0 – An Introduction
Just getting started with SAP HANA? Or do have a migration to SAP HANA 2.0 coming up? Need a quick update covering business benefits and technology overview. Understand the role of the system administrator, developer, data integrator, security officer, data scientist, data modeler, project manager, and other SAP HANA stakeholders? My latest book about SAP HANA 2.0 covers everything you need to know.
Get it from SAP Press or Amazon:
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
- LinkedIn > linkedin.com/in/dvankempen
- Twitter > @dvankempen
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.
Dear Denys van Kempen,
Thanks for sharing updates of SAP HANA 2.0 SPS 5.
Are there Netweaver requirements for SPS05, i.e. I have to install newer SAP_BASIS..., and/or kernel? Does HANA cockpit take care for that?
I can't find information.
For the OS dependency there is a good blog.
SAP HANA cockpit is an administration tool and cannot be used for installation (nor does it check dependencies and requirements).
NetWeaver requirements would be documented in the NetWeaver guides, e.g.
I am sorry,
I had to specify that I talk about Upgrade, not installation.
I.e. I have ERP on HANA 2.0 SPS 03, but I want to upgrade to HANA 2.0 SPS 05.
Do I have to Upgrade the ERP too?
I think I can use HANA cockpit for the upgrade, as shown - https://www.youtube.com/watch?v=eYNkeHBYONE&ab_channel=Reddysri
As a rule, yes. SPS 03 is from 2018, SPS 05 from 2020, i.e. lots of changes.
As with the other databases, you would have to check the ERP documentation (upgrade guide).
Good one about SP05
We upgrade it from 2.0.03 TO 2.0.05
The Updated Cursor new feature introduce in version 03 does not work in one our environment in 05.
We have NOT figure out what is difference. Although we check the SQLSCRIPT configuration setting nothing since to be out of the ordinary or different.
Can someone have experience this too?
Best to post this comment as a question(s) to the SAP Community forum.
The community is monitored 24/7 by the topic area experts both from SAP, its partners, and customers, which also allows for knowledge sharing.
Thanks for contributing!