topic Rewriting Native SQL to Open SQL in HANA DB Migration in Application Development and Automation Discussions

Rewriting Native SQL to Open SQL in HANA DB Migration

jayvardhan_sharma — Fri, 12 Feb 2016 10:34:57 GMT

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.

Re: Rewriting Native SQL to Open SQL in HANA DB Migration

Former Member — Mon, 04 Jul 2016 10:58:07 GMT

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

Re: Rewriting Native SQL to Open SQL in HANA DB Migration

thomasgauweiler — Mon, 04 Jul 2016 12:21:47 GMT

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