reconciliation and data verification approaches for data in sap r/3 and bw

[Former Member]

Hi

Cam anybody suggest what are the different reconciliation and data verification approaches to assure that BW and R/3 source data are in sync.

Thanks in advance.

Regards,

Nisha.

[Former Member · Accepted solution]

Hi Nisha,

This is a pretty big subject, and it varies per extract. One of the best ways to do this is to find a report on the SAP OLTP system that matches datasource you are using. SAP will give you hints on this sometimes at help.sap.com.

I have read that SAP was going to write reconciliation datasources, but I am not sure when they will be avaiable.

Cheers!

[Former Member]

hi,

try this doc:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/968dab90-0201-0010-c093-9d2...

regards,

Andrzej

[Former Member]

Hi

What you can do is, go to R/3 transaction RSA3 and run the extractor, it gives you the number of records extracted and then go to BW Monitor to check the number of records in the PSA.

if it's the same, there you go.

there is an HOW-TO Document on service market place "Reconcile Data Between SAP Source Systems and SAP BW".

Check this document as well which is very helpful.

There is another HOW-TO document "Validate infocube data by comparing it with PSA Data". this is also a good document.

Hope it helps.

Hari Immadi

http://immadi.com

SEM BW Analyst