topic How to extract data from table in Application Development and Automation Discussions

How to extract data from table

laxman_sankhla3 — Wed, 06 Jun 2007 05:57:18 GMT

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

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 05:58:30 GMT

Hi Laxman,

Use GUI_DOWNLOAD for the same.

Regards,

Atish

Re: How to extract data from table

laxman_sankhla3 — Wed, 06 Jun 2007 05:59:51 GMT

Hi Atish

Thansk for ur reply

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

Regards

Laxman

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 06:00:15 GMT

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

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 06:02:01 GMT

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

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 06:02:44 GMT

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

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 06:04:19 GMT

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.

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 06:04:42 GMT

use from WS_EXCEL.

regards

Prabhu

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 06:04:53 GMT

HI,

You can Donwload the data from SM30 transaction code,

Regards

Sudheer

Re: How to extract data from table

laxman_sankhla3 — Wed, 06 Jun 2007 06:05:56 GMT

in ekpo table 30,000 entries.

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

how can it possible.

thanks .

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 06:06:10 GMT

please use FM WS_EXCEL.

regards

prabhu

Re: How to extract data from table

Former Member — Wed, 06 Jun 2007 06:14:05 GMT

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.