What is the preferred way of data fetch from HANA view in ABAP Program

[nagaraosunkara]

Hello All,

I see the following options to fetch data from HANA view in ABAP program, would like to know, what is the preferred way:

1. Create an AMDP, and fetch data from HANA view inside AMDP, and use it in program,

2. Create an external view, and fetch data from the view,

3. Use native SQL.

Thanks & Regards,

Naga

[pbist]

External view would be the easiest option . I do not think creating native SQL is recommended rather use ADBC but why do over-engineering when external views are there.

[nagaraosunkara]

Is there any issue with Performance when we consider external views? Consider we have 10 million records, and we create a external view and use CDS over top of the external view created?