on 09-03-2008 7:43 AM
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.
Hi,
I guess there is something wrong with your select statement and how you derive the imported last delta date.
regards
Siggi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.