reading R/3 from BI

[Former Member]

Dear Friends,

I am trying to read records from R/3 directly from BI and not loading from it.

Would like to know what are the possible way(s) to do so.

Thanks.

Best Regards

Pascal Gabin

[Former Member · Accepted solution]

Pascal,

Using Remote cubes, data can be reported in BW without loading into BW from R/3. --> Not for huge data.

Or to dispay some records at R/3, using jump targets from BEx query we can jump into R/3.

[How Tou2026 Reconcile Data Between SAP Source Systems and SAP NetWeaver BI|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/7a5ee147-0501-0010-0a9d-f7abcba36b14]

Hope it Helps

Srini

[Former Member · Accepted solution]

Hi Srini,

Thanks. Points awarded.

I would like to know for huge data volumes, what would be the recommended approach?

Cheers.

Pascal

[Former Member · Accepted solution]

Pascal,

For good performance of reports and for any calculation needs to load data into BW.

Srini

[Former Member · Accepted solution]

May I know how is it practical to do data reconciliation, when SAP remote cube method is not meant to handle huge volumes of data ?

By definition, does reconciliation imply checking all line items or is there a summarised way to do the same?

[former_member184494 · Accepted solution]

If you are reconciling at a line item level - you are pulling up huge volumes of data - but then if the same is at a summarized value then maybe you can look at remote cube...

Also the reconciliation process typically starts at a high level going donw in terms of detail...

Another option is to have an RFC enabled Function module which can get the data from R/3 but still the limitation is te RFC connection and if you pull too many records through the RFC your connection will tank....

[shanthi_bhaskar]

certainly

1. create a RFC enabled FM in r/3 and put all neccesary code.

2. Call that FM in BW routines, programs, DTP where ever u want.

calling of FM shd have as shown below.

 CALL FUNCTION 'ZR3FM' DESTINATION SOURCE SYSTEM ID

Edited by: shanthi bhaskar on Mar 17, 2009 6:00 PM