extraction going endless in BW

[Former Member]

Hi ,

I have a generic data source with function module which works fine with RSA3 .

(i.e stops after correctly after getting 1000 records( the specified Data Records / Call = 100,Number of calls = 10 ).

But when scheduled from BW info package it's going on fetching endlessly with

so many data packages ...

Any ideas on how to solve this .

Thanks

[Former Member · Accepted solution]

This is the code in the function module,

FUNCTION ZZ_MSKA_TEST_EXTRACT.

*"----

---

""Global interface:

*" IMPORTING

*" REFERENCE(I_REQUNR) TYPE SRSC_S_IF_SIMPLE-REQUNR OPTIONAL

*" REFERENCE(I_DSOURCE) TYPE SRSC_S_IF_SIMPLE-DSOURCE OPTIONAL

*" REFERENCE(I_MAXSIZE) TYPE SRSC_S_IF_SIMPLE-MAXSIZE OPTIONAL

*" REFERENCE(I_INITFLAG) TYPE SRSC_S_IF_SIMPLE-INITFLAG OPTIONAL

*" REFERENCE(I_READ_ONLY) TYPE SRSC_S_IF_SIMPLE-READONLY OPTIONAL

*" TABLES

*" I_T_SELECT TYPE SRSC_S_IF_SIMPLE-T_SELECT OPTIONAL

*" I_T_FIELDS TYPE SRSC_S_IF_SIMPLE-T_FIELDS OPTIONAL

*" E_T_DATA STRUCTURE ZZMSKA_STRUCT OPTIONAL

*" EXCEPTIONS

*" NO_MORE_DATA

*"----

---

TABLES : MSKA.

DATA : IT_TAB_MSKA LIKE MSKA OCCURS 0 WITH HEADER LINE.

DATA W_MATNR LIKE MARA-MATNR.

BREAK-POINT.

SELECT * FROM MSKA INTO TABLE IT_TAB_MSKA WHERE WERKS = 'CN10'.

*--Stop processing when table is empty

IF IT_TAB_MSKA[] IS INITIAL.

RAISE no_more_data.

ENDIF.

*--Fill output table with i_maxsize entries

DO I_MAXSIZE TIMES.

READ TABLE IT_TAB_MSKA INDEX 1.

IF sy-subrc <> 0.

EXIT.

ENDIF.

DELETE IT_TAB_MSKA INDEX sy-tabix.

MOVE-CORRESPONDING IT_TAB_MSKA TO e_t_data.

APPEND e_t_data.

ENDDO.

ENDFUNCTION.

[Former Member · Accepted solution]

Hi,

with this code you'll never reach Raise no_more_data, only if MSKA is empty, therefor no end of the mod

did you use functmod RSAX_BIW_GET_DATA_SIMPLE as a skeleton ?

/manfred

[Former Member · Accepted solution]

Manfred,

Thanks for great help , works fine now.