on 12-23-2015 1:05 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.