SAP Knowledge Base Article - Public

3799707 - Initial Load ignores Read from Single Client settings when filters/ranges are set - ABAP CDC Engine

Symptom

  • When LTRS filter/range conditions are set for initial load with Reading Type 1 (range calculation), data is read from all source clients even though Read from Single Client is enabled in the configuration.
  • The same table read with Reading Type 5 (sender queue) returns the expected records.

Environment

  • SAP S/4HANA Cloud Public Edition
  • ABAP CDC Engine (Change Data Capture)
  • SAP Landscape Transformation Replication Server (SLT)

Reproducing the Issue

  1. Run LTRS
    1. Add a table in Performance Options:
    2. Set Initial Load Reading Type = 1 (Range Calculation).
    3. Define a range condition (for example: GJAHR >= ‘2017’).
    4. Save.
  2. Run LTRC,
    1. Add the table and perform Initial Load.
    2. Observe inserted records come from multiple clients despite Read from Single Client being enabled.

Cause

This is a known issue. SLT relies on the source system CDC for access plan calculation and for reading data during the data transfer phase. When Read from Single Client is specified, the client of the RFC connection is expected to be used. This indicates that Reading Type 5 is functioning correctly, while records from other clients are being incorrectly returned by Reading Type 1.

Resolution

Implement the note below and try again.

  • 3689719- ABAP Data Integration - Reading type resource optimized does not read any data

See Also

  • 3750235 - The client field "MANDT" cannot be specified in the WHERE condition - SLT
  • 2757098 - How do filters and filter conditions work? - SLT
  • 2581611 - How to configure filters/rules for data replication - SLT
  • 2640259 - Is it possible to change the 'Read from single client' option? - SLT

Keywords

read from single client, initial load, reading type 1, range calculation, resource optimized, reading type 5, sender queue, ltrs filters, filter options, cdc, client field, mandt where condition, multi-client data, slt replication, abap data integration , KBA , BC-DB-CDC , ABAP CDC Engine (Change Data Capture) , Known Error

Product

SAP S/4HANA Cloud Public Edition all versions