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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.