Unable to retrive delta records when using FM based custom extractor from ECC to BODS

[Former Member]

Hi,

Scenario: we are trying to retrieve initial /delta records from ECC custom tables to BODS using FM based custom extractor.

• For initial load: Selected 'Yes' for BODS extractor initial load, and it should populate all records from the ECC table (custom table - ZOSKU_PA) to BODS
• For delta load:  Selected 'No' for BODS extractor initial load, and it should populate the delta records for any updated/changed records within 30 min.

We have a requirement to run the job for every 30 min interval without passing any timestamp.

Implemented approach :

Created a data source in RSO2 based on Function module proving

• Custom function module name (Copy of RSAX_BIW_GET_DATA_SIMPLE) , 
• Structure name (ZOSKU_STRUC),
• Delta field (ZBODS_UPDT) of timestamp.
• Lower interval as 300 sec

Mail custom logic in Function module

RANGES :
l_r_zbods_updt FOR zosku_struc-zbods_updt,
l_r_tab_updated_on FOR zosku_pa-updated_on.

LOOP AT
s_s_if-t_select INTO l_s_select WHERE fieldnm = 'ZBODS_UPDT'.
l_r_tab_updated_on-sign        = l_s_select-sign.
l_r_tab_updated_on-option    = l_s_select-option.
l_r_tab_updated_on-low        = l_s_select-low.
l_r_tab_updated_on-high       = l_s_select-high.
APPEND l_r_tab_updated_on.
ENDLOOP.

OPEN CURSOR WITH HOLD s_cursor FOR
SELECT cust_no    

               osku_material_number

               created_on
               updated_on
FROM zosku_pa

WHERE created_on IN l_r_tab_updated_on OR updated_on IN l_r_tab_updated_on .

Issue: Delta records are not populated

Also please note: we have passed the timestamp global variable in the extractor for option Extract from date time: $G_DATE sysdate(),but then also unable to get the delta records.

Seeks your valuable suggestions, helpful answers will be rewarded

[Former Member]

Hi saikumar,

did you find a solution.

I have a similar issue with CO-PA Datasources.

Cheers,

Deniz