Fetching Data from HANA system

Former Member — Tue, 17 May 2016 07:42:28 GMT

Hi All ,

I am new to SAP HANA .

I have a select statement which fetches data from ECC. Now my requirement is to convert it so that data is now fetched from HANA system .

I am not sure how to convert the query.

OPEN CURSOR WITH HOLD s_cursor FOR

SELECT bukrs

belnr

gjahr

monat

cpudt

cputm

waers

bstat

FROM bkpf

WHERE bukrs IN l_r_bukrs

AND belnr IN l_r_belnr

AND gjahr IN l_r_gjahr

AND monat IN l_r_monat.

FETCH NEXT CURSOR s_cursor

APPENDING CORRESPONDING FIELDS

OF TABLE lt_bkpf

PACKAGE SIZE s_s_if-maxsize.

Re: Fetching Data from HANA system

amol_samte — Wed, 18 May 2016 07:03:01 GMT

Hi Meenu,

I am assuming you have to fetch data from HDB to application layer.

Here is below link which contains new enhanced open sql for faster performance on HDB.

-Amol