Skip to Content

Generic Delta Extraction via Function Module

Hello,

i need a help for a generic delta extraction based on a Function Module. As an example i take the function module RSVD_BW_GET_DELTA_DATA.

My generic delta extractor based on the field AEDAT - Change Date and i will extract purchase service orders and entry sheets.

In the sample function module the select for the extraction worked with the table ROBWQTSTAT, but this table ist empty after the initialization.

OPEN CURSOR WITH HOLD G_CURSOR FOR

SELECT * FROM ROVERCUBE1

WHERE COUNTRY IN L_R_COUNTRY AND

REGION IN L_R_REGION AND

KUNNR IN L_R_KUNNR AND

TYPE IN L_R_TYPE AND

GJAHR IN L_R_GJAHR AND

  • Here the timerange calculated in form GET_TIME_INTERVAL is evaluated.

TSTMP IN S_R_TSTMP AND

OBJVERS = 'A'.

I found the table ROOSGENDLM. In this table i found the field DELTAID with the last date of the extraction and the field REPEATID with the date for the repead-Update.

My Questions:

Is this the right way to build an generic delta extraction with an function module or must i install a coding in my function module for an update of the table ROBWQTSTAT?

Which settings are needed in the table ROOSOURCE for a generic delta extraction via function module?

Best regards

Uwe

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 21, 2007 at 03:57 PM

    Hi Uwe,

    please have a look at https://weblogs.sdn.sap.com/pub/wlg/2415. [original link is broken] [original link is broken] [original link is broken] It might help

    kind regards

    Siggi

    PS: We already had almost the same question here today.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Siggi,

      thanks for your answer but it doesn't help me because I need to extract a generic DELTA. This for I used the Template RSVD_BW_GET_DELTA_DATA.

      My Problem now is, that we don´t get the Delta as I wrote above.

      Greetings from Uwe