SAP about the standard ALV Report export Excel problems and solutions: long numbers

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