Question Re: Export data in to Excel in Technology Q&A

Export data in to Excel

Former Member — Fri, 13 Oct 2006 11:42:23 GMT

Hi,

I have created one profile with a TC MM60 and assigned one user. This TC can run the particular user. But there is no option for downloading / exporting the data to Excel. How can I do this.

Please help

Regards

Kariyath

Re: Export data in to Excel

Former Member — Fri, 13 Oct 2006 12:04:16 GMT

Kariyath

Execute transaction

Click System (from top menu) > List > SAve > Local file

Save list in file spreadsheet, green tick, save path and file name then generate.

Re: Export data in to Excel

Former Member — Fri, 13 Oct 2006 12:06:13 GMT

please try

system list save as spreadsheet.

Hope it works

Re: Export data in to Excel

Former Member — Fri, 13 Oct 2006 12:33:12 GMT

Hi,

Both option are not there or it is not enbled.

Thanks and regards

Kariyath

Re: Export data in to Excel

Former Member — Fri, 13 Oct 2006 12:38:06 GMT

It maybe an authorisation issue. (try typing /nsu53 in the transaction)

What transaction are you running?

I tried it on MM60, as it was mentioned in your first post, and it works for me, although I am aware it is not available for all transactions.

Re: Export data in to Excel

Former Member — Fri, 13 Oct 2006 12:38:54 GMT

Is it Not there or NOT ENABLED...? it shd be either one..

Also as its SAP standard menu in the top you shd contain the following.

<b>LIST EDIT GOTO SYSTEM HELP</b>

In this list Please go to SYSTEM and proceed as Barry has already mentioned.

I would be amazed if its disabled...;) wondering how in SAP can that be possible

Br,

Sri

Re: Export data in to Excel

Former Member — Fri, 13 Oct 2006 15:42:54 GMT

Hello kariyath,

it seems that you don't have authorization for authorization object s_gui. just add it to your profile with value 61 and then after a fresh logon try to see if you are able to download the data. may be you can also give yourself authorization for s_layo_alv.

please award points for useful info.

Regards.

Ruchit.

Re: Export data in to Excel

Former Member — Sat, 14 Oct 2006 12:47:26 GMT

Hi Ruchit,

Thanks, its solved. tell me what is the use of s_layo_alv?

waiting your reply,

regards

Kariyath

Re: Export data in to Excel

Former Member — Sat, 14 Oct 2006 14:13:02 GMT

Hi Kariyath,

First of all i am sorry the name of authorization

object is S_ALV_LAYO. This authorization object help in maintaining ALV layouts which includes exporting ALV outputs. Noramlly I prefer to give authorizations for S_GUI and S_ALV_LAYO both. S_ALV_LAYO is not related to this issue but it is sometimes useful to give users authorizations for it on your own.

I hope it makes it clear.

Please get back in case of any issues.

Regards.

Ruchit.

Re: Export data in to Excel

former_member100396 — Tue, 25 May 2010 22:06:32 GMT

Hi Ruchit

I have this issue with only one custom report. The option List~~>export~~>Spreadsheet is disabled. there are other reports for which the option is enabled. (custom as well as standard)

How do i check whether I have the correct value for S_GUI.?if its an authorization issue can this be program specific.

Re: Export data in to Excel

Former Member — Wed, 26 May 2010 05:01:31 GMT

Hi,

As per my knowledge this is purely related with the custom report only. Might be the export is not provided for this custom report. Kindly check with ABAPER and ask them to enable the same for this program too.

Regards,

Sharath

Re: Export data in to Excel

Former Member — Wed, 26 May 2010 05:06:01 GMT

Please, confirm the version of your excel. If it is Office 2007 then first you need to upgrade your SAP GUI 710 with patch level 14 and try. It will work.

Thanks and Regards,

Kedar

Re: Export data in to Excel

Former Member — Mon, 26 Mar 2012 10:05:04 GMT

Hi,

I want to export SLG1 logs to excel sheet for tracking purpose, but I am not granted access to S_GUI.
Is there any other alternative.

Regards
Suhas