New ABAP for HANA features in SAP NW 7.4 SP08

[sundaresan_k]

With the newly released AS ABAP 7.4 SP8 we have further enhanced the features relevant for Code-Push-Down and DB-Near Programming. The focus has been further strengthen the ABAP Platform as the Sole-Master for all optimized development for HANA. Regarding all the new features introduced in the last release AS ABAP 7.4 SP5 take a look at this blog: New ABAP for HANA features in SAP NW 7.4 SP5

So what is inside this release for ABAP on HANA developers?

Advanced Open SQL

Open SQL is a DB abstraction layer in ABAP that defines a common semantic for all SAP supported databases.

Several limitations concerning the Open SQK in terms of support standard SQL features (SQL92) have been removed starting with ABAP 7.4 SP05 in such a way that Open SQL can be used with the new advanced features for access to SAP HANA and as well as other database platforms.

The key idea here is that the Code Push-Down for HANA can start with ABAP Open SQL with the advanced features of Open SQL.

With NW AS ABAP 7.4 SP8 there are several new features in addition to what was made available in NW AS ABAP 7.4 SP5.

Just name few of the features that have been introduced,

• New column specification data_source~* after SELECT statement
• Inline declarations for target range of SELECT statement
• New SQL expressions
• Consumption of parameterized CDS views

You could also use the Brand new Open SQL Console to play around with the new features of Open SQL.An overview about the new Open SQL features introduced in AS ABAP 7.4 SP8 by horst.keller for more details. Please check back on this ABAP for SAP HANA for detailed information of the new features and how-to use them.