Skip to Content
author's profile photo Former Member
Former Member

extraction going endless in BW

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 08:49 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.