Use SAP Tools to Improve SAP ERP HCM Programs for the SAP HANA Environment

  • by Rehan Zaidi, Senior SAP Technical Consultant
  • December 4, 2017
See how to use the standard performance optimization tools to migrate SAP ERP HCM programs to the SAP HANA platform without any issues.
Learning Objectives

Reading this article you will learn about:

  • Database optimization tools
  • The new (enhanced) Code Inspector for SAP HANA
  • The SQL Monitor (transaction code SQLM)
  • The Performance Tuning Worklist (transaction code SWLT)
Key Concept

The SQL Monitor carries out the monitoring of database-related statements in programs executed within a system. The performance-tuning transaction code SWLT provides a combined view based on the static checks of Code Inspector and the dynamic execution results provided by the SQL Monitor.

When you are migrating to SAP HANA, certain tools can quickly tell you what programs need to be adapted to SAP HANA standards. In the second part of my series on SAP HANA, I cover the main tools provided in the newest releases and how to use them to identify spots in custom SAP ERP HCM programs that are potential candidates for improvement for the SAP HANA platform.

Included are the three most important tools for improving performance for SAP HANA: Code Inspector for SAP HANA, the SQL Monitor (transaction code SQLM), and the Performance Tuning Worklist (tran­­saction code SWLT). You see examples of problematic statements and how they are identified by these tools.

Rehan Zaidi

Rehan Zaidi is a consultant for several international SAP clients (both on-site and remotely) on a wide range of SAP technical and functional requirements, and also provides writing and documentation services for their SAP- and ABAP-related products. He started working with SAP in 1999 and writing about his experiences in 2001. Rehan has written several articles for both SAP Professional Journal and HR Expert, and also has a number of popular SAP- and ABAP-related books to his credit.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.