Hi all SCN members,


In this blog I would like to mention the key points that I have jotted down in the technical session happened at SIT, Hyderabad on ABAP IN HANA by Sundaresan Krishnamurthy from SAPLABS. This 30 minutes was absolute enjoyment for all ABAPers, all credits to the presenter. It was again another useful session for all the attendees. Sundaresan was awarded with the winner award for his presentation on this session.

Introduction:


ABAP in HANA is upcoming and one hot topic in the SAP domain. Though HANA also playing a significant role in other fields of SAP its role in ABAP is immeasurable. In this blog I will be explaining in brief about the different aspects and role of HANA in ABAP.

Role of ABAP for development on HANA:


It basically deals with the following aspects,

  • SAP business Suite: it concentrates mainly on how customer can optimize and develop more applications.
  • SAP Net weaver BW: it concentrates on updation aspects.
  • New Application: concentrates on developing new applications.

Advantages of ABAP in HANA:


  1. Deeper and better integration with real time data access.
  2. New tools to detect optimization potential.
  3. Delightful user experience.
  4. New possibilities to build applications.
  5. Real time analysis.
  6. ABAP in eclipse (develop like never before).

ABAP code benefits from SAP HANA:


  1. SAP HANA platform is a complete relational database, hence no problem in using same code.
  2. Custom codes must be taken care during transition.
  3. Optimization potential will be high and transparent. That is fast data access and presence of optimized statements.
  4. In memory computing.
  5. Programming is near data base.
  6. HANA specific features are used.
  7. No message checks happen during transition.

CODE PUSHDOWN:


This is the main concept that explains the HANA functionality.

Usually in ABAP, data is transformed into code and then calculations happen alternatively in HANA the code is transformed into Data. This concept is called CODE PUSHDOWN.


Code pushdown need not necessarily be above example alone. A simple select query when transformed from SELECT SINGLE into SELECT FOR ALL ENTRIES also comes under CODE PUSHDOWN.


General Points:


  • In ABAP coding is sequential where as in HANA coding is parallel.
  • For getting started with HANA, ABAP 7.4 trial is used as virtual appliance.
  • During transition select query based on index will automatically get deleted, hence no index in picture.
  • As far as open SQL is concerned extended join support is provided.
  • Support for literals. For e.g. till now in ABAP select statements we have only fields which should be present either in structure or in table but with HANA even constants can be present in select statements.

SQL MONITOR- The tool of HANA:


  • This is an important tool that customer must be provided first incase he need to use HANA.
  • The T-Code used for SQL tool monitor is SQLM.
  • This tool is mainly used to analyze the code and check for its effectiveness.
  • There is another transaction used namely SWLT which mainly uses ABAP test cockpit to prioritize which line of code is used more.
  • In general it is similar to our ST05 with a difference that ST05 gives the trace for the entire code in the order in which it is executed but SQLM gives the trace on the basis of codes that are used more.
  • In short SQLM can serve as an input to ST05.

TAKEAWAYS:


  1. ABAP is and will continue to be basis for applications.
  2. ABAP 7.4 facilitates leveraging which is a SAP HANA feature.
  3. SAP HANA offer many new possibilities for ABAP based applications.
  4. HANA deals only with INSERT statements with database.
  5. Right time to get started with ABAP in HANA.

Conclusion:


The session actually gave me agood idea on what is HANA and what role does ABAP has on it. Thanks to the presenter such efforts with demo and explanations which made the subject more interesting.

Hope I shared all the content that was taught in the session, please feel free to correct for any mistakes. Question and answer session actually made the session more interesting.

Hats off to Sundaresan for this wonderful session.


Thanks for reading the blog 🙂 🙂   Hope you found it useful 🙂


Note: For more information about the happenings in SIT Hyderabad please read the below blog 🙂

http://scn.sap.com/community/events/inside-track/blog/2014/02/24/sit-hyderabad-an-overview-on-the-technical-track


LETS LEARN SHARE AND COLLABRATE 🙂 🙂 🙂

Thanks and Regards,

Satish kumar Balasubramanian

To report this post you need to login first.

8 Comments

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

  1. Sundaresan Krishnamurthy

    Dear Satish,

    Thanks for this blog and I am happy that you enjoyed this session. However I would like to clarify certain points that you have mentioed above .

    • Code push down implies the delegation of database intense operations to the HANA database to process(code to data) instead of loading all the data into the ABAP layer and then processing them by doing the calculation(data to code). Please refer to this nice blog on code push down capabilities of ABAP for HANA
    • In ABAP layer the program execution happens in a “sequential” manner with loop processing etc when you have to process large amounts data by looping through them and doing the calculations . When such calcautaions are pushed down to HANA, HANA detects and employs its parallel processing capabilities wherever applicable.
    • During migration to HANA the existing non-unique indices from ABAP are not created.Please refer to this document for additional details
    • SQL Monitor (SQLM)  gives you an overall perspective of a complete system by means of providing complete transparency of all the running SQL statements in a productive system.Please refer to this document on additional details about SQLM and how it is different from other tool like ST05 etc.

    Thanks again for your interest and wish you  all the best for your journey and exploration of “ABAP for HANA”

    Best Regards

    Sundar

    (0) 
    1. Satish Kumar Balasubramanian Post author

      Hi Sundar,

      Thank you so much for your comments 🙂 Thanks for the clarification too 🙂 as i have mentioned above your session was really awesome, thanks for the session once again 🙂

      Hope you enjoyed the blog 🙂

      thanks and Regards,

      Satish

      (0) 
  2. rucha jadhav

    Thanks For Document ,it really helpful to basic SAP ABAP HANA .Thanks For your sharing .. want to learn more in SAP ABAP HANA ,will you guide me

    (0) 

Leave a Reply