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
- Navigate to the "Display Actual Costing Result" app.
- Filter material field using parameter like Number and asterisk, for example "1*".
- Select the "Cost Component Split" tab.
- Attempt to export the report to Excel using the "Custom Export" option with "Cost Component in Columns".
- 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
SAP Knowledge Base Article - Public