Fetching Data from HANA system

[Former Member]

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.

[Former Member]

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.

[amol_samte]

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