10-22-2007 10:32 AM
Hi,
i want to save a alv grid to an excel-file on a local fileshare using an background job..
Does anybody know how this works?
Thanks ahead
10-22-2007 10:32 AM
10-22-2007 10:43 AM
hi Bernd,
this is not possible. When a program run in background, it means that it runs on SAP server and has not much idea about what is outside SAP server...
ec
10-22-2007 11:24 AM
This is not possible. No GUI => no connection to the presentation server. You can only export the data to the application server.
10-22-2007 11:49 AM
OK, how can i export the data to the application server as an xls-file?
10-22-2007 1:52 PM
The only way of doing this is to convert it to an csv file component by component. This file is then readable by excel.
10-22-2007 11:55 AM
DATA: file TYPE string VALUE `flights.dat`,
wa TYPE spfli.
FIELD-SYMBOLS TYPE x.
OPEN DATASET file FOR OUTPUT IN BINARY MODE.
SELECT *
FROM spfli
INTO wa.
ASSIGN wa TO CASTING.
TRANSFER TO file.
ENDSELECT.
CLOSE DATASET file.
<b>The binary data from database table SPFLI is transferred to a binary file flights.dat</b>
10-24-2007 9:28 AM
Hi Prashant,
After the code is executed, How will I see the flights.dat file ?
Regards,
Vishwa.
10-24-2007 9:33 AM