안녕하세요?
아래의 펑션으로 xls 파일을 다운 받는데 어느 순간부터 행 수가 제한이 되어버립니다.
관련하여 해결방법이나 세팅 방법을 아신다면 답변주시면 감사하겠습니다.
(3700->377 건만 다운 가능.. )
call function 'GUI_DOWNLOAD'
exporting
filename = filename
filetype = 'ASC'
write_field_separator = 'X'
codepage = '8500'
-------------------------------------------
test파일
-------------------------------------------
REPORT ztest.
DATA : BEGIN OF gt_excel OCCURS 0,
g001(50), g002(50), g003(50), g004(50), g005(50), g006(50), g007(50),
g008(50), g009(50), g010(50), g011(50), g012(50), g013(50), g014(50),
g015(50), g016(50), g017(50), g018(50), g019(50), g020(50), g021(50),
g022(50), g023(50), g024(50), g025(50), g026(50), g027(50), g028(50),
g029(50), g030(50),
z001(50), z002(50), z003(50), z004(50), z005(50), z006(50), z007(50),
z008(50), z009(50), z010(50), z011(50), z012(50), z013(50), z014(50),
z015(50), z016(50), z017(50), z018(50), z019(50), z020(50), z021(50),
z022(50), z023(50), z024(50), z025(50), z026(50), z027(50), z028(50),
z029(50), z030(50),
m001(50), m002(50), m003(50), m004(50), m005(50), m006(50), m007(50),
m008(50), m009(50), m010(50), m011(50), m012(50), m013(50), m014(50),
m015(50), m016(50), m017(50), m018(50), m019(50), m020(50), m021(50),
m022(50), m023(50), m024(50), m025(50), m026(50), m027(50), m028(50),
m029(50), m030(50),
END OF gt_excel.
FIELD-SYMBOLS <fs>.
data l_text(40).
data l_n(3) type n.
do 1500 times.
clear gt_excel.
clear l_n.
do 30 TIMES.
add 1 to l_n.
CONCATENATE 'gt_excel-g' l_n into l_text.
ASSIGN (l_text) to <fs>.
<fs> = '가나다라마바사아자'.
add 1 to l_n.
CONCATENATE 'gt_excel-z' l_n into l_text.
ASSIGN (l_text) to <fs>.
<fs> = '가나다라마바사아자'.
add 1 to l_n.
CONCATENATE 'gt_excel-m' l_n into l_text.
ASSIGN (l_text) to <fs>.
<fs> = '가나다라마바사아자'.
enddo.
append gt_excel.
enddo.
data : filename type string.
CONCATENATE sy-uname sy-uzeit into filename.
CONCATENATE 'R:\' filename '.xls' into filename.
call function 'GUI_DOWNLOAD'
exporting
filename = filename
filetype = 'ASC'
write_field_separator = 'X'
codepage = '8500'
tables
data_tab = gt_excel
exceptions
file_write_error = 1
no_batch = 2
gui_refuse_filetransfer = 3
invalid_type = 4
no_authority = 5
unknown_error = 6
header_not_allowed = 7
separator_not_allowed = 8
filesize_not_allowed = 9
header_too_long = 10
dp_error_create = 11
dp_error_send = 12
dp_error_write = 13
unknown_dp_error = 14
access_denied = 15
dp_out_of_memory = 16
disk_full = 17
dp_timeout = 18
file_not_found = 19
dataprovider_exception = 20
control_flush_error = 21
others = 22.
if sy-subrc <> 0.
WRITE '실패'.
else.
WRITE '성공'.
endif.
만건 넘어갈때마다 DOWNLOAD 펑션을 다시 호출한 기억이 나네요..