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
Very good blog w.r.t HANA 2.0