3571736 - CDC Error in ZCDS_PRCD_ELEMENTS DSP with SAP HANA smart data integration

• An issue arises when consuming a CDS view originating in the PRCD_ELEMENTS table with automatic CDC in SAP HANA smart data integration using real-time replication.
• Cases have been found where a condition has not been deleted from a document in SAP HANA smart data integration, however, the same CDS view in S4 has the correct conditions and the expected condition has been deleted.
• For example, KNUMV = '0006603947', KPOSN= '001303'. In SAP HANA smart data integration, the condition ZDCC is present, however, in S4 that same view no longer has that condition.

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.

CDC Error, SAP HANA smart data integration, real-time replication, filter, non-key field, ODQ_CHANGEMODE, ODQMON, note 2930269, deleted record, delta load. , KBA , DS-DI-RT , Remote Tables , Problem