extract to flat file or IDOC

[Former Member]

Does anybody know how to use BW Datasources in R3 (found in transaction RSA5) to extract data to a flat file for the purpose of loading a non-SAP data warehouse?

The export file may be an IDoc.

I tried RSA3, but it seems you have to specify a "target system" which is a BW system. I simply want to use the BW extractors to extract to a file.

Thanks - I will reward points.

[Former Member · Accepted solution]

Hi Lichtenstein

You can do the same in RSA3 by specifying the datasource. It asks you for the the target system, but you may not specify any value in that. Even if you specify any target system, with update mode full, you should see the total number of records for the data source and you can always extract this data into an excell sheet and save. Hope i cleared your doubt..if not post again.

Thanx

sriram

[Former Member · Accepted solution]

Thanks,

That was exactly what I wanted to do.

Do you know any way to schedule this to run these on a regular basis (for example nightly)?

The other system could then use say Ascential Data Stage to load the data.

[Former Member]

Hi,

If it is function module based extractor then you can use the copy/modify the code (copy in case you are authorized to change it). Now at the end of the extractor write an ABAP code to download the data into a flatfile using GUI_DOWNLOAD or any suitable function module. You can use this extractor fn module in an ABAP program and schedule it everyday to create the flatfile.

If it view/table base extractor then use that in an ABAP program to create the flatfile.

Revert if you need more info.

You can find the type of extractor in RSO2 and also in the tabel ROOSOURCE.

Bye

Dinesh

Message was edited by: Dinesh Lalchand

[Former Member]

Hi again..

I dont have any clues to schedule this.. there are no option available to schedule..even i tried to execute the program associated with rsa3, but its not executable. So i dont have any idea on scheduling the same. Does anybody out there?

regards

Sriram