Solution : https://service.sap.com/sap/support/notes/358644 (SAP Service marketplace login required)
Summary :
This SAP Note covers multiple export methods of ALV data to Excel, detailing the XXL interface, local file export in spreadsheet format, and Excel Inplace functionalities. Highlighted are enhancements with XML and the introduction of "Select Spreadsheet" dialog to customize default settings. It addresses specific issues such as date and currency display, column sorting, and icons representation in Excel. Technical limitations like unsupported deep structures during export and function code exclusivity are noted. Recommendations for correct Excel exports are provided, with references to related SAP Notes for further configurations or issues.
Key words :
customer component bc-srv-alv sap list viewer priority recommendations / additional info category consulting validity, filter sorting control break totals column arrangement conversion exits currency formats icons, views --> microsoft excel strl+shift+f7 alv grid class, list->export->local file->spreadsheet alv grid class, list->export->spreadsheet alv grid class, __%pdfstyle%__ / } symptom generally, terms sap list viewerexcelexport, icon views --> excel inplace note, path list->export->spreadsheet, software component version references
Related Notes :
| 764272 | XXL: special visualisations/conversions are not retained |
| 540779 | FAQ: Information system |
| 316814 | ALV Export Excel: Switching date in ALV with Excel download |