Skip to Content
Actions

How to bring back different download options from SAP to Excel?

September 20, 2013 | 3,871 Views |
 enterprise resource planningsap erp financials
Follow
There is an option that number of list reports (for example S_ALR_87009712) can be downloaded into excel. When we are exporting such reports to excel, you will find a check box called “Always use selected format”. Once you have selected this check box, then this will be saved in the buffer for that user. The user will miss an option to download the report in other available formats. There is no clue how this can be cancelled. Following tip would help you bring back the available option (provided you have sufficient authorisation). Otherwise, you will need to contact the users who have the authorisation to do this for you.
File 1.png
You will have different options how you can download your report into excel file. However, there is a check box called “Always Use Selected Format”. If you have inadvertently selected this check box, from the next time, the report can only be selected with said following excel format that you have selected. Other options are not available in future and the report will be downloaded in default way to this format. Furthermore, the system will not give you any popup to select other options.
File 2.png
In such cases, there is an option to delete the “Always Use Selected Format” entries that are buffered, so that next time when you are downloading, as usual, the system will give you a pop up to select the relevant option. For doing this, you should have access to transaction codes SE38 or SA38
transaction codes (mostly given to the developers only). If you do not have access or unable to get the access, you should request the users / consultants who have access to delete the buffered entries for your user ID.

You need to go to transaction code SA38.

Please enter the program name “SALV_BS_ADMIN_MAINTAIN”
File 3.png

Click on “Execute” button

File 4.png
Please select “Delete” if you want to deleted “Change” in order to “Change” the buffer entries. It is preferred to selected “Delete” button, as we are intended to delete the buffer entries already saved. Pleas enter the Client Name and User Name in the “General Data Selection” In “ALV Data” context area, please keep as defaulted.
File 5.png
You will get an information box as shown above, click on “OK” (Green Tick Mark)

Please select the entry and click on “delete” button.
File 6.png
You will get the following pop-up box, please click on “Y” for “yes”
File 7.png

You will get a message as mentioned below:

*Action successfully completed”

Now again when you go back to the report in order to export the line items to excel, you will get your pop-up back in order select the required download excel option.

File 8.png
To report this post you need to login first.

28 Comments

You must be Logged on to comment or reply to a post.

  2. John Graver

    There is a bit easier way, available also to users that don’t have the authorization for SA38:

    1. Rightclick to any part of a report area and from the context menu choose “Spreadsheet“.
    2. The standard “Select spreadsheet” dialog appears as shown on pic. #2 in the article. Here you can select desired document type and uncheck the option “Always use selected format“.
    (1) 
  4. Eduardo Rezende

    Hi Ravi,I got a different screen for my 702SP12 test system but using the “User-Specific Settings for SAP GUI ALV” I could delete the entry and select a new spreadsheet option.

    Thanks for sharing!

    (0) 
  7. Gaurang Gujar

    Hi Ravi,

    There is one more simple and tricky way.

    Click on Select all–> Right Click->Spread Sheet and UnCheck the option “Always use selected”

    Regards,

    Gaurang

    (1) 
  8. CA. Prasad Atmakuri

    Thanks Ravi for teaching a new concept …  i guess we don’t have to attend any trainings reading your blogs and following SCN would be more than enough 😉

    Thanks John Graver  for providing alternate way 🙂

    Regards

    Prasad

    (0) 
    1. Pankaj Bansal

      HI Erwin,

      Run any report like FAGLL03–>

      In output screen right click on any record–>

      Click “Spreadsheet”

      In pop up windows, “deselect” “Always Use selected format”

      next time you will try to export any data system will show all available options.

      BR

      Pankaj Bansal

      (0) 

Leave a Reply