Deep structure to excel sheet

[Former Member]

I am trying to download an internal table with deep structure to an excel sheet. I used function modules GUI_DOWNLOAD and MS_EXCEL_OLE_STANDARD_DAT, but both result in a short dump. The reason is during run time this deep structure is pushed into a variable of type STRING. Due to this incompatible conversion the runtime is triggering a dump. Is there any alternative for this?

[Madhurivs23]

You can devide that deep structure into simple ones and pass them separately to the 2 files.

or u can assign the values of the deep structure line by line by filling out the internal table as

line1 : stru1 data

line2 : strut2 data

line3 : stru1 data

line4 : strut2 data

and then download the above internal table using GUI_DOWNLOAD.

rgds,

Madhuri

[Former Member]

Hi

Define your table as data:

data:begin of downlist occurs 0,

line(155),

end of downlist.

call function 'GUI_DOWNLOAD'

exporting

filename = lfullpath

filetype = 'ASC'

tables

data_tab = downlist

Hope this helps.