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.
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
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.
Would you like to see this full item?