Monday, 12 June 2017

Remediation for HANA Migration

Before migrating to HANA platform, the custom developments in SAP need to be remediated for HANA compatibility as explained in SAP Note 1912445.

Steps to be followed:

1. Identify the code where modifications are required.


 Execute SCI for custom developments with check variants as ‘FUNCTIONAL_DB’ and ‘FUNCTIONAL_DB_ADDITION’.



SAP HANA Tutorials and Materials, HANA Migration

Results of this execution will have different message codes whose handling is explained below.

2. Modification required for each message code.


a. Message code SEL_CUST.

SAP HANA Tutorials and Materials, HANA Migration

Reason :  These error occur due to implicit sorting on cluster table.

Solution : Add explicit sorting to the select query.

SAP HANA Tutorials and Materials, HANA Migration

b. Message code SEL_POOL.

SAP HANA Tutorials and Materials, HANA Migration

Reason : These error occur due to implicit sorting on Pool Table.

Solution: Add explicit sorting to the query.

SAP HANA Tutorials and Materials, HANA Migration

c. Message code BIN_SEARCH

SAP HANA Tutorials and Materials, HANA Migration

Reason : This error is due to reading unsorted internal table with binary search.

Solution : Sort internal table to be read with fields specified in binary search explicitly.


SAP HANA Tutorials and Materials, HANA Migration

 d. Message code LOOP_AT.

SAP HANA Tutorials and Materials, HANA Migration

Reason: This error is due to AT NEW/ENDAT operation on unsorted internal table.

Solution : Sort internal table on fields specified in AT NEW/ENDAT operation explicitly.

SAP HANA Tutorials and Materials, HANA Migration