Filehost.ro - gazduire fisiere
Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Nou pe simpatie:
Ana Maria 25 pe Simpatie.ro
Femeie
24 ani
Bucuresti
cauta Barbat
35 - 68 ani
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[SAP] Reset ALV Export (disable opening excel in SAP interface)

Pagini: 1 Moderat de TRaP, TonyTzu
#1
TRaP
Moderator
Postari: 960
Source (user Srinivas Chapa):
https://archive.sap.com/discussions/thread/3502043


There are three ways to reset the default download option

TESTED 1) Execute any ALV report on the output screen, just do a right click in the table and choose to export to local file: your default settings will be reset automatically and you get the option of deselecting the option to save implicitly to a file type.


Other options along with the below one  to disable defaults set by the user.

2 )Maintain the table SALV_BS_ADMIN using the report SALV_BS_ADMIN_MAINTAIN.
Note 1080608 - Defining ABAP ALV export format for spreadsheet

3) "&RESET_EXCEL" in the command field to reset the parameter in the ALV list -Note  1157927

Any of the above 3 will work


More detailed info:
https://www.scribd.com/doc/145839264/Ho ... ngs-in-SAP

Method 1:
While in the ALV screen, right click on anywhere inside the ALV grid.If it is an ALV list right click on the blue part.Click spreadsheet.The non-defaulted selection box returns.

But the default box may still be marked, don’t forget to unmark it.
Then you will have the default Export popup again.

Method 2:
While in an ALV screen, enter
“&reset_excel”
without quotes into the command box. This willreset the Export Popup to default settings.

Method 3:
SALV_BS_ADMIN_MAINTAIN seems to be the most reliable solution. I think it's also the mostpainful and not something that I want to tell users as there are transactions involved in this.
Only if the above two methods didn’t work try th
is.The following steps should be performed:- Call transaction SE38, enter program SALV_BS_ADMIN_MAINTAIN, and press F8.- Follow the parameters below:- Select DELETE on the Actions Group- Select DETAILED SELECTION on the General Data:- On Client - your client number- User : <user name>- Hit on EXECUTE.- Press ENTER on the POPUP- If there is an entry in the report that will need to be deleted. Also, make sure that the entryyou will delete (for the user) has a value of GUI_ALV_XML_VER on the field Parameter.- Select the line and hit the DELETE icon.- Press Y to continue delete. Press ENTER on the popup.- Then EXIT all the way out of the program.NOTE: When you run program SALV_BS_ADMIN_MAINTAIN, make sure they are out of anyprogram that they are using for download.


 
   
#2
TRaP
Moderator
Postari: 960
Note that in ALV I had to click on the print preview button (CTRL+SHIFT+F10), then in the transaction code field you insert and hit enter for the following: &RESET_EXCEL

A note should appear at the bottom that "Setting was deleted"


 
   
Pagini: 1