Leverage SAP HANA on the SAP NetWeaver Application Server for ABAP

  • by Akash Kumar, Technical Consultant, SAP Labs
  • December 1, 2014
Akash Kumar reviews the tools and techniques that allow you to maximize the use of SAP NetWeaver Application Server for ABAP powered by SAP HANA.
Learning Objectives

By reading the article you will learn:   

  • How to detect improvement areas in existing ABAP code
  • How to optimize existing ABAP code
  • How to apply the bottom-up approach
  • How to create a secondary database connection in SQL
  • The new feature in native SQL for SAP HANA
  • How to apply ABAP database connectivity
Key Concept
ABAP code performs data-intensive operations at the application layer and stores data in rows for aggregation functions, which can slow processing. ABAP on SAP HANA offers the opportunity to develop new, faster processing and innovative business applications, and optimize existing ABAP applications for faster decision making or services.

SAP HANA allows you to store data in row and column formats, which results in tremendous performance for the SAP NetWeaver Application Server for ABAP. Tables used for aggregation functions such as sum can be stored in a column format in SAP HANA, which until now was not possible in a classic database.

The column store option provides advantages such as data partitioning in which column data is split up for parallel processing by multiple CPU cores. Both data partitioning and parallel processing increase execution speed.

Generally ABAP programmers fetch a lot of data from database tables and store it in internal tables for further business processing. Once the processing is complete the data is written back to database tables. This increases data transfers between the layers and hence reduces performance.

SAP HANA allows you to push data-intensive logic to the database layer, which in ABAP is handled in the application layer (Figure 1). This helps to reduce the amount of data transferred between the layers.


Akash Kumar

Akash Kumar is an SAP technical consultant specializing in ABAP and HANA. He has 5+ years of experience in design and development of products with corporate organizations such as TCS, RBS, and SAP Labs. He is an active speaker and has organized multiple BarCamps in Delhi, India. He holds a bachelor of technology degree in computer science. He holds a certification in SAP HANA.


See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.