cancel
Showing results for 
Search instead for 
Did you mean: 

BW Query --> CSV --> FTP

0 Kudos

Dear community,

What is the easiest way to export the result of a bex query (daily) as CSV to an FTP server?

We have SAP BW 7.3 and BO 4.1 ...

Best regards,

Markus

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can use broadcasting functionality for your report and schedule the broadcasting as daily as per your time which will deliver you the exported data every day.

Is this what you want.

Regards,

Amit

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Markus,

The easiest way to take a BEx query and write it to a CSV file is by creating an analysis process (APD).  That will write the file to the application server.  For the FTP, there are standard ABAP functions (FTP_CONNECT and FTP_COMMAND) for connecting to an FTP server and sending files.  We usually then set up a 2 step process chain with the APD and the ABAP program to send the file.

Regards,

Tony Herman