Two generic delta....Pls help

[Former Member]

Hi,

I have to extract data depending on two generic delta ..For two gen delta (ERDAT and AEDAT)I have declared 'ERDAT' as generic delta and in the fm I have inculded the logic for the other field 'AEDAT' too

For two generic delta I have written the following code in my function module for the data source...

LOOP AT S_S_IF-T_SELECT INTO L_S_SELECT.

CASE L_S_SELECT-FIELDNM.

WHEN 'ERDAT'. " delta relevant date

MOVE-CORRESPONDING L_S_SELECT TO L_R_DATUM.

CLEAR L_R_DATUM-HIGH.

L_R_DATUM-OPTION = 'GE'.

APPEND L_R_DATUM.

WHEN OTHERS.

ENDCASE.

ENDLOOP.

IF L_R_DATUM IS INITIAL.

L_R_DATUM-LOW = '19000101'.

ENDIF.

IF L_R_DATUM IS INITIAL.

L_R_DATUM-HIGH = '99991231'.

ENDIF.

and for selection:

OPEN CURSOR WITH HOLD S_CURSOR FOR

SELECT * FROM ZIMPTT

WHERE POINT IN L_R_POINT

AND MLANG IN L_R_MLANG

AND MPTYP IN L_R_MPTYP

AND ( ERDAT IN L_R_DATUM

OR AEDAT IN L_R_DATUM ).

ENDIF. "First data package ?

But the problem is that during delta load this function module is only working for 'ERDAT',which I have declared in generic delta field,but its not working for the other field 'AEDAT',though I have included the logic for two delta field..Pls suggest...

Thanks in advance...

[edwin_harpino]

hi,

if you are extracting from table/view, it's suggested to simply just create 2 datasource with different generic delta field, one with ERDAT and the other with AEDAT. then assign these 2 datasources to the same infosource in bw.

hope this helps.

[Former Member]

no,I am extracting data through function module...

[edwin_harpino]

hi,

i think you can create a new field to accomodate both ERDAT and AEDAT and use this new field for delta or

try to create one more datasource just same as previous but choose AEDAT as delta field and replicate to bw and assign to same infosource, create infopackage and run.

hope this helps.

[Former Member]

Can it be possible through one datasource???

can u pls tell me how I can accomodate both ERDAT and AEDAT to the new field,....Pls help.

[edwin_harpino]

hi,

check thread

hope this helps.