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

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.

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

1. Log in to the application.
2. Open the Local Table in Data Builder and go to Data Viewer.
3. Apply a DATE range filter (for example, May 1, 2026 – May 31, 2026).
4. Note the record count shown in Data Viewer.
5. Open Data Integration and select the same Local Table.
6. Open Delete Records.
7. Set Deletion Type to Delete Filtered Records.
8. Apply the same DATE range filter.
9. Observe that the Preview shows a different (higher) number of records to be deleted.

• Different handling of date/time in the two features: Data Viewer applies the UI-provided date as UTC timestamps, while Delete Records converts the UI-provided local timezone date to UTC before applying the filter.
• Database behavior difference between literal and parameterized queries on a DATE column: timestamp literals can lead to implicit casting of the DATE column to TIMESTAMP (excluding or including boundary days differently), while parameter binding expects DATE values and may include additional boundary days.

A fix aligning the handling between Data Viewer and Delete Records is planned for Datasphere wave 2026.18.
Refer to the release Note 2984828.

Before the fix is available, consider the workaround to use a DateTime filter in Delete Records:

1. Enter start and end values as DateTime in UTC that exactly correspond to the intended local calendar boundaries (convert local start-of-day and end-of-day to UTC).
2. Re-run the Preview and confirm the count matches the expected result from step 1.

Cross-check in Data Viewer, and proceed with deletion only when the previewed count matches the verified target set.

• Refer to: Controlling Deletion of Local Table Records
• Refer to: Release schedule information

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