topic using gui_download in Application Development and Automation Discussions

using gui_download

Former Member — Mon, 20 Aug 2007 11:45:58 GMT

Hi,

How to display header in xl file using gui_download function

Re: using gui_download

Former Member — Mon, 20 Aug 2007 12:03:12 GMT

pass an internal table to the fieldnames parameter

Re: using gui_download

Former Member — Mon, 20 Aug 2007 12:11:43 GMT

Hi,

<b>Please see below 2 postings

Regards, ABY

Message was edited by:

Aby Jacob Emmanuel

Re: using gui_download

Former Member — Mon, 20 Aug 2007 12:13:44 GMT

Hi,

try with this.

first populate 'I_FCOL' with header data.

and then populate actual data in internal table 'I_FILE'.

try with below code.

DATA: I_FCOL TYPE SY-TITLE OCCURS 0 WITH HEADER LINE. "field name

APPEND 'G/L Account'(089) TO I_FCOL.

APPEND 'Posting Key'(041) TO I_FCOL.

APPEND 'Amount in doc.curr'(040) TO I_FCOL.

CALL FUNCTION 'WS_DOWNLOAD'

EXPORTING

FILENAME = L_FILENAME

FILETYPE = 'DAT'

TABLES

DATA_TAB = I_FILE

FIELDNAMES = I_FCOL

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.

Regards

Sudheer

Re: using gui_download

Former Member — Mon, 20 Aug 2007 12:16:39 GMT

You should use append = 'X' in exporting parameters.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = FILENAME

WRITE_FIELD_SEPARATOR = 'X'

append = 'X'

TABLES

DATA_TAB = jtab

...

Make sure the filendmaes you added is already in jtab internal table.The code you have given here seems that you are adding in header internal table.

Check the Function module documentation for example.

regards,

srinivas

<b>*reward for useful answers*</b>