Consuming HANA views using ABAP

[Former Member]

Hi Experts,

We have ABAP reports in ECC which is taking very long time to process it. So we decided to push down the complex logic to HANA where ever it is taking long time to fetch data.

We have standalone HANA System. So can we use HANA as secondary database??? If yes, how can i consume HANA views in ABAP reports??

Can some one guide me.

Thanks in advance.

Best Regards,

Krishna.

[sreehari_vpillai]

Krishna,

All your data is available in yur primary database. If you are pushing down the complex logic to HANA database, you must provision the data into your secondary database first .

Sree

[Former Member]

Hi Sreehari,

Yes, we have replicated the required tables into HANA.

Now can i process complex logic here in HANA and pass the result set back to ABAP to process further logic??

Krishna

[sundaresan_k]

Dear Krishna,

You need to access the native HANA artefacts (like HANA information views) from your ABAP system using native SQL and ADBC in case HANA is not the primary DB.

Did you already check if there is any scope for optimization by improving your Open SQL calls in ABAP layer?

There are several improved code inspector checks(checks accessible from transactions SCI and ATC) that could offer hints on potential optimizations in the ABAP level using Open SQL.

Please refer to note 1912445.

Best regards

Sundar

[Former Member]

Hi Sundar,

Thanks a lot for your valuable inputs.

You need to access the native HANA artefacts (like HANA information views) from your ABAP system using native SQL and ADBC in case HANA is not the primary DB.

   - If i want to pass values to the views can we use HANA input parameters in this case as a PLACE HOLDER       in Native SQL??? else do i need to create a procedure for it???

Basically ABAP team is optimized the code but still we are hitting with performance. So we want to utilize existing HANA databse as secondary db to push down the complex logic to HANA.

Best Regards,

Krishna

[sundaresan_k]

Dear Krishna,

Yes. You can pass input parameters  using place holders.

Best regards

Sundar

[Former Member]

Hi Sundar,

Thank you.

Can you please provide some link where i can see how to consume HANA views into ABAP.

Best Regards,

Krishna.

[sundaresan_k]

Dear Krishna,

Please refer to the blog by Shahid Mohammed Syed .

Task T4 and T5 in the blog explains consuming HANA native views using Native SQL and ADBC.

Thanks

Sundar

[Former Member]

Hi Sundar,

Thanks a lot for your time and support.

Krishna