SAP Knowledge Base Article - Public

3725423 - Personalized data (grouping, sorting, filtering and formatting) in customer, supplier line item reports are not supported in Excel Export functionality - SAP S/4HANA Cloud Public Edition

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

  1. Apply grouping in apps "Manage Supplier Line items" and "Manage Customer Line Items"
  2. View the report, where the data is displayed correctly in a grouped format.
  3. Export the report to Excel.
  4. 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

Product

SAP S/4HANA Cloud Public Edition all versions