Skip to Content
0
Former Member
Oct 23, 2006 at 08:53 AM

generic extractor question

20 Views

Hi all!

I have a question about a genereric extractor I'm working on. I want to have the results of my following code (under * Fetch records into interface table.- available in e_t_data (append e_t_data). I have no idea how to do this, can somebody help me out?

      OPEN CURSOR WITH HOLD s_cursor FOR
      SELECT *

      FROM /bic/al_itm1c00
         WHERE /bic/l_loaddat IN r_udate.

    ENDIF.


*
*   Fetch records into interface table.
*

* Fetch records into interface table.

    IF c EQ space.        "all new entries
      FETCH NEXT CURSOR s_cursor
                 APPENDING CORRESPONDING FIELDS
                 OF TABLE i_itm1_c
                 PACKAGE SIZE s_s_if-maxsize.
      IF sy-subrc <> 0.
        CLOSE CURSOR s_cursor.
        c = 'X'.
      ENDIF.
    ENDIF.

    IF c EQ 'X'.
      IF   sy-tcode NE 'RSA3' OR sy-batch EQ 'X'  .
        zbw_load_date-mandt      = sy-mandt.
        zbw_load_date-datasource = 'ZBW_YLSRCCON_DS'.
        zbw_load_date-bwdate     = sy-datum.
        MODIFY zbw_load_date.
      ENDIF.

      RAISE no_more_data.
    ENDIF.