cancel
Showing results for 
Search instead for 
Did you mean: 

generic function module delta issue

Former Member
0 Kudos

Hi Everyone,

I have created a generic function module datasource (using "RSAX_BIW_GET_DATA" function module) and i have created delta on udate in rso2

And  i am able to extract data for full load  but i am not able to initialize datasource from bw side.Though i am not getting any errors  but the job is running for long time  so i have canceled in sm37.

do i have to make any settings from bw side or from ecc side please suggest.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Shambu,

Thanks for your response.here is the code  which i implemented in my custom function module

IF i_isource = 'ZG_FM_CSTMR'.

    IF i_initflag = space.

      REFRESH: it_knvp[], it_cust[], it_cdhdr[], it_c[].

      READ TABLE i_t_select WITH KEY fieldnm = 'KUNNR'.

      IF sy-subrc = 0.

        MOVE-CORRESPONDING i_t_select TO r_kunnr.

        APPEND r_kunnr.

      ENDIF.

      READ TABLE i_t_select WITH KEY fieldnm =  'TMSTMP'.

      IF sy-subrc = 0.

      tstamp = i_t_select-low.

       CONVERT TIME STAMP tstamp TIME ZONE sy-zonlo

       INTO DATE startdate TIME starttime.

      tstamp = i_t_select-high.

       CONVERT TIME STAMP tstamp TIME ZONE sy-zonlo

      INTO DATE enddate TIME endtime.

*       MOVE-CORRESPONDING i_t_select TO r_date.

*       APPEND r_date.

        r_date-sign   = 'I'.

        r_date-option = 'BT'.

       r_date-low    =  startdate.

        r_date-high   =  enddate.

       APPEND r_date.

     ELSE.

        READ TABLE i_t_select WITH KEY fieldnm = 'ZZUPDAT'.

        IF sy-subrc = 0.

          MOVE-CORRESPONDING i_t_select TO r_date.

          APPEND r_date.

        ELSE.

          r_date-sign   = 'I'.

          r_date-option = 'BT'.

          r_date-low    = sy-datum.

          r_date-high   = sy-datum.

          APPEND r_date.

        ENDIF.

      ENDIF.

*************************************************************************

*        IF i_datapakid = 0.

      OPEN CURSOR WITH HOLD c1 FOR

SELECT * FROM cdhdr

*            INTO TABLE it_cdhdr

            WHERE objectclas

                = 'DEBI'

              AND objectid

               IN r_kunnr

              AND udate

               IN r_date

              .

      IF i_datapakid = 0.

we are again modifying the data in e_t_data by reading from multiple tables. Can you please tell what is the field or how to identify INIT Vs DELTA vs FULL in the function module.

Please suggest me in which section i have to implement the code

Thanks ,

Kavya

Former Member
0 Kudos

It would be tough tom comment w/o looking at the code that you have implemented. There is a specific section in the FM where you need to code for delta. In bw side, you just need to replicate the datasource and then load the init with data.

Rgds..

Shambhu