Skip to Content
avatar image
Former Member

HANA Code Remediation: Order By for database view

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers