Skip to Content
Technical Articles

SAP HANA Available, Used & Deprecated Features

In this blog post, I would be sharing a very basic information about SAP HANA features.

With every latest revision, we hustle sometimes in finding out whether a SAP HANA feature is newly introduced or deprecated from previous versions etc. This information is now easily available with SAP HANA monitoring views M_FEATURES and M_FEATURE_USAGE.

From Monitoring Views

These views are available for all Hana versions 1.0 and 2.0 as well.

SYS.M_FEATURES : Provides information about all supported features. Eg:

COMPONENT_NAME FEATURE_NAME FEATURE_VERSION
ABSTRACT SQL PLAN CAPTURE 4
ABSTRACT SQL PLAN PLAN GENERATION 3
BACKUP RECOVERY BACKUP SCHEDULER 5

SYS.M_FEATURE_USAGE : Provides detailed feature usage statistics. In this view, column name ‘IS_DEPRECATED’ if set to ‘TRUE’ it means feature is deprecated otherwise it’s available. Eg:

COMPONENT_NAME FEATURE_NAME IS_DEPRECATED OBJECT_COUNT CALL_COUNT LAST_TIMESTAMP LAST_CONNECTION_ID LAST_USER_NAME LAST_APPLICATION_USER_NAME LAST_APPLICATION_NAME LAST_APPLICATION_SOURCE LAST_STATEMENT_ID LAST_STATEMENT_HASH
SQL CREATE WITH PARAMETERS TREX_FLAGS FALSE ? 0 ? ? ? ? ? ? ? ?
HIERARCHY GENERATOR FUNCTION FALSE ? 0 ? ? ? ? ? ? ? ?
HIGH AVAILABILITY HOST AUTO FAILOVER TRUE 25 13914 15:11.0 -1

From SQL statements

You can use the following SQL statements available via SAP Note 1969700 to display this information:

SQL statement Details
SQL: “HANA_Features” Overview of SAP HANA features available in the system, including their version
SQL: “HANA_Features_Usage” Overview of SAP HANA features available in the system, including their usage and deprecation state

Deprecated Features with HANA 2.0

There exists a nice SAP Note 2425002 which provides further details for features being deprecated with SAP HANA 2.0.

Earliest removal of a deprecated feature will be one SPS after deprecation start. The table below lists the specific information, migration steps to follow, and so on.

Description M_FEATURE_USAGE.
COMPONENT_NAME
M_FEATURE_USAGE.
FEATURE_NAME
Public Migration
Guide
Deprecated with SPS Decommissioned with SPS
In memory optimized (IMO) DSO is a special BW object that was introduced when BW was released for HANA. Meanwhile standard DSOs are also optimized for HANA and there is no need for IMO DSOs any more. DSO IMO yes SAP Note 1849497 1849498 HANA 2 SPS 01 HANA 2 SPS 04
Procedure to migrate data from an existing standard DSO to an IMO DSO DSO IMO CONVERSION yes SAP Note 1849497 HANA 2 SPS 01 HANA 2 SPS 04
Removal of empty system view SYS.M_TENANTS SYSTEMVIEW M_TENANTS yes SAP Note 2424899 HANA 2 SPS 01 HANA 2 SPS 04
Removal of support for legacy Text Mining implementation, including support for HIGHLIGHTED option on TM_ SQL functions TEXT LEGACY TEXT MINING yes SAP Note 2435642 HANA 2 SPS 01
Removal of ALTER VIEW … ADD CACHE RETENTION 0 STATIC RESULT CACHE RETENTION 0 yes SAP Note 2487744 HANA 2 SPS 02 HANA 2 SPS 03
Removal of OpenSSL support in the SAP HANA database kernel SECURITY OPENSSL yes SAP Note 2093286 HANA 2 SPS 02 HANA 2 SPS 04
Removal of the Repository component in favor of the Deployment Infrastructure (HDI) REPOSITORY API yes SAP Note 2465027 HANA 2 SPS 03
Removal of DDL extension for creation of column views of type calculation along with the underlying calculation scenario in a single statement. CALCENGINE EXPOSE NODE yes SAP Note 2556245 HANA 2 SPS 03
Removal of system view SYS.COLUMNS SYSTEMVIEW COLUMNS yes SAP Note 2713947 HANA 2 SPS 04
Remove fallback for SAP timezone dataset TIMEZONE SAP_DATASET_FALLBACK yes SAP Note 2744153 HANA 2 SPS 04
XS Classic: several features XSC REQUEST: *
JOB: *
yes SAP Note 2465027 (exists since HANA 2 SP00) HANA 2 SPS 03
Hadoop controller SDA ADAPTER HADOOP yes SAP Note 2806496 HANA 2 SPS 04 HANA 2 SPS 05
System procedure CHECK_PLATFORM SYSTEMPROCEDURE CHECK_PLATFORM yes SAP Note 2816929 HANA 2 SPS 05

If you have any further questions, please contact SAP Support.

Thanks & Regards,
Vivek Sahu

1 Comment
You must be Logged on to comment or reply to a post.