Skip to Content
0

HANA Code Remediation: Order By for database view

Feb 08, 2017 at 01:24 AM

64

avatar image

Hi Experts,

Current doing code remedaition as a part hana migration

In one of select single query the database view V_REEXKUNNRCN is used for fetching without all key fields. Hence this comes as an error in the code inspector as priority 2 for variant functional_db.

On analysing the view, the view is related to rental accounting. The view is a combination of 5 tables and all the 22 fields in the view are marked as key fields.

The select single query just uses only two key fields in the query. Did a random check and the two fields gives unique data in this case

In case of remediation how do i approach for view with all fields as key fields. What fields can be considered in "order by" to ensure data fetched is same as the old database

Regards Anand

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers