Removing default selected format

[Former Member]

Hi all,

When I run the report FBL1N, and click on List - Export - Spreadsheet, I get a selection box to choose the format. When I choose a particular format and check the box "Always use selected format", the system always uses the same format to save the exported file.

Now the question is: I want the selection box to choose the format back.

If we go to table "SALV_BS_ADMIN" and delete the entry we can get back the selection box back, but I came to know that there is a programme for the same. Can any body help me with the programme.

Hope I made myself clear with what I am after.

Kevin.

[Former Member]

Replying to this very old post because recent system releases have improved on this.

If you have an ALV grid on display, right-click anywhere in the ALV grid data and choose "spreadsheet" from the shortcut menu. 

The format selection box will be shown even though "always use" is marked.

[Former Member]

This message was moderated.

[Former Member]

Hi,

Just go to the report and right click on application toolbar and select the relevant option to export the report.

This will reset your default settings.

No execution of Program is required though we can fix it through program.

Regards,

Vishnu

[Former Member]

Hi Vishnu,

I execute FBL1N, and by right clicking on the application tool bar, I am unable to get any thing. Can you please explain again please.

Thanks

Kevin

[Former Member]

Hi,

I think that note 1080608 answers this re entries in table SALV_BS_ADMIN

Summary

Symptom

You export data from an ALV version into a format for the spreadsheet:

GUI ALV: as of Release 6.40/Support Package 21 or Release 7.00/Support Package 13

ALV Fullscreen(Grid)/ALV Classic(List): menu option 'List -> Export -> Spreadsheet'

ALV Grid: menu option 'List -> Export -> Spreadsheet'

Currently, supported formats are:

Excel (in MHTML format)

Excel (in MHTML format for 2000/97)

Star Office 8 Calc / OpenOffice.org 2.0 Calc only as of Release 6.40/Support Package 21 and Release 7.00/Support Package 14

Excel (in Office 2003 XML format)

SAP internal XML format

SAP Standard (internal table)

Excel (in previous XXL format)

Web Dynpro ALV: as of Release 7.0

Pushbutton 'Export'

Currently, supported formats are:

Excel (in MHTML format)

Excel (in MHTML format for 2000/97)

You can change this only by using the report SALV_BS_ADMIN_MAINTAIN. You cannot select which format you want to use. The default value is Excel (in MHTML format).

In general, the format into which the data is to be exported can be specified at user level or at client level. It can be specified as follows:

GUI ALV:

a) At user level:

In the dialog box 'Select Spreadsheet',

set the indicator 'Always Use Selected Format' (creating an entry in the table SALV_BS_ADMIN),

or

Maintain the table SALV_BS_ADMIN using the report SALV_BS_ADMIN_MAINTAIN.

b) At client level:

Maintain the table SALV_BS_ADMIN using the report SALV_BS_ADMIN_MAINTAIN.

Web Dynpro ALV:

a) At user level:

Maintain the table SALV_BS_ADMIN using the report SALV_BS_ADMIN_MAINTAIN.

b) At client level:

Maintain the table SALV_BS_ADMIN using the report SALV_BS_ADMIN_MAINTAIN.

The entries in the table SALV_BS_ADMIN for individual users generally have priority over those at client level.

In the GUI ALV, an entry in the table SALV_BS_ADMIN means that you skip the dialog box 'Select Spreadsheet' and you directly go to the screen where you save the file. In the context menu of the list, choose 'Spreadsheet' so that the system displays the dialog box 'Select Spreadsheet' again for the export.

The entry in the table SALV_BS_ADMIN is also deleted,

which otherwise is only possible using report SALV_BS_ADMIN_MAINTAIN.

In addition, the system opens the dialog box and the indicator 'Always Use Selected Format' is not set.

In general, the identical dialog boxes can only be provided in two cases. Calling it using the menu is used for creation,

calling it nusing the context menu is used for deletion.

In the ALV list display, you can use Note 1157927 to enter the function code "&RESET_EXCEL" in the command field to reset the parameter in the ALV list. As a workaround to Note 1157927, you can either execute the application with an ALV Grid, or you can use the report SALV_BS_ADMIN_MAINTAIN to remove the entry.

In the Web Dynpro ALV, the system automatically exports the data into Excel (in MHTML format) if there is no entry in the table SALV_BS_ADMIN. You can make changes only using the report SALV_BS_ADMIN_MAINTAIN.

Comments about the report SALV_BS_ADMIN_MAINTAIN:

In general, you can maintain only one parameter (either for each user and client, cross-client or for all clients):

1. Specify whether you want to display, create, change, or delete the entries in the table.

2. Specify whether you want to make the specification for the entire client or for an individual user. Make the relevant specifications in the area 'General Data'. In this area, set the indicator 'All' if you want to maintain the parameter for all the clients.

3. As of Release 7.0, the parameter 'ALV_Webdynpro' also exists for specifying the ALV version in addition to the parameter 'ALV_GUI'. Specify for which ALV version the specification is to be valid. Make the relevant specifications in the area 'ALV Data'.

Comment: The indicator 'All' is available only in display mode and in delete mode.

4. Execute the report.

Other terms

ABAP, ALV

Export:

SALV_BS_ADMIN, SALV_BS_ADMIN_MAINTAIN

Export: XML format, settings

Thanks

Aravind