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.
2 Answers
-
Former MemberPosted on Oct 23, 2006 at 09:04 AMHI Joris,
with the code described by you, you have the results in the internal table "i_itm1_c", then you must add these records to the table e_t_data making transformation (if required).
Pay attention to:
the fetch is called per every data-package, so you have different time the adding data in i_itm1_c. Normally I prefer to refresh the internal table before to add new data (i_itm1_c and not e_t_data).
If you need an example I can give you an example code.
regards,
Sergio
Add a comment
Add a comment