cancel
Showing results for 
Search instead for 
Did you mean: 

Generic Delta Extraction via Function Module

uwe_motschmann
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

uwe_motschmann
Explorer
0 Kudos

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