Get 15% Discount on every Course. Use Coupon Code : SUREPASS


Video Category > SAP ABAP on HANA

                                                               Overview of this topic

Total 21 videos


  • The main theme of this topic is: ‘Accelerate, Extend, Innovate using as ABAP and SAP HANA’.
  • This topic shows how, capabilities of ABAP have been enhanced for HANA development.
  • All ABAP applications have been optimized for SAP HANA:
    • Deeper and better integration with accelerate and real time data access.
    • New tools to optimization potential.
    • Delightful user experience and easy access.
    • New possibilities to build applications.
    • Real-time analysis with embedded analysis.
    • Develop like never before using ABAP in Eclipse.


  • ABAP code only using database independent features continue to run after migration to HANA.
  • General performance guidelines stay valid for SAP HANA.
  • Custom code transition:
    • Avoid (Functional) regression.
    • Detect (Additional) performance optimization potential.
  • Required and recommended adaptions:
    • Database migration related
    • Functional related
    • Performance related


  • Code pushdown means delegating data intense calculations to the database layer. It does not mean push ALL calculations to the database, but only those that make sense.
  • Example: If you want to calculate the amount of all positions of invoices. You should not select all positions of those invoices and calculate the sum in a loop. This can be easily done by using an aggregation function ( SUM() ) on the database.                           


  • One basic difference between ABAP and HANA is, ABAP is based on sequential execution while HANA is based on parallel execution.
  • Widely used Insert statement in ABAP is replaced with Delta Merging in HANA.


  • Transaction code: SQLM.
  • It displays performance data on process level.
  • It allows drill down from process level to single database operation
  • Can run in production with minimal overhead (Less than 3%).
  • The monitoring cycle consists of 4 phases:
    • Activation – Activate the monitoring.
    • Monitoring – Check & ensure the monitoring status.
    • Deactivation – Deactivate the monitoring.
    • Reset – Archive the collected data and reset the monitoring.
  • Below are some screenshots of SQL monitor.
    • It consists of following buttons:
      • All Servers: To select all servers for monitoring.
      • Select Servers: To select some particular servers for monitoring.
      • Activate/Deactivate: To Activate/Deactivate the monitoring.         

     Log History shows all the SQL statements running under the server along with following details:

    • Number of times the statement runs.
    • Duration of each statement.
    • Program in which the SQL statement is executing.
    • Data and Time of execution, etc.


  • ABAP is and will continue to be basis for applications.
  • ABAP 7.4 facilities leveraging SAP HANA features.
  • SAP HANA offers many new possibilities for ABAP based applications.

$ 49

₹ 4116

Packages Features

  • 4 Months Unlimited Access to Online Videos.
  • Outline the advantages of learning IT skills through online videos, such as flexibility, convenience, and the ability to learn at your own pace.
  • Detail the range of topics covered in your IT video library.
  • Provide an overview of the importance of IT training in today's digital landscape.
  • Price is just $49 USD, lowest compared to other online or offline materials.
  • Safe & Secure Payment with Credit Card,Debit Card,UPI,PayU,RazorPay,Stripe and PayPal.
  • We invite you to visit our Live User Testimonials and Blogs.
  • We donate 10% of the profit to charity.