Is it a right choice to embrace ABAP on HANA ?
ABAP on HANA is a hot topic nowadays. A lot of general queries raised by ABAPers about converting ABAP based business logic to ABAP on HANA using CDS and AMDP.
Recently, when we took an existing ABAP report, the execution time is higher than applying pushing down core business logics to the database ( using CDS & Table functions).In Traditional ABAP to retrieve a huge volume of records normally we schedule those reports as a Background Job, but in ABAP on HANA we can get online data.
To overcome this performance issue, ABAPers can move to the HANA database. SAP HANA(High-performance Analytic Appliance)is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. SAP HANA uses four technologies to achieve the all-advantages without disadvantages combination:
- Columnar Storage
Beyond just storing and retrieving data, the SAP HANA can perform many complex operations on the data being retrieved itself. In fact, the optimized SAP HANA system can perform much faster than the calling ABAP program.
The Old Approach – Data to Code
Non-HANA ABAP limits the number of hits to the database by bringing all data initially and then performing operations on this data. Although retrieving large amounts of data from the database is time-consuming, it was superior to hitting the database multiple times. With this powerful back-end, it is necessary to revise the application layer to fully leverage the enriched capabilities of HANA.
HANA Approach– CODE TO DATA
The capabilities of HANA turned the data-to-code approach upside down. Instead of gathering chunks of data and operating with ABAP logic, HANA’s capabilities allow you to perform data-intensive operations in the database itself. An example of such an operation might be calculating the total sales value to a particular customer over the past 10 years.
In traditional ABAP, you would select all sales for that customer into an internal table and then loop through the records while adding the sales together to produce a sum. With HANA however, it makes more sense to push down the loop process to the database layer performing the summation and then returning only total sales value. Even if we are using AMDB instead of writing multiple select as multiple methods we need to use One SQL or optimized ways of SQL statements. The ultimate aim is to eliminate multiple Data Base hit.
ABAP goes Platform as a Service (PaaS)
ABAP in SAP Cloud Platform provides an additional option for the cloud transformation of SAP’s customer base. With ABAP in SAP Cloud Platform, ABAP developers can now make use of their existing ABAP know-how to develop and run ABAP applications in the Cloud.
FUTURE SCOPE OF SAP ABAP
SAP’s proprietary ABAP language for development is key to the ERP system. The entire code base of SAP ERP relies on ABAP as foundational. If a business needs to make changes to ERP-based business processes ABAP modifications are made to the core code to achieve those changes. For this purpose, SAP provides programming hooks called User Exits or enhancement spots to avoid the need for modifying the base code.
ABAP will last for as long as the SAP versions running ABAP continue to work and receive support – just like COBOL systems. Likewise, ABAP gets the odd new feature for every release and tries to catch up with the new paradigms of newer languages.
Not writing ABAP on HANA specific logic for HANA Database is a crime… So don’t be a Criminal
To know more about ABAP on HANA and how Kaar can help you, send us an email at firstname.lastname@example.org. We will get back to you within one business day.