Rewriting Native SQL to Open SQL in HANA DB Migration

[jayvardhan_sharma]

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.

[jayvardhan_sharma]

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.

[Former Member]

Hi Jayvardhan,

We are also facing the same problem , specially point 3.

If your issue is resolved can you please share the solution you applied.

THanks

Poonam

[thomasgauweiler]

1. HANA is a database like any other database supported by ABAP. Therefore you can use Native SQL also with HANA.

The other questions I cannot answer.

Best Regards, Thomas