3571813 - Deleted records from source system are not deleted from datasphere table when real time replicated

When consuming a CDS view with automatic CDC as remote table using real-time replication. The deleted records from the source system is not deleted form the datasphere table.

SAP Datasphere

Deleted records from source system are not deleted from table with real time replication enabled.

1. The issue arises due to the maintenance of a filter for a non-key field. When records are deleted, they are written with only values of key fields with ODQ_CHANGEMODE as D. There are no values passed for non-key fields.
2. If a filter is applied on a non-key field, the records will not be fetched because that field is initial in ODQMON.

1. This is explained in note 2930269 under the question "How the deleted record looks like during delta load?"
2. To resolve this issue, either remove the filter in this case or maintain a filter on a key field to get the deletions.

KBA , DS-DI-RT , Remote Tables , Problem