cancel
Showing results for 
Search instead for 
Did you mean: 

SAP offers the possibility to make from transaction FAGLB03 a download

Former Member
0 Kudos

Hello gurus,

SAP offers the possibility to make from transaction FAGLB03 at item level a download to excel with: List / Export / Spreadsheet.

However, in version SAP 6.0, the first time you enter this path a radio button is showed with 3 options. Below those options, there is a flag named 'Always use selected format'.

By selecting this flag, every time you try to download to excel no possibilities are given. SAP starts the donwload in the format you selected when you marked the 'Always use' flag.

Strange thing is that if I log-in to the system from a different laptop then no format is automatically selected --> it seams like SAP saved some parameter only in my laptop?

How can I delete this 'Always use' option I selected the first time I downloaded the FAGLB03 at item level to excel? I would like to be asked for the format every time I download these items.

Many thanks,

Marc

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

After running the report, RIGHT click on any line item and select spreadsheet, You will see the same screen from LIST>EXPORT>SPREADSHEET. Clear all the selections and continue. Try the LIST>EXPORt option after that.

Former Member
0 Kudos

Hello

I have done so but after selecting spreadsheet no option are displayed. SAP goes directly to a pop up for the download asking me for the name and directory in which I want to save the file.

Should I delete all the files contained in the defaulted folder named SapWorkDir?

Thanks!!