excel sheet

[Former Member]

hello,

how can i get all the fields of the table into excel sheet..

when iam displaying the record i get only a few fields onto my local file..how can i get all the fields is there anything i wanna change in the settings..it is not programming thing..

just transering the fields using system-> save-> local file.

plz advise..

regds

[former_member188827]

in se11.after executing for a particular entry..when u get the record...

click on Settings menu...>format list..>Choose fields.

check if all da checkboxes are selected or not..

if not click on select all button or f9 key...

plz reward points if it helps

Message was edited by:

abapuser

[Former Member]

hi,

go system->list->save->local file->spreadsheet.

all the fields will save in exacl file.

rewards if helpfull

regds,

paras

[Former Member]

no its not working that way

[former_member188827]

which table entries are u trying to save?

are all ur fields checked in the settings...>format list..>choose fields..

and did u save it via..

system..>list..>save..>local file

[kiran_k8]

Sudheer,

You will be able to get the data stored in the table into an excel file but not the table itsefl.

go to se 12

give vbak (for ex)

click on technical settings

press f8

you will get the output

this you can export it to excel file as mentioned in the above threads,but not table itself.

K.Kiran.

[Former Member]

Function module EXCEL_OLE_STANDARD_DAT can be used to start Excel with a new sheet and transfer data from an internal table to the sheet.

[Former Member]

Hi,

Copy all the data from the table to an internal table and call the FM alsm_excel_to_internal_table to download the data from internal table to excel....

Reward points if helpful............

Regards,

Sree.

[Former Member]

hi,

before saving in local file just check your table width.if its 250 then only some fields will come. change it 1250 then all fields will come in local file.

Paras

[Former Member]

yh, iam changing still i cant get the all fields..

thanks

[Former Member]

i did it manually..thanks for all of you guyz n galz if theres any..

closing this thread