SAP Knowledge Base Article - Public

3803186 - Incorrect or missing delta updates in local table when replicating BW/4HANA aDSO via ABAP ODP Replication Flow

Symptom

  • Incorrect or missing data updates in the local table when loading from a BW/4HANA aDSO via ABAP ODP Replication Flow
  • The local table view does not reflect the BW aDSO view
  • For reporting, active data of the aDSO is expected, but the target shows change log-like data

Environment

  • Product: SAP S/4HANA Cloud Public Edition
  • Data Intelligence - ABAP Integration

Reproducing the Issue

  1. Delete data in the BW aDSO.
  2. Delete data in the local table in Datasphere.
  3. Load initial data into the BW aDSO.
  4. Run the Replication Flow in Datasphere.
  5. Compare initial data between BW and Datasphere.
  6. Load delta data into the BW aDSO.
  7. Wait for the Replication Flow delta replication to complete.
  8. Compare delta data between BW and Datasphere.

Cause

  • The ODP source container was not represented in a flat form (for example, reported as /ODP_BW/ instead of /ODP_BW). Because of this, the delta opcode correction in the Replication Flow merge did not apply, leading to incorrect handling of before/after images and resulting in wrong or missing updates in the local table.

Resolution

  1. In the ABAP source system, implement SAP Note 3596322 to enable a flat representation of ODP objects so the container is reported as /ODP_BW.
  2. Restart the Replication Flow to ensure a new ODP subscription is created with the corrected container representation.
  3. Re-run the initial and delta loads and verify that the local table now reflects the active data of the aDSO.
  4. If delta scheduling shows waiting or RT behavior, additionally ensure SAP Note 3701843 is implemented (disables the Real-Time flag for ODP subscriptions) and recreate the subscription.
  5. As prerequisites and stability improvements, ensure relevant ABAP integration notes are implemented per Note Analyzer guidance, including SAP Note 3691739 and SAP Note 3750620 where applicable.

See Also

Keywords

Datasphere, Replication Flow, ODP_BW, BW/4HANA aDSO, delta, before-image, after-image, merge, incorrect updates, missing records, local table, delta capture, ODQ, Real-Time flag, flat representation , KBA , DS-DI-RF , Replication Flow Runtime , CA-DI-IS-ABA , Data Intelligence - ABAP Integration , DS-DI-ABA , Datasphere - Data Flow / Replication Flow ABAP Integration , Problem

Product

SAP S/4HANA Cloud Public Edition all versions