seletion parameters in the infopackage are not working for delta load

[Former Member]

we have created a custom extractor based on function module, we are filtering based on field 'PROCESS' in the infopackage selction. In the function module we are extracting the records in the select query based on the selections passed for the field 'PROCESS'.

In RSA3 the section parameters are working fine but while running the infopackage.The slection paraameters are working for init load where as they are not working for a delta load.

please see the code below.

CASE s_updmode.

WHEN 'I'.

IF i_contract[] IS NOT INITIAL.

OPEN CURSOR WITH HOLD s_cursor FOR

SELECT * FROM zv_intacc_sum_bw

FOR ALL ENTRIES IN i_contract

WHERE contract_int = i_contract-contract_int

AND settlement_type IN lv_rng_settlement_type

AND process IN l_r_process.

ENDIF.

WHEN 'D'.

IF i_contract[] IS NOT INITIAL.

OPEN CURSOR WITH HOLD s_cursor FOR

SELECT * FROM zv_intacc_sum_bw

FOR ALL ENTRIES IN i_contract

WHERE contract_int = i_contract-contract_int

AND settlement_type IN lv_rng_settlement_type

AND process IN l_r_process

AND clos_timestamp >= s_lastdelta

AND clos_timestamp <= s_currtime.

ENDIF.

[Former Member]

Hi Anil

You will not be able to enable selections while loading from the datasource to BI. It will be disabled automatically. A workaround for this is, when you load using the infopackage pull it till the PSA only. When loading from PSA to your infoprovider and using DTP you will able to add filters.

Hope this helps

Thanks.

[neelesh_jain3]

Selections are not possible for a delta load.

Cheers,

Neel.

[Former Member]

Hi Anil

Are you able to do a complete delta load? For selection parameter, did you select the selection check boxes for the datasource in R/3 side.

Do a complete init load and then try delta...

Hope this helps....

Cheers

Chanda

Edited by: Chandamita Sarmah on Sep 18, 2009 2:38 PM