Skip to Content
Author's profile photo Carine Tchoutouo Djomo

ABAP for SAP HANA News for SAP NW 7.5

Latest News
December 2017:  Spotlight on ABAP for SAP HANA – Again 

 

SAP NetWeaver 7.5 is generally available to the public since October 20th, 2015 and what can be said is that ABAP (still) rocks!

Read this overview about the ABAP stack delivery: SAP NetWeaver AS for ABAP 7.5 – One ABAP Platform for SAP Business Suite and SAP S/4HANA, on-premise edition.

The current page will give you a compact overview about what’s new in the ABAP for SAP HANA world with AS ABAP 7.5.



ABAP Development for SAP HANA

The integration journey of ABAP and SAP HANA (for combining the best of both worlds) started in 2012 with the early enablement with AS ABAP 7.x for side-by-side scenarios, with SAP HANA as sidecar. The next and major milestone of this journey was reaching the full market readiness with AS ABAP 7.4, which is the first AS ABAP release heavily optimized for SAP HANA, thus allowing an easy leveraging of SAP HANA’s power in ABAP-based applications. It is the first go-to-release for ABAP for SAP HANA.

With AS ABAP 7.5, another major milestone has been reached by providing the foundation of the next SAP Enhancement Package for SAP Business Suite 7 and SAP S/4HANA, the next generation business suite, on-premise edition!

The graphic below shows the stepwise integration journey of ABAP and SAP HANA till today.

A4H_01_IntegrationJourney.png

SAP NetWeaver AS ABAP 7.5 is the new go-to-release for all ABAP for SAP HANA developments.

In fact, SAP HANA was one of the key drivers of the development activities in this release. The ABAP-managed code pushdown support has now reached the next level with the delivery of new powerful features in areas such as Open SQL, ABAP Core Data Services (CDS) and ABAP managed Database procedures (AMDP).

The graphic below provides an overview of the different code pushdown programming techniques delivered as of ABAP 7.4, and enhanced with ABAP 7.5.

A4H_02_ReleasedInnovations.png


ABAP Core Data Services (CDS)

One of the big development areas in ABAP 7.5 was to provide one harmonized data model for all consumers with ABAP CDS – The next generation data definition and access for database-centric applications.

Here is an overview of the new and enhanced capabilities:

  • New built-in SQL functions provided for conversion, string, date and time
  • New domain-specific annotations provided for areas such as OData, BW and Search
  • Associations defined in the basis view can now be used in CDS extensions
  • Definition and consumption of declarative authorizations based on PFCG data using CDS Data Control Language (DCL) roles
  • CDS Table Functionsfor allowing  the use of natively implemented database functions in SAP HANA directly from CDS (HANA breakout scenarios)

A4H_03_HarmonizedDataModel.png

  • CDS view with input parameters are now supported on all databases; meaning fallback no longer required.

ABAP managed Database Procedures (AMDP)

ABAP managed SAP HANA procedures offer the possibility to fully access SAP HANA’s power (i.e. high performance for complex computations and advanced native libraries and engines such as predictive analysis, Text mining and geospatial).

A4H_04_AMDPFunctions.png

With ABAP 7.5, the class-based AMDP framework has been enhanced and now supports ABAP managed database functions (AMDP Functions) for providing the implementation of CDS table functions.

An AMDP Function provides the possibility to developers to implement, manage and run an SQLScript-based HANA function with a tabular return value from the ABAP infrastructure.

 

In addition, the exception handling has been improved and a new, autonomous AMDP debuggerfully integrated in the ABAP infrastructure – for AMDP procedures is now provided within ABAP in Eclipse. This means, that when debugging an AMDP procedure, the creation of a debug script in SAP HANA is no longer needed.

Enhanced Open SQL

Starting with ABAP 7.4 SP02, Open SQL offers a broader coverage of the SQL Standard. To achieve this, a new syntax – with comma separated SELECT list and escaping of host variables with @ –  was required. But of course the old one is still supported as long as no new feature is used.

The enhancement of Open SQL is still ongoing and several new advanced features have been delivered with ABAP 7.5.

  • Support of new SQL functions, ABAP and SQL expressions
  • Enhanced syntax such as FROM before the field list for allowing code completion of field names
  • Dynamic ON condition
  • Support of UNION / UNION ALL
  • Support of sub-queries as data source of INSERT
  • Usage of CDS associations via path expressions
  • Access to global temporary tables used for storing intermediate results for subsequent database calls
  • Consumption of declarative authorizations (CDS roles)
A4H_05_EnhancedOpenSQL.png

SAP List Viewer with Integrated Data Access (aka ALV on HANA)

The reuse ALV component optimized for SAP HANA has been further enhanced in ABAP 7.5.

The major new capabilities are:

  • Support of the new built-in data type INT8 provided for supporting very large data set
  • Export of data into Excel (CSV format)  now supported

 

These features are delivered in addition to various other functions delivered since ABAP 7.4 SPS08, like

  • Unified consumption API for all databases (aka DB capability service)
  • Application-specific authority provider
  • Extended CDS support thru a dedicated factory method
  • Additional navigation possibilities
  • Access to ALV variants in toolbar
A4H_06_ALVwithIDA.png
  • Diverse usability improvements like cell merging of sorted columns and empty table text
  • SAP HANA-specific features like default sorting with locale and binary search electable.

ABAP Tools

ABAP Development Tools in Eclipse

ADT is the only development environment that fully supports ABAP for SAP HANA. ADT 2.51 offers together with AS ABAP 7.5 new cool features that further increase the developer efficiency. Just to name a few:

A4H_07_ABAPTools.png

Quality Assurance Tools

ABAP 7.5 keeps up with advanced and powerful test and analysis tools such as

  • ABAP Test Cockpit (ATC) / Code Inspector (SCI)
  • Runtime Check Monitor (SRTCM)
  • SQL Monitor (SQLM or SQL Monitor View in ADT)

These tools offer the basis for a smooth migration of ABAP custom code to SAP HANA (Details can be found in SAP Note 1912445 – SMP login required).

 

With ABAP 7.5 , the ABAP Test Cockpit offers additional functions for remote Code Vulnerability Analysis (CVA), i.e. for the execution of remote security checks in AS ABAP 7.0 and lower releases.



For those of you not yet familiar with the ABAP for SAP HANA programming, please check the available Get Started materials (Tutorials, Videos, …).

In order not to blow up the overview, topics like CDS roles, CDS table functions and AMDP functions will be covered separately in more detail (references will be added soon – Stay tuned!).
By following this document, you’ll be notified about the updates.

Back to the top

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Abdul Hakim
      Abdul Hakim

      ABAP Rocks!

      Author's profile photo Ben Patterson
      Ben Patterson

      Hello Carine,

      thanks for the valuable overview, some exciting things to work with!

      Do you know if there exists, or if there are plans to have, an ability to create Unit Tests for SQL procedures of top down (ABAP -> HANA) implementations (CDS/AMDB/Open SQL)?

      Similar to the functionality available in:

      Automated Tests with XSUnit in SAP HANA - SAP HANA Developer Guide for SAP HANA Studio - SAP Library

      Kind regards,

      Ben.

      Author's profile photo Thomas Fiedler
      Thomas Fiedler

      Hi Ben,

      yes, we are working on ABAP Unit mocking capabilities for database tables and views. First pilots were already succcessfully done here in the labs. Most likely we will ship these capabilitites with the next NetWeaver version.

       

      Regards,

      Thomas.