If you have migrated your BW system recently to HANA database, you might need to optimize your ABAP code you were using in the transformations earlier to make them HANA optimized.
Note that even though you might have followed best practices for ABAP while writing the codes, those may not work in HANA database and still you need to optimize your routines.
SAP has provide a tool to check the custom code and propose changes. Install the SAP note 1847431 form the SAP Service Marketplace.
Go to tcode SE38 and enter the program name as ‘ZBW_ABAP_ANALYZER’. Execute the program.
ABAP routine Analyzer screen appears. Click on the rightmost icon to display all the available tabs. In the default tab ‘Checks’, deselect the ‘Check Process Chains’ checkbox.
Now select the checkbox ‘Check Transformations’. Give the transformation ID and execute.
System suggests green, red, yellow or gray icon with messages. Drill down and double click on the messages to see the details on the right side.
Green message suggests that the routine is fine and no further action is required.
Red message indicates critical findings for adjusting the ABAP code.
Yellow message indicates warnings and it is optional to follow them.
Grey messages are just for information.
By following the red and yellow findings in the ABAP runtime analyzer tool, you can change your ABAP routines to make them HANA optimized.