Online SAP resource to check the information on these tools for different versions:
ABAP Routine Analyzer
This tool enables you to analyze the performance of ABAP routines that are used in data flows. Here, you can see all the ABAP statements that should be optimized for performing on SAP HANA. To install the tool, download the attachment of the SAP note 1847431.
Create report ZBW_ABAP_ANALYZER in transaction SE38 and copy the source code you got from downloading the zip file from the SAP note. Save and activate the report. Execute it or press F8 to come to the initial screen of the tool.
You can see the options for analyzing-
- Process Chains
- Transfer and Update rules
You can also check Integrated Planning and APDs.
The tool identifies the points where ABAP performance can be made better for performing on SAP HANA database. For example, instead of using SELECT * statements for DSO look up in start routine, you can use internal tables or use the default routine type ‘READ FROM DATASTORE’.
BW Transformation Finder
This tool helps to search for transformations in SAP BW systems based on your search criteria. For example, you can search for all transformation in the system having a currency conversion or ‘read from master data’ type of routines.
You can also specify the traffic lights (green, yellow or red) based on your criteria to be shown against the search results.
You can download the attachment of SAP note 1908367 to install the tool in your system.
Create an ABAP report in SE38 and name it as ‘ZBW_TRANSFORM_FINDER’. Copy the source code from the SAP note. Save and activate it. Then click on ‘Execute’ to go to the initial screen of the tool.
For example, you can search for all the transformations that are omitted under SAP HANA. Here, you will get a list of infocubes that are based on DSO. As mentioned earlier in LSA++, you can get equivalent reporting speed of BEx queries based on DSOs.
Using this tool, you can find such infocubes indirectly via corresponding transformations. You can then decide whether to keep them unchanged or remove them from your SAP BW system.
Before deleting an Infoprovider, include corresponding DSOs in the multiprovider. Then transfer all the BEx queries from the cube to the DSO using transaction RSZC.
After successful migration of your SAP BW system to HANA, you can run this tool again with the checkbox ‘Check SAP HANA Processing‘ ticked. This will analyse the existing transformations whether they can be run on SAP HANA database.If the transformation is eligible, it will be run at significantly higher speeds (This is called Code Push-Down in Transformations). If your transformation is eligible, you can select the option ‘SAP HANA Execution‘ in the corresponding DTP.
BW Migration Cockpit
This combines various tools to make SAP BW migration to HANA more user friendly. Download the attachment of SAP note 1909597. Copy the source code available in the attached file to a new report. Name it as ‘ZBW_HANA_MIGRATION_COCKPIT’ in transaction SE38. Save and activate it. Click ‘Execute’ to go to the initial screen of the tool.
Most of the options are already there in the tools discussed earlier. This tool doesn’t have many unique features and hence will not be discussed in detail here.