topic Re: Internal table into excel sheet in Application Development and Automation Discussions

Internal table into excel sheet

Former Member — Mon, 16 Jul 2007 02:58:36 GMT

Hi Friends,

I want my internal table data to be downloaded in the excel sheet when I am debugging the program. I know their is option to download it to the sheet, but I am unable to find the option in the debugging screen.

Can any one tell me how to do it?

Regards,

Line

Re: Internal table into excel sheet

Former Member — Mon, 16 Jul 2007 03:07:54 GMT

step 1- from menu bar use GOTO ->display data object -> structure editor.

step-2 from menu bar use OBJECT ->display entire list

step-3 from menu bar use SYSTEM -> list-> save->Local file.

Re: Internal table into excel sheet

Former Member — Mon, 16 Jul 2007 03:08:29 GMT

Also Refer

Re: Internal table into excel sheet

former_member189059 — Mon, 16 Jul 2007 03:13:14 GMT

Hello,

First display the table by double clicking on it

Make sure the tab shows 'table' and not 'field'

The Export to excel button is the last button on the bottom toolbar (after the Find buttons)

Re: Internal table into excel sheet

Former Member — Mon, 16 Jul 2007 03:27:01 GMT

hi Line

use this simple code its very easy to download internal data to excel.

use this with Perform statement

&----

*& Form DOWNLOAD_DATA

&----

text

----

--> p1 text
<-- p2 text

----

FORM download_data .

DATA : w_pth TYPE rlgrap-filename.

DATA : w_file TYPE rlgrap-filename.

TYPES : my_type(20) TYPE c.

DATA : it_header TYPE TABLE OF my_type.

*--- Add Header Fields to Header Table ---

APPEND 'GRENNN TY' TO it_header .

APPEND 'DESCRIPTION' TO it_header .

APPEND 'SIZE & PATTERN' TO it_header .

APPEND 'OVEN TYPE' TO it_header .

APPEND 'TOTAL TO BE MADE' TO it_header .

APPEND 'PLANNING TYPE' TO it_header .

APPEND 'MOULD INVENTORY' TO it_header .

APPEND 'PER DAY CAPACITY' TO it_header .

APPEND 'DAILY CAPACITY' TO it_header .

APPEND 'LOSS' TO it_header .

w_pth = 'D:\'.

CONCATENATE w_pth sy-datum ' - ' sy-uzeit' - ' 'GREEN TY REQ PLAN.XLS' INTO w_file.

CALL FUNCTION 'WS_DOWNLOAD'

EXPORTING

filename = w_file

filetype = 'DAT'

TABLES

data_tab = IT_GREEN_REQPLAN2

fieldnames = it_header

EXCEPTIONS

file_open_error = 1

file_write_error = 2

invalid_filesize = 3

invalid_type = 4

no_batch = 5

unknown_error = 6

invalid_table_eidth = 7

gui_refuse_filetransfer = 8

customer_error = 9

OTHERS = 10.

ENDFORM. " DOWNLOAD_DATA

Rewards if useful.

Re: Internal table into excel sheet

Former Member — Mon, 16 Jul 2007 03:29:16 GMT

Now I am in 4.7 version and here if you click on <b>Table</b> tab you can get the excell down load option in application tool bar ( or Ctrl+F11). But not sure if it is available or not in 4.6c or in lower version.

regards

shiba dutta