Skip to Content

  TUNE YOUR CUSTOM ABAP CODE – HANAFIED

SAP ABAP on HANA

 

Prasana Ravichandran

prasana101990@gmail.com

                                                                       Table of Content

1.  STEP BY STEP TUNE YOUR CUSTOM ABAP CODE – HANAFIED

1.1 Introduction

1.2 Requirements

1.3    Step by Step Process

2. Steps  Involved


3. Conclusion

1. STEP BY STEP TUNE YOUR CUSTOM ABAP CODE – HANAFIED

1.1 Introduction

Before Migrating to Suite on HANA or ABAP on HANA environment we need to analyse which of my ABAP code must be changed to avoid potential functional issues. In general existing ABAP code runs on SAP HANA as before

Only if ABAP code relies on technical specifics of the old database, ABAP code changes might be necessary.

Technical changes with SAP HANA that may affect existing DB specific ABAP code.

/wp-content/uploads/2016/01/paste_863761.jpg

To avoid such confusions and technical redundancies follow the below mentioned step by step analysis to make custom development of ABAP code more optimized in HANA environment.

1.2 Requirements

To start with the optimization process the basic requirements are as follows

               1. ABAP Programming Knowledge

               2. SAP Development System with SCI/ATC checklist and SQLM transaction access

               3. Basics of SQLM and SWLT transaction processing.

               4. ABAP on HANA environment.

 

1.3 Step By Step Process

STEP BY STEP – TUNE YOUR CUSTOM ABAP CODE – HANAFIED.

We will see step by step how you get your custom code ready for SAP HANA and in parallel how this brings the performance and quality of your custom code on a new level right now. Also how this is facilitated through SCI results imposed on SQLM along with SWLT (SQL Performance Tuning Worklist).

Approach on Tuning ABAP code for optimization (HANAfication).

                               /wp-content/uploads/2016/01/paste_863761.jpg  

2.  STEPS:

Step 1: Go to Transaction SCI and perform an SCI inspection for the object list for which you want to perform analysis on optimization using a custom variant or PERFORMANCE_DB.

                          /wp-content/uploads/2016/01/paste_863761.jpg

Step2: Go to SQLM (SQL Monitor) Manage/Create Snapshots (Make sure Server is Active. Else select and activate all servers)

                             /wp-content/uploads/2016/01/paste_863761.jpg

Step3: Give some Description. Select Local System from data source tab and give the Package details Press F8/

Create Snapshot. You will get the success message as “Snapshot successfully created”.

                           /wp-content/uploads/2016/01/paste_863761.jpg

Step4: Go to SE38 . Execute the report program that you want to analyse with the required test data.

                            /wp-content/uploads/2016/01/paste_863761.jpg                           

The SQLM monitor will record and analyse the SQL profile of the executed program. (Time delay happens).

  Step5: Goto SE38execute the program ‘RSQLM_UPDATE_DATA and check all the options while executing to finish SQLM update manually.

                                 /wp-content/uploads/2016/01/paste_863761.jpg      

  Step6: We need to feed the SQLM snapshot to SWLT configuration (SQL Monitor tab). Goto SQLM Export the snapshot data from SQLM as zip file.

                                    /wp-content/uploads/2016/01/paste_863761.jpg

Step7: Now Goto SWLT transaction On General Tab Give package/Object details and select ‘Show all details’.

             

                                /wp-content/uploads/2016/01/paste_863761.jpg

On Static checks tab Give the SCI or ATC (ABAP Test Cockpit) inspection name (results obtained on Step1).

                                 /wp-content/uploads/2016/01/paste_863761.jpg

  On SQL Monitor tab Select the snapshot directly or Import the SQLM Snapshot file that we have exported in Step6.

                                   /wp-content/uploads/2016/01/paste_863761.jpg

Step 8: Now you are set to run/execute the SWLT Press F8 or Execute.

You will see a detailed report of SQL performance tuning work list highlighting the Total DB and DB mean time for all the tables hit in the descending order (most time consuming at the top) along with Error/warning messages and suggestions/ code remediation check messages.

                                       /wp-content/uploads/2016/01/paste_863761.jpg

3. Conclusion.

The below mentioned jargon  are some of the key takeaways for ABAP optimization on HANA.

           

                  /wp-content/uploads/2016/01/paste_863761.jpg

           As discussed above In general existing ABAP code will run on SAP HANA as ever before. There are certain DB specific ABAP code that must be analysed and modified accordingly. ATC (ABAP Test Cockpit) can be used to find and adapt those mentioned DB specific ABAP custom code easily. Those well-known golden Open SQL rules are still valid on SAP HANA, only some priorities have been shifted.

For effective SQL tuning and to find HANA potential in existing ABAP code new monitoring tools like the SQL

Monitor (SQLM) are available. With the above mentioned steps and approach, the preparation of your custom code can start before the migration to SAP HANA.

To report this post you need to login first.

3 Comments

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

  1. Sarves Peddibhotla

    Can someone please explain how the ABAP remediated code for HANA can be tested before the actual migration ?

    I know there are tools available, to speed up the ABAP code customization for HANA, like SCI, ABAP Test Cockpit, SQL Monitoring tool, Run-time check tool etc.

    So, my questions are:

    1. Is there any way to automate the ABAP code customization for HANA ? Does SAP provide any tool for automation ?

    2. How the ABAP remediated code for HANA can be tested before the actual migration ?

    Thanks

    Sarves

    (0) 
  2. Anji Reddy

    Yes, we have a tool called ‘HANEYA” that automates code remediation and make the custom code compatible with HANA and S/4. It will accelerate the deployment by 30-40% and reduces timeline and cost by 40%. More info at www. HANEYA.Global

     

    (0) 
  3. Anji Reddy

    Yes, we have a tool called ‘HANEYA” that automates code remediation and make the custom code compatible with HANA and S/4. It will accelerate the deployment by 30-40% and reduces timeline and cost with the same percentage. More info at http://www.HANEYA.Global

     

    (0) 

Leave a Reply