topic Re: Read Hana table into ABAP program in Application Development and Automation Discussions

Read Hana table into ABAP program

former_member710665 — Wed, 03 Feb 2021 04:06:57 GMT

Hi Experts,

We having a HANA hdbtable in a different schema. I want to get the table data into an internal table of ABAP program.

We are using a latest ABAP and help me how we can achive this.

Re: Read Hana table into ABAP program

GK817 — Wed, 03 Feb 2021 06:42:37 GMT

Hi Praven,

You can use the AMDP to read data through CDS views and then you can put a select on CDS view to get it into an internal table.

For your reference - https://blogs.sap.com/2018/06/27/accessing-native-hana-tables-in-s4-abap-cds-views-analytics/

Gaurav

Re: Read Hana table into ABAP program

former_member710665 — Wed, 03 Feb 2021 07:45:52 GMT

Thank Gaurav. Is there a way to call the AMDP method directly into the program without using CDS (Like by chaging the method declatation)?

Re: Read Hana table into ABAP program

matt — Wed, 03 Feb 2021 08:23:27 GMT

You can use AMDP to create methods in a class that are callable from ABAP. The methods contain SQL Script. You do not have to use CDS views.

Simple example here (SAP Help) based on dealing with SFLIGHT directly from in HANA.

Re: Read Hana table into ABAP program

matt — Wed, 03 Feb 2021 08:23:50 GMT

AMDP is not restricted to reading data through CDS views. This is an unnecessary complication.

Re: Read Hana table into ABAP program

former_member710665 — Wed, 03 Feb 2021 08:31:37 GMT

Thanks Matthew, Can you help me know how to use SFLIGHT for calling the hdbtable.

Re: Read Hana table into ABAP program

GK817 — Wed, 03 Feb 2021 09:01:36 GMT

You are right Matthew

Re: Read Hana table into ABAP program

former_member710665 — Wed, 03 Feb 2021 10:11:04 GMT

Hi Matthew/Gaurav,

I can using only ABAP dictionary tables after USING statement. Can you help how I can select the data of hdbtable and pass as a return to to the AMDP class.

Re: Read Hana table into ABAP program

matt — Wed, 03 Feb 2021 13:11:20 GMT

I don't have time to check. Or a HANA database for that matter...

Two alternatives:

1. Call a HANA stored procedure from the amdp class.

2. CL_SQL_STATEMENT and associated classes/methods (also known as ADBC).See here https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abenadbc_query_abexa.htm This is far more flexible than an AMDP