This website is not affiliated with, sponsored by, or approved by SAP AG.

Function module which extracs data from BW to ERP

Business Warehouse

Moderators: Snowy, thx4allthefish

Function module which extracs data from BW to ERP

Postby svetlana_sunny » Thu Sep 09, 2010 2:24 am

Dears,
Would you,please,advise if there is an option, like Function module which can extract data from BW to ERP?
BW consultant have created a complex BW report which outcome calculated data I need to use in an ERP Z custom program>
So, basically I need to get BW data ready in a BW report to be sent back to ERP and used in na Z program for further calculation and posting in ERP.

Thanks in advance,
CO consultant
Svetlana
Kind regards,

Svetlana Petkova
SAP FICO Consultant
svetlana_sunny
 
Posts: 86
Joined: Tue May 08, 2007 4:05 am
Location: Bulgaria

Re: Function module which extracs data from BW to ERP

Postby El Belgio » Thu Sep 09, 2010 3:51 am

to extract data out of BW, you can use the Open Hub functionality

however, if you want to use query results, I suggest you save the results as .csv (if you want to automate this, use APD) and "upload" it into ECC via a simple upload program
El Belgio
 
Posts: 2576
Joined: Tue Oct 22, 2002 7:15 am
Location: back in rainland

Re: Function module which extracs data from BW to ERP

Postby svetlana_sunny » Fri Sep 10, 2010 2:03 am

El,Thank you very much!
Having BW query in csv file and uploading it in ERP is really intelligent and fast solution.
So last thing we must do is to write an ABAP program in ERP which can refer to the stored csv file in BW and uplaod in a z table in ERP,right?
Hope I understood you correctly...
Even though I was curious to know if there is a BW tool which can send the BW csv file to ERP.

Thanks again.
Kind regards,

Svetlana Petkova
SAP FICO Consultant
svetlana_sunny
 
Posts: 86
Joined: Tue May 08, 2007 4:05 am
Location: Bulgaria

Re: Function module which extracs data from BW to ERP

Postby sapsepo » Fri Sep 10, 2010 5:30 am

If you want to use ABAP you can use FM RSDRI_INFOPROV_READ to read an infocube in BW.
Take a look at program RSDRI_INFOPROV_READ_DEMO for a demonstartion of how to use the funcion module.
sapsepo
 
Posts: 106
Joined: Tue Sep 09, 2008 8:55 am
Location: spaghettiland

Re: Function module which extracs data from BW to ERP

Postby El Belgio » Thu Sep 16, 2010 7:56 am

I don't think there is such a 'tool' just yet... it's kind of agains the idea behind having a BW system. DataWarehousing works in the other direction, no? But it kind of sounds like you wish to use some kind of Consolidation on top of BW? You may want to look into IP or BPC...
El Belgio
 
Posts: 2576
Joined: Tue Oct 22, 2002 7:15 am
Location: back in rainland

Re: Function module which extracs data from BW to ERP

Postby sapsepo » Wed Sep 22, 2010 6:13 am

Maybe OP needs something like a BPS retractor, to update plan data into R/3 - ECC.
If so, there are some standard functions for some functional areas, those can be easier to implement than a custom ZPROGRAM.
sapsepo
 
Posts: 106
Joined: Tue Sep 09, 2008 8:55 am
Location: spaghettiland


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 2 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.