Skip to Content
author's profile photo Former Member
Former Member

seletion parameters in the infopackage are not working for delta load

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2009 at 08:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 18, 2009 at 08:56 AM

    Selections are not possible for a delta load.

    Cheers,

    Neel.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2009 at 01:10 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.