Hi everyone,
My code downloads 4 internal tables to a single excel file by calling gui_download 4 times. The first time, parameter Append is blank, the remaining times, parameter Append is X. It works fine when all filetypes are ASC. I want the last internal table to download as filetype DBF, to preserve some specific formatting. When I change the last filetype to DBF, it no longer appends, but now overwrites the previous internal tables.
Does anyone know how to fix this problem? Here is code:
*download report sections
clear: l_append, l_ftype.
move ' ' to l_append.
move 'ASC' to l_ftype.
perform xl_download tables gt_col_header
using ld_fullpath
l_ftype
l_append.
if sy-subrc eq 0.
move 'X' to l_append.
move 'ASC' to l_ftype.
perform xl_download tables gt_outheader
using ld_fullpath
l_ftype
l_append .
if sy-subrc eq 0.
move 'X' to l_append.
move 'ASC' to l_ftype.
perform xl_download tables gt_col_report
using ld_fullpath
l_ftype
l_append .
if sy-subrc eq 0.
move 'X' to l_append.
move 'DBF' to l_ftype.
perform xl_download tables gt_outreport
using ld_fullpath
l_ftype
l_append.
endif.
endif.
endif.
FORM xl_download TABLES P_DATATAB type standard table
USING p_fullpath
p_ftype
p_append.
CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
filename = p_fullpath
filetype = p_ftype
APPEND = p_append
write_field_separator = 'X'
TABLES
data_tab = p_datatab
EXCEPTIONS
FILE_WRITE_ERROR = 1
GUI_REFUSE_FILETRANSFER = 2
INVALID_TYPE = 3
NO_AUTHORITY = 4
UNKNOWN_ERROR = 5
HEADER_NOT_ALLOWED = 6
SEPARATOR_NOT_ALLOWED = 7
FILESIZE_NOT_ALLOWED = 8
HEADER_TOO_LONG = 9
DP_ERROR_CREATE = 10
DP_ERROR_SEND = 11
DP_ERROR_WRITE = 12
UNKNOWN_DP_ERROR = 13
ACCESS_DENIED = 14
DP_OUT_OF_MEMORY = 15
DISK_FULL = 16
DP_TIMEOUT = 17
FILE_NOT_FOUND = 18
DATAPROVIDER_EXCEPTION = 19
CONTROL_FLUSH_ERROR = 20 .
ENDFORM. " xl_download
Bluesky
