3049006 - Mismatch Number of Records When Exporting Data From Data Workbench to The Records in The System.

You apply the filter combining the following status:

1. Not Equal to Closed
2. Not Equal to Canceled
3. Not Equal to Completed

When exporting data using Data Workbench, you notice that the count is not consistent with the count in the object view with the same filter as shown above.

SAP Cloud for Customer

1. Go to Service workcenter
2. Select the Tickets view
3. Apply advanced Filter with filter:  = !(=Closed; =Completed; =Canceled)
4. Check Number of Records

Now

1. Go to Data Workbench workcenter
2. Select Export
3. Select Service Request object
4. Apply the Selection Conditions:  Service Request.Status Code != AB - Canceled OR Service Request.Status Code != 6 - Closed OR Service Request.Status Code != 5 - Completed
5. Compare Number of Records

You will notice the number of records is not the same in the above two situations.

Through DWB, using multiple 'Not Equal to' filters with same property but different values is not supported. Its not meaningful for the database fetch and it will give incorrect results.

In user interface, fetch with 'Not Equal to' is handled differently, this is the reason of the deviating results.

Please use the Selection Condition 'Is Any Of' with selecting all the Status which you want to include.

SAP KBA 2377787 - Ticket Missing In The UI

mismatch wrong number DWB , KBA , LOD-CRM-INT-API , OData API (C4C Only) , LOD-CRM-SRP , Service Request Processing , LOD-CRM-SRP-API , Ticket API & Odata , Problem

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions