02-08-2017 1:24 AM
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