With the newly released AS ABAP 7.4 SP5 we have deepened the interplay between the ABAP and SAP HANA and enhanced the capabilities of the ABAP for HANA development. Following the code to data paradigm we have focused on enabling you to innovate faster and better with ABAP for HANA.For more information on code pushdown in ABAP on HANA take a look at this blog: ABAP for HANA and “Code Push-Down” .
So what is inside this release for ABAP on HANA developers?
Performance Worklist Tool
The SQL Performance Worklist (Transaction: SWLT) allows you to correlate SQL runtime data with ABAP code analysis to plan optimizations using results from the new SQLMonitor and CodeInspector.
More details on the Performance Worklist Tool can soon be found in a detailed document here in SCN (The SQL Performance Worklist Tool ).
CDS Viewbuilding is drastically improving the existing viewbuilding mechanisms in ABAP. It offers a broad variety of features you maybe know of the SQL92 Standard like all kind of join consitions, support of union, expressions, associations and much more. And also important we will continue to extended the feature set in the upcoming releases. CDS viewbuilding is completely syntax based and the design time with syntax checks, code completion and many more features is directly integrated in the ABAP Development Tools.
More details on CDS Viewbuilding can be found in a detailed document here in SCN ( New Data Modeling Features in SAP NW ABAP 7.4 SP5 ) and in our brand new YouTube Channel: ABAP for SAP HANA – YouTube.
Open SQL has been enhanced with new features, especially a lot of limitations have been removed, the JOIN functionality has been enhances as have been arithmetical and string expressions. Moreover, a new Open SQL syntax has been presented with incorporates e.g. the escaping of host variables, comma separation of the field list and so on and so forth.
ABAP managed Database Procedures (AMDP)
AMDPs enables you to create database procedures directly in ABAP using e.g. SQL Script and to seamlessly integrate it in modern ABAP development. An AMDP can be implemented using an ABAP method. Curious how this look like ? Here we go:
As you can see in the picture above the choice if the method is classical ABAP or SQL Script is in the method implementation and not in the definition. Making it possible to redefine an existing method implemented in ABAP with SQL script and the other way around.
The Lifecycle-Management of an AMDP is exactly the same as any other ABAP method. The ABAP server will take completely care for the deployment and activation of the procedure on the database.
More details for AMDP will follow soon and can be found in a detailed document here in SCN ( ABAP Managed Database Procedures – Introduction ) and in our brand new YouTube Channel: ABAP for SAP HANA – YouTube.
- Fast Data Access (new data exchange protocol)
- optimized SELECT… INTO ITAB and SELECT SINGLE
- optimized FOR ALL ENTRIES-clause
So that’s it – hope I made you excited. If you want to try it out, the new AS ABAP 7.4 SP5 Developer Edition will be available beginning of February – See here Developer & Trial Editions: SAP NetWeaver Application Server ABAP and SAP Business Warehouse powered by SAP HANA. Please check back on this ABAP for SAP HANA Space. We will continuously deliver detailed information of the new features and how-to use them.
Stay tuned & have fun with ABAP