data miss match error

[Former Member]

hi

can any body tell me hoe to validate the dat from r/3 to biw

it is the cas of cutomer balance

kindly help

[former_member188080]

Hi Jeet,

Following thread will help u

http://scn.sap.com/thread/1473252

Thanks and regards

Kiran

[Former Member]

Hi,

Follow the below mentioned steps to check the Data Consistency between Source System & BI....

1. Check fields in Source System's RSA3 fileds and DAta source fields in BI.

      Both should be matched.

2. Check whether there are any selections in Info Package.

     (Check whether the load is of FULL/Delta....if the load is of type Delta then the data willnot be matched with RSA3 in Source system.)

3. Go To Source System -> RSA3 -> Compare Data in Extract Checker with PSA Data in BI System.

Hope this step by step procedure will help you to resolve your issue.

Regards,

Chandra.

[Former Member]

Hi,

1. Check fields in Source System's RSA3 fileds and DAta source fields in BI.

      Both should be matched.

Compare Extract Structure with the Structure in BI. If the data in PSA and Source System(RSA3) is matching then there are no issues..we should check the data in source system RSA3 and PSA. If its matching then there should be some issues with the transformations.

Post your experience after applying the above checks.....

Regards,

Chandra.

[Former Member]

Hi ,

Follow the steps for data matching between BW & R/3

Check Cube data & R/3 data by T.code RSA3 ( R/3  extractor) . If there is any mismatch then check

R/3 data with PSA data . If it is matching , that upto PSA there is no problem . The possible error is in update rule & transfer rule , due wrong mapping or routine .

At the last cube data matches with R/3  , check your query .

Regards,

Anand Mehrotra.