Hello all,

I would like to share my knowledge, which I gained from SIT (SAP Inside Track), 2014. Before getting started with a particular topic, I would like to share my experience on SIT, which was conducted in Hyderabad. It was a great pleasure for me to be a part of SIT. There were many valuable sessions throughout the day for 3 tracks (Technical, Functional and Analytical). As basically I am from technical side, the topics which they chosen are really excellent and presented in a very good manner.

Let me share you some of the points in ‘ABAP ON HANA’ which I learnt from the sessions, along with the points I collected apart from sessions, which I hope will be useful for you all to get the overview of this topic.

INTRODUCTION:

  • 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.

MIGRATION FROM ABAP TO HANA:

  • 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

NEW PARADIGM:

  • 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.

                                Code push down.PNG

    

DIFFERENCE BETWEEN ABAP AND HANA:

  • 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.

SQL MONITOR:

  • 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.

        

     Main Screen of SQLM:

     SQLM main screen.PNG

     Log History:

     SQLM history.PNG

  • 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.

CONCLUSION:

  • 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.

NOTE: All screenshots have been taken from net courtesy SAP.

Thanks & Regards,

Imran Khan.

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

    1. Imran Khan Post author

      Hi Mahesh,

      Thanks for your appreciation… 🙂 Will surely use courtesy for the screenshots..

      Regards,

      Imran.

      (0) 
  1. Sandeep Rajanala

    Hi Imran ,

             Good work. I have missed this session since i was there in analytics track. Now i got overall picture of this session. Thanks for sharing this.

    (0) 
    1. Imran Khan Post author

      Hi Sandeep,

      Thanks for your comments. 🙂 This blog was intended to give overall picture of ABAP on HANA and I am glad that you found this useful.. 🙂

      Regards,

      Imran.

      (0) 
  2. prem kumar

    Hi Imran,

    Nice useful blog. Do you also have an idea about HA300 course? I am basically an ABAP consultant with no other knowledge in other SAP modules. I was keen on doing HA 400 ( ABAP for HANA) but recently got to know that there is no certification available for the same yet. Also, many are suggesting me to take HA 300 ( Modelling) . Do you have an idea when HA400 would be available for certification or else can an abaper learn HA 300 even without BW knowledge.

    Waiting for your reply.Thanks.

    (0) 
    1. Balwant Singh

      Hi Prem,

      For your questions ” can an abaper learn HA 300 even without BW knowledge” the answer is yes. I have been an Abapper for last 9-10 years and did my modeling SAP certification last year. It was manageable to learn HANA modeling with little effort.

      (0) 
      1. prem kumar

        Thanks Balwant,

        Your reply gave me a lot of confidence. I will go ahead and pursue the course. I hope the job opportunities for Modelling is good as well. Thanks once again.

        (0) 

Leave a Reply