Skip to Content

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’ .

     SCI.jpg

          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.


          /wp-content/uploads/2016/06/sel_cust_967903.jpg

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

         Solution : Add explicit sorting to the select query.

                       

                          /wp-content/uploads/2016/06/sel_custprg_967916.jpg

     b. Message code SEL_POOL.

          /wp-content/uploads/2016/06/sel_pool_967917.jpg

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

               Solution: Add explicit sorting to the query.

                               /wp-content/uploads/2016/06/pool_967918.jpg

     c. Message code BIN_SEARCH


          /wp-content/uploads/2016/06/bin_967919.jpg


               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.


                                /wp-content/uploads/2016/06/bins_967920.jpg


     d. Message code LOOP_AT.


          /wp-content/uploads/2016/06/loop_967921.jpg


             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.


                              /wp-content/uploads/2016/06/loopat_967925.jpg

1 Comment
You must be Logged on to comment or reply to a post.