Skip to Content
0
Former Member
May 17, 2016 at 07:42 AM

Fetching Data from HANA system

139 Views

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.