05-17-2016 8:42 AM
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.
05-18-2016 8:03 AM