Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Not what you were looking for? View more on this topic or Ask a question