SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




CRM Companies List
Web Based CRM Software


How to Check SAP HANA Database Version


SAP HANA database administrator or ABAP programmers including SQLScript developers can check SAP HANA database version, major and minor builds with patch levels and revision numbers inluding build number. There are a number of ways to control HANA database version for your SAP system. In this tutorial, I tried to share a few of methods to see the HANA database version.


Check SAP HANA Database Version using SAP GUI

Launch SAP GUI and using top menu follow options: System > Status...
For SAP systems running on SAP HANA database, on Database data section, you will see HDB as Database System value.

The Release identifies the HANA database version in the form of major.minor.patch.build

SAP HANA database version


Control HANA Database Version using SAP HANA Studio

It is also possible to check the HANA database version for a SAP system using SAP HANA Studio for developers.

Launch SAP HANA Studio and switch to HANA Database Development perspective.
Using the Systems window connect to the target SAP HANA database.
Right click on the database to display context menu and choose option:
Configuration and Monitoring > Open Administration

HANA database version using SAP HANA Studio

On Overview tab which is displayed by default, programmers can see the Version information.

SAP HANA database version in HANA Studio

It is also possible to see details by clicking the Version link button. In this HANA Studio screen, developers can see the database versions installed or upgraded and their installation date and time information. The top record shows the current HANA database version and its installation time.

SAP HANA database version history


Get SAP HANA Database Version by Executing SQLScript

If SAP developer can execute SQL queries on the database, following SQLScript Select statement from M_DATABASE system view will return the HANA database version information.

select version from "SYS"."M_DATABASE";

SAP HANA database version using SQL query


Display HANA Database Version on Command Prompt

One last option given in this tutorial will be using the HANA OS command prompt.
Simply execute following command on HANA command prompt:
HDB version






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems