topic Re: Deep structure to excel sheet in Application Development and Automation Discussions

Deep structure to excel sheet

Former Member — Tue, 09 Jun 2009 05:16:28 GMT

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?

Re: Deep structure to excel sheet

Madhurivs23 — Tue, 09 Jun 2009 07:53:14 GMT

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

Re: Deep structure to excel sheet

Former Member — Tue, 09 Jun 2009 08:17:49 GMT

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.