How can we compare the R/3 data with B/W after the data loading.  What are the procedures to be followed?

Data validation Steps:

Following step-by-step solutions are only an example. 

1. Run transaction SE11 in the R/3 system to create a view which is based on the table of COEP and COBK. 
These two tables are the source information for extractor 0CO_OM_CCA_9 (CO cost on the line item level).

2. Define selection conditions. 
Only CO objects with prefix ‘KS’ or ‘KL’ should be selected because only these objects are relevant for the extraction and relevant for the reconciliation. 
’KS’ means controlling area; ’KL’ means cost element. 

3. Setting the ‘Maintenance Status’.  Status ‘Display/Maintenance Allowed’ allows you to display and edit this view.

4. Create a DataSource in transaction RSO2. 
Assign the DataSource to the appropriate application component. 
The view, which is created by following the steps above, should be used in this field.
Click the ‘Save’ button to save this DataSource. 
You will get a pop-up for the development class. 
For testing purposes you can save this DataSource as a local object. If you want to transport this DataSource into any other systems it should be saved with the appropriate development class.

5. Replicate this new Datasource ‘ZCOVA_DS1’ to BI and create InfoSource / Transfer Rule in BI the system.

6. Because the value of InfoObject ’0costcenter’ is determined in extractor 0CO_OM_CCA_9 and this logic cannot be replaced by the view
‘ZCORECONCILIATION’, this InfoObject has to be determined in the transfer rule using formula:
0costcenter = substring (object number, 6, 10).

7. InfoObject ‘0fiscvarnt’ can be assigned to a constant for testing purposes. 
In this example we assume that K4 is the fiscal year variant for the company. 
You can also determine the value of InfoObject ‘0fiscvarnt’ by reading the attribute value of InfoObject ‘0COMP_CODE’ which is available in the transfer structure.

8. In ‘ZCOVA_DS1’ InfoObject ‘0Fiscper’ (fiscal period) can be added to the InfoSource to make the comparison fairly easy. This InfoObject can be determined in the
transfer rule using formula: 
0FISCPER = CONCATENATE 

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com