Skip to Content

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

To report this post you need to login first.

1 Comment

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

Leave a Reply