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.
Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.
Nou pe simpatie:
deiutza20
Femeie
21 ani
Bacau
cauta Barbat
21 - 44 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [SAP] Reset ALV Export (disable opening excel in SAP interface) Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 748
Source (user Srinivas Chapa):


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:

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.

Modificat de TRaP (acum 6 ani)


pus acum 6 ani
   
TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 748
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"

Modificat de TRaP (acum 6 ani)


pus acum 6 ani
   
Pagini: 1  

Mergi la