SAP Knowledge Base Article - Preview

2556782 - Incorrect Export Results due to Filter in Data Workbench

Symptom

Upon checking the Work center view for any object Z (for example Accounts, Opportunities etc.) via Advanced search, using any filter criteria, there are a total of X records. Your requirement is to export those X records using Data Workbench. Upon exporting the records using Data Workbench, you see Y records.

Example:

We are exporting the Prospects based on the Countries PQR or XYZ.

In Data Workbench workcenter, upon setting the Filter as below, the results are calculated as Y records.
Country – Equals To – PQR
Country – Equals To – XYZ
Role – Equals To - Prospect

You want to understand how to handle the same attributes (Country in my example) in Data Workbench, using the correct filters.

*Z represents the Object in Data Workbench
X represents the total records available in the workcenter view for the Object
Y represents the total records calculated for export in Data Workbench
PQR and XYZ represents the Countries


Read more...

Environment

SAP Cloud for Customer

Product

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

Keywords

Filter in Data Workbench, Selection Criteria in Data Workbench, Filter Condition, Account , KBA , selection criteria in data workbench , filter in data workbench , LOD-CRM-INT-DWB , Data Workbench , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.