SAP Knowledge Base Article - Public

2655033 - Number of All Accounts Display Different in Accounts View and Data Workbench Export View


Total number of accounts display in accounts view are lesser then all accounts display in data workbench export view



Reproducing the Issue

  1. Go to the Data Workbench work center
  2. Go to the Exports view
  3. Select an object Account
  4. Click to select on Account
  5. Select the radio button All Data
  6. Click on Next
  7. Total Records: XX (XX is an example of total number of accounts in data workbench work center export view)


  1. Now go to Customers work center
  2. Go to Accounts view 
  3. Select query All
  4. You can see total records: YY (YY is an example of total number of accounts in customers work center accounts view)

Here total number of accounts in accounts view is lesser then export view.


The accounts that appear in accounts view All query, this standard query does not include obsolete accounts. But total account records appear in export view also include obsolete account. This is the reason all accounts records are differ on both views.


This is an expected system behavior.

All accounts records will be same in both view, if filter status obsolete is removed from advance search in accounts view.


All accounts number, Data workbench, export, All data , KBA , number of all accounts , customers , data workbench , export , LOD-CRM-ACC , Account , LOD-CRM-INT-DWB , Data Workbench , How To


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