Skip to Content
BW (SAP Business Warehouse)

ABAP and developing on BW on HANA


I am an ABAP developer. Can I still use my ABAP skills with HANA or do I need to use SQL/SQL Script?

ABAP runs in NetWeaver and NetWeaver runs on all big databases. HANA is another database that is added to the list of supported databases of the NetWeaver stack. In the future ABAP will remain a very important language as most SAP solutions are written in ABAP, independent of the underlying database.

However, in order to take full advantage of the in-memory capabilities of HANA in the future much more code will be written and executed directly in the database, e.g. as stored procedures. Those procedures can be called via ABAP statement from the application with the benefit that those procedures are directly executed in the database.

The HANA Modeler also has wizard-like visual modeling functionalities that don't require programming skills.

For some insightful discussion on this topic, please see this Videoblog of the non-SAP-employee members from the HANA Distinguished Engineer Council

and short transcript in SCN:

Do the ABAP user exits in my BW transformations, routines and programs still work after a BW on HANA migration?

Yes, all the SAP delivered and customized BW ABAP code including function modules are fully supported.

Please see link to SAP documentation for SAP HANA Database – SQLScript Guide

There is also a HowTo Guide about 'How to SELECT in SAP BW transformations'.

Are expensive ABAP transformations in BW data flows addressed by BW on HANA?

There are already several improvements, as our ramp-up customers have seen examples for ABAP routines being reduced from 7 minutes on traditional RDBMS to 6 seconds using BW on HANA.

Please see details for how to take advantage of BW on HANA improvements in SAP note 1662726.

Where can I get support if I want to develop on the HANA platform?

There is a HANA developer website. Please see attached link.

Where can I find further information about the synergies and future direction of ABAP and SAP HANA?

Top 10 FAQs about ABAP for SAP HANA

Transitioning Custom ABAP Code to SAP HANA - Best Practices and Recommendations

ABAP Code Pushdown through SAP HANA - SAP TechEd 2013

Please see the link to the Statement of Direction for ABAP for SAP HANA.

Please visit this SCN space ABAP for SAP HANA for details:

Important to mention here is also the tutorial "How to consume SAP HANA Procedures in ABAP" and the ABAP for SAP HANA Reference Scenario.

No comments