Data inconsistency during full load in infopackage

[former_member418469]

Hello,

I am loading transaction data through infopackage with full update  with selections say CREDAT = previous day, STAMNO and STATUS. Data extracted from R/3.

It is related to idoc data, brings data from table EDIDS (R/3ECC) through a function module.

Normally extracts lesser than 5000 records in a day. But last few days huge data is extracted brings for all days.

So if date as 19.03.2015 in selections-infopackage but it brings for all the days.

I checked manually in R/3 in se16 and RSA3 data is not equal, difference is huge.

I replicated the datasource again but no use.

Thanks

[Former Member]

Hi Harish,

I think you should check your function module.

When datasource uses a function module you need to include the field(s) that you want to be available in the selection criteria(in this case : CREDAT) in following parts of the code.

For Eg :

RANGES: l_r_credat  FOR <name of the table>-credat.

LOOP AT s_s_if-t_select INTO l_s_select WHERE fieldnm = 'CREDAT'.

        MOVE-CORRESPONDING l_s_select TO l_r_credat.

        APPEND l_r_credat.

      ENDLOOP.

OPEN CURSOR WITH HOLD s_cursor FOR

      SELECT *

          FROM <name of the table>

          WHERE ( condition ) AND

                  credat IN l_r_credat.

Try to change this code and extract records in RSA3 with CREDAT = 19.03.2015

Hope this helps.

Regards

Sakshi

[Loed]

Hi Harish,

In your datasource, you should uncheck the 'Field Only Known in Customer Exit' if you will use the CREDAT field as SELECTION..

Please refer in this blog:

http://scn.sap.com/docs/DOC-61106

Regards,

Loed

[former_member418469]

Hello Loed,

I checked RSA6-> display data source in ECC, the field CREDAT was unchecked only.

[Loed]

Hi Harish,

What do you mean "was unchecked only"?

You should uncheck the 'Field Only Known in Customer Exit' of CREDAT field to be able to use it in SELECTION..

If you tick the CREDAT field in the SELECTION column, you should uncheck it in the FIELD ONLY......column.,

Regards,

Loed

[former_member418469]

Loed,

Field only column was already unchecked.

[RamanKorrapati]

Hi,

Are you using same date or field for selection?

please cross check about date field.

While checking thru SE16(have you removed max limit 200 rows displayed) or RSA3, have you increased display calls/extractors  results?

First check at source side table Thru SE11 with some date selection.

Use same selection date at RSA3 and extract it. While extracting at RSA3, increase  data record/calls and display extr calls.

Are you