Skip to Content
Author's profile photo Rachit Gupta

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo AMIT Lal
      AMIT Lal

      Nice capturing!! We have other tools available for remediation like Panaya, CMO and Solman CCM etc.