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’ .
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.
Reason : These error occur due to implicit sorting on cluster table.
Solution : Add explicit sorting to the select query.
b. Message code SEL_POOL.
Reason : These error occur due to implicit sorting on Pool Table.
Solution: Add explicit sorting to the query.
c. Message code BIN_SEARCH
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.
d. Message code LOOP_AT.
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.
Nice capturing!! We have other tools available for remediation like Panaya, CMO and Solman CCM etc.