2007 Sep 18 5:46 AM
Hello All
there is a prob when downloading the report into excel file. when the report is displayed it shows me 445 records. when i downloaded the same thing using file>>save>spreadsheet..it displays me only 412 records. and then i realized that it didnt downloaded the records of few particular dates. next time when i gave the selection screen of those dates , the records have been downloaded.
and then i used gui_download function to download the file, then the same thing happened.
so i changed the filetype to 'ASC' , then it is downloading all the records but the data is not divided into column wise.
i even chk the internal table it has 445 records...
can anyone comeup with a suggestion ??
FORM download.
CALL FUNCTION 'WS_DOWNLOAD'
EXPORTING
filename = p_file
filetype = 'DAT'
TABLES
data_tab = t_download
FIELDNAMES =
EXCEPTIONS
file_open_error = 1
file_write_error = 2
invalid_filesize = 3
invalid_type = 4
no_batch = 5
unknown_error = 6
invalid_table_width = 7
gui_refuse_filetransfer = 8
customer_error = 9
OTHERS = 10
.
Message was edited by:
shahid mohammed syed
2007 Sep 18 6:56 AM
hI
WS_EXCEL IS THE FM TO DOWNLOAD TO EXCEL
WS_DOWNLOAD IS FOR CSV AND TEXT FILES.
THANKS
REWARD IF HELPFUL
VIVEKANAND
Hello All
there is a prob when downloading the report into excel file. when the report is displayed it shows me 445 records. when i downloaded the same thing using file>>save>spreadsheet..it displays me only 412 records. and then i realized that it didnt downloaded the records of few particular dates. next time when i gave the selection screen of those dates , the records have been downloaded.
and then i used gui_download function to download the file, then the same thing happened.
so i changed the filetype to 'ASC' , then it is downloading all the records but the data is not divided into column wise.
i even chk the internal table it has 445 records...
can anyone comeup with a suggestion ??
FORM download.
CALL FUNCTION 'WS_DOWNLOAD'
EXPORTING
filename = p_file
filetype = 'DAT'
TABLES
data_tab = t_download
FIELDNAMES =
EXCEPTIONS
file_open_error = 1
file_write_error = 2
invalid_filesize = 3
invalid_type = 4
no_batch = 5
unknown_error = 6
invalid_table_width = 7
gui_refuse_filetransfer = 8
customer_error = 9
OTHERS = 10
.
Message was edited by:
shahid mohammed syed
2007 Sep 18 6:46 AM
Hi Shahid,
Is your report output an ALV?
If yes.....Check your field catalog.
Regards,
Ravi
2007 Sep 18 6:53 AM
2007 Sep 18 6:56 AM
hI
WS_EXCEL IS THE FM TO DOWNLOAD TO EXCEL
WS_DOWNLOAD IS FOR CSV AND TEXT FILES.
THANKS
REWARD IF HELPFUL
VIVEKANAND
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |