SAP Knowledge Base Article - Public

3709128 - Blank Excel File when downloading from App "Display Actual Costing Result" - SAP S/4HANA Cloud Public Edition

Symptom

When filtering the materials using parameter like Number and asterisk, for example "1*", the export file from the 'Cost Component split' tab is empty. 

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Navigate to the "Display Actual Costing Result" app.
  2. Filter material field using parameter like Number and asterisk, for example "1*". 
  3. Select the "Cost Component Split" tab.
  4. Attempt to export the report to Excel using the "Custom Export" option with "Cost Component in Columns".
  5. Observe that the export process completes immediately, but the resulting Excel file is empty.

Cause

When using material pattern like(CP) such as "1*", it will not work from backend data extraction. 
Only option equal(EQ) supported, so if we iteratively use 10100001, 10100002, 10100003, 10100005, this export will work. 

Resolution

The workaround about multiple conditions selection is to add pattern in search help of filter, it allows select up to 200 conditions with one click(Select All). 

Keywords

cost component split, display actual costing result, export to excel, custom export, cost component in columns, empty excel file, empty, SAP S/4HANA Cloud Public Edition, actual costing , KBA , CO-PC-ACT-2CL , Actual Costing (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions