Comparing r/3 and bi ( records count)

[Former Member]

Hi,

When i extract data from r/3 to bi, at PSA level i got more records when compared with the number of records in RSA3.

I think the records count should be equal. Plz clear my doubt. I checked forums also but no use.

Thanks

[Former Member · Accepted solution]

generally the data returned by RSA3 and PSA should be the same

check note 529789

1) compare the data with your application table...

2) check the data records/cell in RSA3.

3) Make sure there is no InfoPackage routine to split the records.

[Former Member · Accepted solution]

In psa i got the records in psa 3783713 From 3654848 Records. and got errors . but in rsa3 i got 96,835 data records selected.

error as Error occurred in the data selection . can you plz guide?

thank you for u r replies

[Former Member · Accepted solution]

What is Datasource name.

Regards,

Sushant

[Former Member · Accepted solution]

hi

0hr_py_1 is the data source.

thank you

[former_member202684 · Accepted solution]

It is always better to validate against the base table and applying any logic (if any) in the CMOD.

What is the error? can you give any details?

Also, was the base data changed recently (i.e. after checking the count or something or some sort of reverse postings or something)? if so may be the records would have come more than once...

Regards,

Joe

[Former Member · Accepted solution]

the errors are

this i saw in details tab

1. Error occurred in the data selection

2. Data Package 151 : arrived in BW ; Processing : Selected number does not agree with transferred n

Data Package 152 : arrived in BW ; Processing : Selected number does not agree with transferred n

also the error message in status tab is

1. error during import of results for employee

2. error in source system

message no: RSM340 ( THIS LOG I WAS POSTED IN ANOTHER FORUM)

Thank you

[former_member210615 · Accepted solution]

hi,

looks to me... some kind of IDOC issue, what is the IDOC status in R/3

it seems there is problem in the RFC connection, can you please check in sm58.

menu->qout schecduler , then a screen will appear goto menu again->QRFC Resources

check the status of DIA/WP

if less ask your BASIS to increase DIA processes

check in tcode SARFC see what is the status of system config there..

hope it helps

regards

laksh

[shahidimam_shaik · Accepted solution]

Hi,

You got 96, 835 records in rsa3, and 3783713 From 3654848 Records in PSA?

So, try loading again, by giving small selections.

e.g: Quarterwise, or month wise.

regards,

[Former Member · Accepted solution]

hi

thank you for your reply,

i checked the QRFC Resources found that max DIA are 15 and shows ok.

and in t-code SARFC shows resources are ok

any solution plz

thank you

[Former Member]

Better validate data against Table.

Regards,

Sushant