Download excel

Former Member — Tue, 08 Apr 2008 03:49:12 GMT

output is being displayed in ALV hirarchical list and this output is to be downloaded in EXCEL for

but the format of the output is below.

Material Description Validity EAN-code Plant Description

1M00.590 GO520 Scandinavia 1/1/2008 636926017046 NL10 Moduslink

Level Material Description Qty. Material type Material group

0 1M00.590 Scandinavia 1 FERT

1 5M00.590 Outerbox Scandinavia 1 HALB NL

1 2M00.590 Component Box Sub 1 HALB CN

2 5M00.000 x20 Plastic Tray 1 HALB NL

Material Description Validity EAN-code Plant Description

1M00.510 GO520 Scan 1/1/2008 636926017046 NL10 Moduslink

Level Material Description Qty. Material type Material group

0 1M00.510 Scandinavia 1 FERT

1 5M00.510 Outerbox Scandinavia 1 HALB NL

1 2M00.510 Component 1 HALB CN

2 5M00.000 x20 Tray 1 HALB NL

Please suggest how to acheive this?

Re: Download excel

Former Member — Tue, 08 Apr 2008 04:13:19 GMT

Dear Prince,

Since you might be using internal table for ALV output, same internal table you may pass to FM 'GUI_DOWNLOAD'

like below.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\Documents and Settings\saptrng\Desktop\desktop\xyz.xls'

FILETYPE = 'ASC'

WRITE_FIELD_SEPARATOR = 'X'

tables

data_tab = itab

IF sy-subrc <> 0.

ENDIF.

PS : reward if useful

Regards

Talwinder