Symptom
Personalized data (grouping, sorting, filtering and formatting) in line item reports are not supported in Excel Export functionality.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Apply grouping in apps "Manage Supplier Line items" and "Manage Customer Line Items"
- View the report, where the data is displayed correctly in a grouped format.
- Export the report to Excel.
- Observe that the exported file does not maintain the grouping structure and displays the data in a normal format.
Cause
Standard system behavior.
Resolution
Data for Excel export is fetched from a back end. Therefore, client side grouping, sorting, filtering, and formatting are not supported.
See Also
Refer to: SAP Note 2630594 - SAPUI5 - known limitations for document export in SAPUI5 apps
Refer to: Help Portal Documentation - Manage Customer Line Items App
Keywords
grouped data, excel export, customer, supplier, line item report, public cloud, data grouping issue, SAPUI5, reporting apps, export limitation, grouped format, ungrouped format, data export issue, F0712, F0 712, F0711, F0 711, manage customer line items, manage supplier line items, sorting, filtering , KBA , FI-FIO-AR-IS-2CL , Reporting Apps: Public Cloud , FI-FIO-AP-IS-2CL , Reporting Apps: Public Cloud , Problem
SAP Knowledge Base Article - Public