Debugging duplicate records from PSA into WO DSO

[alex_wiebe]

I am doing some testing and the code i didn't change (I think) is giving me problems. Joy ...

There is a delta extractor loading the PSA table 0CO_OM_CCA_9. I ran an extraction on Monday and 0 records came across. Our tester put 2 records into ECC Tuesday morning. Here is his email:

    As requested, I have put some data into U10 to test the QB1 2015 cubes.

    SAP Doc # 7153797919 - January 2015

    There are 2 postings in company code 1000:

    4259001 DG1174 $5,000,000

    4218001 DG1174 $1,000,000

    Offset for both is 7008151

I ran the extract within 20 minutes of his note and  no records came across. I ran it again a couple hours later and received 6 records.

I then ran a DTP delta from the PSA to a WO DSO. It fails claiming the first 3 records are duplicates. When I look at the data in the DTP's extraction step (from the process monitor) I see the records in the attached spreadsheet.

The semantic key for our DSO is

• 0CO_AREA
• 0CO_DOC_NO
• 0CO_ITEM_NO
• 0CURTYPE
• 0METYPE
• 0VTYPE
• 0FISCVARNT

When I query the DSO before hand for anything in period 2015.001 for cost center DG1174 I get no records found.

After I run the DTP (with the noted error), I see the 3 records for account 4218001 (the $1M record), but not the 3 that the DTP is complaining about.

Looking at the spreadsheet, I cannot see what might be the duplicate key it is complaining about.

In the PSA maintenance screen, only the last extraction (with the 6 records) exists - I have deleted all the rest.

dsoloadfail.txt.zip

[ccc_ccc]

Hi Alex,

In attached file , I saw that those are not duplicate records as i see 3 different values for filed

VERSN , FISCVAR, KTOPL and SAKNR.

Please check.

Regards,

Nanda

[Former Member]

Hi Alex,

in the settings of wdso, you can set Allow Duplicate Data Records checked so that you can load all the records from PSA to the WDSO.

[alex_wiebe]

Well upon deeper inspection, it would appear that our ECC & BW test systems may be out of sync.

The ECC test system is restore from November, while the BW system is from December. The document number in the new test data was already in the BW system.

2015.01.07                                         Dynamic List Display                                                 1

  ...TCENTER Currency 0DOC_DATE 0FISCPER 0CO_AREA 0CO_DOC_NO ...ITEM_NO 0CURTYPE 0FISCVARNT 0METYPE 0VTYPE      0AMOUNT

  0000630210 CAD 2014.10.24 2014011 FRS1 0207749921         1 00 K4   1000    10    1,202.32

  0000630210 CAD 2014.10.24 2014011 FRS1 0207749921         1 10 K4   1000    10    1,202.32

  0000630210 CAD 2014.10.24 2014011 FRS1 0207749921         1 20 K4   1000    10    1,202.32

  DG1174 CAD 2015.01.06 2015001 FRS1 0207749921         2 00 K4   1000    10 1,000,000.00

  DG1174 CAD 2015.01.06 2015001 FRS1 0207749921         2 10 K4   1000    10 1,000,000.00

  DG1174 CAD 2015.01.06 2015001 FRS1 0207749921         2 20 K4   1000    10 1,000,000.00

So now I'm wondering how the doc number gets generated, how to reset it and how to clean up this data?