SAP Knowledge Base Article - Preview

3792111 - Record count mismatch between data viewer and delete records preview when filtering by date range

Symptom

Record count discrepancy between Data Viewer and Delete Records Preview when applying the same DATE filter.

E.g: Data Viewer shows 1 records for DATE = May 1, 2026 – May 31, 2026, while Delete Records Preview shows 2 records for the same DATE filter.


Read more...

Environment

  • Product: SAP Datasphere
  • Table Persistency: Local Table (Delta Capture = OFF)

Product

SAP Datasphere all versions

Keywords

datasphere, local table, delete records, data integration monitor, data viewer, record count mismatch, date filter, timezone, utc conversion, parameter binding, literal vs parameterized, hana implicit type casting, between clause, delta capture off, safe deletion , KBA , DS-DI-TAB , Table Persistency , 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.