Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Code Remediation: Order By for database view

former_member192842
Participant
0 Kudos

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

0 REPLIES 0