Automation of "pulling SAP report data" into BW

Hi,

I need to upload standard SAP R3 report data into BW at the end of every month.

I'm looking for something like this. Is this possible?

--> run SAP R3 report automatically

--> save the report into a CSV file

--> save the file onto a application server

--> if successful, raise an event & schedule a process chain to load CSV file into ODS.

Please remember that, i can't use any standard extractors as this report is complicated.

I can't even use generic extractors as it is not a single table but many tables (I can't even create joins out of the tables to get the report).

Appreicate any help on this.