SQL and System View Reference Guide – HANA 2.0 SPS 03
Welcome to the HANA 2.0 SPS 03 SQL Ref Guide
Handy Links for You
Remember, you can switch between different versions of HANA documentation once you are in the SAP Help Portal by fiddling with the Version dropdown located in the top right corner of the window.
Official SQL reference guide: HANA 2.0 SPS 03 – SAP HANA SQL and System View Reference
Other helpful links for the release:
- Bettina Schaeumer‘s blog on What’s New in SAP HANA 2.0 SPS 03 (at a higher level)
- Official documentation on What’s New in SAP HANA 2.0 SPS 03 (in a bit more detail)
- SQL grammar-specific: What’s New in the SQL Grammar
- SAP HANA Platform product page
- HANA 2.0 SPS 03 Feature Scope Description <– kinda new!
- SAP HANA Platform 2.0 SPS 03 Release Note 2551355
- HANA 2.0 SPS 03 – SAP HANA SQLScript Reference
- What’s New in SAP HANA 2.0 SPS 03 – by the SAP HANA Academy by Denys van Kempen
- Cool videos to watch on HANA Academy’s YouTube channel
- What’s new in Product Documentation and User Assistance for SAP HANA 2.0 SPS03 by Eva Arnaszus
- What’s new in the SAP HANA 2.0 SPS 03 – Security Documentation by Sinead Higgins
Improvements To Enjoy
Leaving feedback on topics
Previously, to leave feedback, you clicked the thumbs-up sign. But likely a few of you didn’t, afraid that by clicking that icon you might leave the impression you liked the topic. Help Portal now solicits your feedback using a Was this topic helpful? area in the right pane. Depending the reply you pick, you get lots of options to customize your feedback.
And while I’m at it, the more specific you can be in your feedback, the more likely you are to influence the improvements we make. Comments with specifics are far more helpful than generalized ones. Unfortunately, the box to put the feedback in is wee (sorry). But that is just a display limitation. If you have a lot to say, draft your comment in a text editor where you can see it all at once and then paste the final version into the wee field when done.
Download the PDF for any guide
If you’re in the dream guide you love and want to take it with you everywhere you go, you can now use the handy Download PDF widget in the top right of the Help Portal window.
Search result lists now show content snippets – one for each search result item. Also, the terms you are searching for are now highlighted in the results.
New “Permissions” section in statement topics
We got feedback that it would be handy(er) if we teased out any privilege and device permission information into its own section, and that made sense so we’ve done it. Some statements may still not have the section though; it depended on whether there was something meaningful to put in it.
Hierarchy functions topics
If you are a consumer of the hierarchy function topics, you’ve probably already noticed that they are documented twice – once in the SAP HANA SQL Reference Guide, and again in the Hierarchy Guide, AND that they were not identical either. To reduce confusion, hierarchy users can now find all hierarchy-related documentation together in the SAP HANA Hierarchy Guide; the hierarchy function topics in the SQL Ref guide are now gone.
Other stylish things you might notice:
No more “option” distinction – Since licensing and install information for HANA and its various options and capabilities is now captured in a single, handy location called the Feature Scope Description Guide, and since licensing models can change over time, the SQL Reference guide has moved away from using the term “option” when referring to an SAP HANA Option. Even the Table of Contents reflects this change!
So if you previously searched for things like “DT option” or “dynamic tiering option”, just leave off the word option and you’ll still find what you’re looking for.
Have you explored the Feature Scope Description Guide?
Coz it’s kinda cool… The Feature Scope Description for SAP HANA is always found on the SAP HANA Plaform page, and is the new home for myriad details about editions, licenses, and most importantly, what capabilities you have based on what you’ve licensed and installed. It’s a great way to learn about capabilities you don’t have too (and might want). You can even use the new Download PDF button to enjoy it offline by the fire with a coffee.