Skip to Content

How can we check data in r3 with that of BI Report?

Hi All,

I have data in report.

I have to compare that data in the report with that of soure data(r3).

in the source when i got to rsa3 and give the data source i am able to see total number of records but no the data.

1)How can i see the data coming for spefic field or all the fileds which are data source?

2)For one field i am getting data for infoprovider but not in the report?

Thanks all.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Sep 22, 2011 at 06:58 AM

    Hi,

    It all depends on how many fields you have mapped in R/3 in BW system.

    First check you can carry out in PSA itself whether data is correct.

    Then you can check directly at report level in case there is any logic written in betwen data might defer.

    You can also refer to some R/3 transactions to check data say MM01,VF01,FB5B etc depending on modules you are checking data. You can use RRI as well to jump from BW to R/3 .

    Thanks and regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 06:39 AM

    Hi ,

    Goto RSA1 Open DATA Source from left pane and double click on Data Source which you want to identify ...

    On Right pane you will be getting your data source open with three tabs General Information, Extraction and field

    Go to fields and see filed of data source... with help of Functional consultant you can identify which are used for which...

    -


    If you want to analyze which fileds are been mapped to data target .. Beneath of Data Source there is DATA FLOW UPWARDS , expand it upto transformation double click and check which field mapped to which info object...

    -


    Thanks

    BVR

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Naidu Z

      Hi....

      I have data in report.

      Hope this report is developed based on MultiProvider ..

      I have to compare that data in the report with that of soure data(r3).

      in the source when i got to rsa3 and give the data source i am able to see total number of records but no the data.

      Once its shown number of records then click ALV / List which will show your the records...

      1)How can i see the data coming for spefic field or all the fileds which are data source?

      To identify the this , please check the mapping of field in between Data Source and Target... then go to your target list the data...

      2)For one field i am getting data for infoprovider but not in the report?

      If your report developed based on multi provider , and even you can see data in multiprovider , hard filter would be the issue ....

      ---Thanks

      BVR

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 06:45 AM

    Hi ,

    The best way to reconcile data from R/3 and BW is to create a Reconciliation report. You can create a reconciliation report over a multiprovider created on the your existing infoprovider and a virtual cube(which is built directly on the data source and which fetches data directly from R/3).

    You can get help from following link on this process :-

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0931642-1805-2e10-01ad-a4fbec8461da?QuickLink=index&overridelayout=true

    Also you can get many other links for creating Virtual infoprovider for data reconciliation on SDN.

    Navesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 06:54 AM

    Hi,

    Are you trying to reconcile the data of BW with R/3 ?

    if yes, then you need to use a Virtual info provider in your Multiprovider, you can design the query in such a way that it should have keyfigures ( for BW and R/3 ) which can be used to Reconcile/Compare.

    you don't need to execute the report and comapre it manuallywith the data in RSA3.

    Regards,

    Sudheer

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.