SAP about the standard ALV Report export Excel problems and solutions: long numbers
Description: When using standard ALV function, local files can be used to guide the content to Excel in
question: If you have a field in your report that looks like a long number such as a bank account or a social Security number, export Excel directly , in Excel These fields will be displayed in a format that uses scientific notation to cause this column of data to be incorrect.
Workaround one: Select the format that is not converted when exporting, and then defragment it (in columns)
Workaround two: Use the ALV toolbar button in Excel appropriate location
Workaround three: Export-spreadsheet-All available formats (select "In Existing XXL format")
ALV How do I choose to export a spreadsheet with a fixed file format?
Phenomenon: In the ALV display, when you select Menu "List-Export-spreadsheet", the following selection window appears:
If always use selected format is selected, the currently selected format (often the first MHTML, which you actually want to export as a traditional EXCEL file) will be used in the future, and the dialog box to save the file directly appears and cannot be selected again.
Workaround:
Through the tracking statement, found the table salv_bs_admin, do the above, will be inserted into this table a record, record user selection. If you want the Select Format window to appear again, simply delete the record using the following statement.
DELETE from Salv_bs_admin
WHERE OBJECT = ' Gui_alv_xml_ver '
and M_user = ' <username> '.
OBJECT is a fixed constant, M_user is the login user name, and both of them make up the primary key of the table.
SAP about the standard ALV Report export Excel problems and solutions: long numbers