Internal table into excel sheet

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

Also Refer

[former_member189059]

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)

[Former Member]

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.

[Former Member]

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