Generic extractor with delta capable is behaving like full update or Init

[Former Member]

Hi Experts,

I have one generic extractor (ZSFPC_EXP_ITEM) with function module, this extractor is working fine when i run full or initialization, but when i trigger delta update then extractor bringing all the records (i mean equal to initialization records), this extractor is not bringing the changed or created records since last init or delta update date.

we are using Generic delta field as CPUDT(Created on date) , type is Calday, Safety interval lower limit is '0' days.

In ROOSOURCE table delta is AIE (After-Images Via Extractor (FI-GL/AP/AR)).

Please let me know what could be the issue and how to resolve this issue.

Regards

Raja.

[Former Member · Accepted solution]

Hi,

I guess there is something wrong with your select statement and how you derive the imported last delta date.

regards

Siggi

[Former Member · Accepted solution]

Hi Siggi,

I did not write any code relating to delta.i just written below code for my generic delta field.

LOOP AT S_S_IF-T_SELECT INTO L_S_SELECT WHERE FIELDNM = 'KADKY'.

MOVE-CORRESPONDING L_S_SELECT TO L_R_KADKY.

APPEND L_R_TVERS.

ENDLOOP.

Please let me know if i missed anything .

Regards

Raja

[Former Member · Accepted solution]

Hi,

ok, but kadky is not the cpu date right? You need to capture the cpu date in the same way and post it to a range-table. Make sure your option is GE and sign is I or the other way round.

In your select statement you need to add the selection like this:

select ...... from.....

where....

and cpudt in <range tab for cpu date>...

In case of a full or init no value ist passed for cpu date to the fm. For deltas the last date - the lower limit is passed to the fm.

regards

Siggi

[Former Member · Accepted solution]

Hi Siggi,

Sorry , i have same code with CPUDT field.

Regards

Raja

[Former Member · Accepted solution]

Hi,

and also for the select statement?

regards

Siggi

PS: check my weblog, may be you get an idea.