2LIS_02_SCL get repeat records when extracting

[Former Member]

Hi.experts:

I encounter a problem that 2LIS_02_SCL extract repeat records on REVERSE IMAGE,and then I get over 10 000 records about one purchase order,which has just one order item and 4 schedule item.

I use AFS in my system,who can help me about this?

Your quick response will definitely get high points.

Best Regards

Martin Xie

[Former Member · Accepted solution]

Dear Martin,

Iu2019m going to try to help you regarding your question,

You should take care with your initialization setting. Be careful with the filteru2019s InfoPackage of initialization delta load and filteru2019s InfoPackage of delta load. Both should be the same. Check both filters:

Step One BI system u2013 InfoPackage Delta Initialization: Tcode RSA1 u2014 DataSource u2013 InfoPackage u2013 Data Selection.

Step Two BI system u2013 InfoPackage Delta Initialization. Tcode RSA1 u2013 DataSource u2013 InfoPackage u2013 Tool Bar u2013 Scheduler u2013 Initialization Option for Source System.

Step Three Source System u2013 RSA7 u2013 Look for a DataSource.

Furthermore, determine the content of u201CDeltau201D field in tables RSOLTPSOURCE or RSDS (in BW) or ROOSOURCE (in the SAP source system) for the DataSource.

In both table you can check how the data is extracted.

In hope this guideline can help you to answer your question,

Luis

[Former Member · Accepted solution]

Thanks for your quick response,my question is that:even one schedule line in purchasing order produce more than 20,000 records when using RSA3 or extract to BW.

I followed the standard process when setup data in R/3,and delete the setup table before re-setup the history data.

Best Regards

Martin Xie

[Former Member · Accepted solution]

I suggest to have a DSO in between . I mean the same records will be overwritten thean and tyhe repetition of records will be avoided .

Assign marks is the best way to appreciate help

[virenp_devi · Accepted solution]

Hi,

What package are you on?

Try snote 1034952. If doesnt work please raise OSS.

Regards,

Viren

[Former Member]

Even I am facing the same issue.

Have you got solution to this issue?

[Former Member]

No,,buddy..I have create my owned datasource based on EKBE & EKET.

But I think you should upgrade your AFS version so that the extraction can work properly..that's my opinion,,