More Records in PSA COMPARED TO IN DATASOURCE

[Former Member]

While working on FI Extraction, when I checked the total number of records for 0FI_GL_4 in RSA3 in source system, It was 799 records.

But when I replicated in BW system and loaded into PSA, then there were 2,105 records ( 912 records in 1st Data Package and 1193 records in 2nd Data Package). Can u please explain me about how these extra number of records came in BW System.

Thanks,

Shruti.

[RamanKorrapati · Accepted solution]

Hi,

At RSA3, have you used any selections?

what display/extractor calls you used?

At RSA3

Try to increase data records 1000

          display extr calls - 99 and later do the extraction.

see the count and compare with bw.

it may matches.

Thanks

[Former Member · Accepted solution]

Hi Raman,

I changed the settings as said by you.

It worked perfectly.

Now, the total number of records are matching in both Source system and BW System.

So, the conclusion is - The actual number of records are the ones which are showed in BW System.

Please correct me If m wroung.

Thanks,

Shruti

[RamanKorrapati · Accepted solution]

Even it showed at source side as well. But need to know how to play with RSA3.

[Former Member · Accepted solution]

Hi Raman,

Here is my one more doubt related to the data extraction from source system to BW system.

When m checking the Number of records in RSA3 in source system, there are 1009 records.

But when m checking in PSA, I could see only 605 records.

The infopackage setting is Init with data transfer.

What happened to the rest of the records?

Will you please tell me what should I do to see all records in BW same as present in source system.

Thanks & Regards,

Shruti Yendigeri

[RamanKorrapati · Accepted solution]

Hi,

Where your facing this problem?

Production or dev system?

is your info pack - init with data transfer load was completed?

Can you check your PSA -->manage-->see there, requests are green or yellow or red?

if possible then delete psa data and again reload full load info pack.

Later check/see the record count at PSA, it will match with RSA3..

in future please open new discussion for new issues.

Thanks

[Former Member · Accepted solution]

Hi Raman,

I was facing this in Production system.

I deleted the data in PSA and again loaded with FULL Load.

Now the records are matching.

yes, will make sure to open new discussion for new issues.

Thank you.