How to extract data from table

[laxman_sankhla3]

Hi

I want to export all the data present in the table to an excel sheet.

I know that we can export from

menu bar

system> List> save>Local file> spread sheet to local system

But by doing that only some data is being downloaded but i want the whole data present in that table. I had extended the width to maximum but the total entries are more than the width i want that data also to be downloaded into the local system

Points will be rewarded surely

Regards

Laxman

[laxman_sankhla3]

Hi

I want to export all the data present in the table to an excel sheet.

I know that we can export from

menu bar

system> List> save>Local file> spread sheet to local system

But by doing that only some data is being downloaded but i want the whole data present in that table. I had extended the width to maximum but the total entries are more than the width i want that data also to be downloaded into the local system

Points will be rewarded surely

Regards

Laxman

[Former Member]

Hi Laxman,

Use GUI_DOWNLOAD for the same.

Regards,

Atish

[laxman_sankhla3]

Hi Atish

Thansk for ur reply

How?????// can u explain in clear

Regards

Laxman

[Former Member]

please use FM WS_EXCEL.

regards

prabhu

[Former Member]

Hi,

increase the width of the output

in selecting the data itself

and then download in to local file

then it will work

as it worked in my case

thanks

venkatesh

[Former Member]

Have tried option

Menu Path Edit-> download -> spreadshet

and

have you removed value in maximum no. hits field, by default it value is 200

Message was edited by:

Saida Rao Devarasetty

[laxman_sankhla3]

hi

in ekpo table 30,000 entries.

i want to extract all 30,000 entris from ekpo.

how can it possible.

thanks .

[Former Member]

go to se16,

give ekpo,

download to excel sheet(there is option in se16 to downlaod toexcel sheet.)

reward for all helpful answers.

regards,

seshu.

[Former Member]

Hi,

define an internal table of type stanadrd table. select all the data and append to internal table and use FM GUI_DOWNLOAD

Regards,

Naveen

[Former Member]

hi laxman,

go to <b>se16</b>,

there u can provide your table,

thne there is option to downlaod to excel sheet.

it works for <b>data base table</b>.

regards,

seshu.

[Former Member]

use from WS_EXCEL.

regards

Prabhu

[Former Member]

HI,

You can Donwload the data from SM30 transaction code,

Regards

Sudheer