Your system has just migrated to HANA database and you are wondering what changes are required in ABAP programs after HANA migration. Standard ABAP programs do not require any adaption in order to run on SAP HANA. The performance guidelines which you have been using, will also remain same. But certain aspects of Custom ABAP programs need to be considered. Here we will consider few points related to HANA migration.
- Certain adaptions are required to ensure functional correctness of custom code after migration. You should use the SAP Code inspector (SCI) to detect ABAP code which requires analysis and adaption to HANA database.
- Special attention has to be given for usage of Native SQL(EXEC SQL). You need to check manually if native SQL statements are supported by HANA or if any change in code is required.
- When you migrate to HANA database, there is no need of secondary indices. Exclusion entries are created for existing secondary indices. You need to remove checks if any, in your custom programs for secondary indices, using FM DB_EXISTS_INDEX.
- During SAP HANA migration, Pool/Cluster tables are converted to transparent tables. If your custom program uses internal physical pools/clusters, adaption is required.
- SAP HANA is a column based database. If your ABAP code relies on implicit sorting(primary key or secondary index used by database optimizer), then that part of code requires adaption.
- After migration to HANA database, there is a change in priorities of certain performance guidelines. For performance related adaptions, you should use the ABAP Test Cockpit(ATC) and SWLT transactions.
Hope you have a smooth Migration to SAP HANA!!!
Reference: Best Practice Guide-Considerations for Custom ABAP Code during a Migration to SAP HANA by SAP