4 Replies Latest reply: May 24, 2012 3:01 PM by Kiran Vasant Kere RSS

data miss match error

Gurkiran Kaur
Currently Being Moderated

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

  • Re: data miss match error
    Anand Mehrotra
    Currently Being Moderated

    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.

  • Re: data miss match error
    Chandra MohanKunku
    Currently Being Moderated

    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.

    • Re: data miss match error
      Chandra MohanKunku
      Currently Being Moderated

      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.

  • Re: data miss match error
    Kiran Vasant Kere
    Currently Being Moderated

    Hi Jeet,

    Following thread will help u

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

    Thanks and regards

    Kiran

Actions