Skip to Content
Feb 12, 2016 at 10:34 AM

Rewriting Native SQL to Open SQL in HANA DB Migration


1. Native SQL is connecting to other DB Servers(MDM/BW….) and fetching data from tables not in R/3. How to handle in HANA.

2. Views/table which are not present in R/3 but available in oracle DB. Would these be created automatically after migration or CDS views should be created manually ? To handle this, do we need to create local/dictionary structures/tables manually ?

3. Please explain the below native SQL code as SUM-ROOT in where is not populated anywhere in the code.Also how to rewrite for HANA DB.


Capture.JPG (22.9 kB)