topic Re: call function 'gui_download' in Application Development and Automation Discussions

call function 'gui_download'

Former Member — Wed, 12 Sep 2007 12:42:50 GMT

Hallo Friends,

I am using the above fuction in my program. I want the header of my internal table to be writen als header in the text file. So, I created another Itab (Itab-col_1) and appended all the headers in this, which I later use as below.

Problem:

I am not satisfied with the downloaded output in file.txt I want the header to be excactly over the column content. Please see my output:

MANDT LIFNR LAND1 NAME1 NAME2 NAME3

010

§§§§§§0000010000
§§§§§§§§§§§§§§§§§§DE
§§§§§§Test

010
§§§§§§0000100000
§§§§§§§§§§§§§§§§§§US
§§§§§§TEST

§ § means Space

It is Obvious LAND1 should be over DE / US, NAME1 should be over Test / TEST etc etc

I would like filed seperator to be ( ; ) not space. The flag 'X' gives space.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = str

filetype = 'ASC'

write_field_separator = 'X'

dat_mode = 'X'

TABLES

data_tab = itab_kreditor

fieldnames = itab_datei_col_header

EXCEPTIONS

file_write_error = 1

file_not_found = 19

OTHERS = 22.

So, how can I solve these two problems.

Blacky.

Re: call function 'gui_download'

Former Member — Wed, 12 Sep 2007 12:55:50 GMT

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE = BIN_FILESIZE

filename = filename

FILETYPE = 'ASC'
APPEND = ' '

<b> WRITE_FIELD_SEPARATOR = ';'</b>

HEADER = '00'
TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '
CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
WRITE_BOM = ' '
TRUNC_TRAILING_BLANKS_EOL = 'X'
WK1_N_FORMAT = ' '
WK1_N_SIZE = ' '
WK1_T_FORMAT = ' '
WK1_T_SIZE = ' '
IMPORTING
FILELENGTH = FILELENGTH

TABLES

data_tab = data_tab

FIELDNAMES = FIELDNAMES
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.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Regards

Vasu

Re: call function 'gui_download'

Former Member — Wed, 12 Sep 2007 13:02:00 GMT

Hello Moses,

Download your file as XLS or CSV file rather than downloading as TXT using the same function modul. this could solve your problem.

cheers,

~thomas.

Re: call function 'gui_download'

Former Member — Wed, 12 Sep 2007 13:04:50 GMT

Hi,

If you download the fiel in a TXT format, then it will download based on the field lengths, so if you see the downloaded TXT file, then you can come to know, it will not come under the headings, if you want the fields come under the headings then download it in XLS format

Regards

Sudheer

Re: call function 'gui_download'

Former Member — Wed, 12 Sep 2007 13:11:30 GMT

if u want field separator as ';' then u declare an internal table with field of length 255 then concatenate all the fields of internal table into this field separated by ';'

loop at itab1.

concatenate f1 f2 ....into itab-field separated by ';'.

append itab.

endloop.

if u want to write the field values under the headings u can use fixed file format.

like u specify the positions where they have to b displayed......

Message was edited by:

Premalatha G