Symptom
When exporting a large dataset using the “All Data” option in Data Workbench (DWB), the UI shows a total count (e.g., 10 records), but the actual exported file Excel contains significantly fewer rows (e.g. 6)
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data workbench.
- Select export.
- Select standard object.
- Search for Maintenance Plan Items.
- Check all data.
- Click in export.
Cause
During the export process, DWB identifies and removes entries with the same ObjectID to prevent duplicate records from appearing in the output file. As a result, the final number of exported records may be lower than the total count shown in the UI or initial preview.
Resolution
This is an expected behavior and is part of DWB's logic to ensure data integrity by avoiding redundant records in the exported file.
Keywords
Data Workbench; DWB; Export fewer records; Duplicate ObjectID; Export count mismatch; DWB export less than expected; Record count discrepancy; C4C data export; DWB All Data; Export duplicates removed; Multiple entries same ObjectID; DWB missing rows; Data loss during export; Inconsistent export count; C4C DWB logic; DWB export limit; Clean data export; Data Workbench file incomplete , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem