3503665 - CDS Views with AMDP as Source Do Not Support Delta in Replication Flow - SAP Datasphere

When a CDS view from the source system (e.g. SAP S/4HANA) contains an ABAP Managed Database Procedure (AMDP) in its definition, or in dependent CDS views, and is used as the source object in a replication flow in SAP Datasphere, the replication settings only offer Initial Load.

• The Delta extraction option is not available.
• In ODQMON (T-Code) of the source system, the following error may also appear: "CDS views that use ABAP Managed Database Procedures are not supported.”
• If you try to enable "Delta Capture" option in Datasphere, there's popup message: "The source object does not support delta capture." 

SAP Datasphere

1. In SAP Datasphere, create a replication flow.
2. Select a CDS view from the source system as the source object. The CDS view either directly contains AMDP in its definition or references other CDS views that use AMDP.
3. In the replication flow settings, only Initial Load is shown. Delta or Initial & Delta extraction is not available.

• CDS views with AMDP in their definition stack are not delta-enabled in the source system.
• Because delta logic cannot be generated, Datasphere replication flow cannot expose the Delta option.

• CDS views with AMDP are only supported for Initial load in Datasphere replication flows. Delta extraction is not supported.
• If delta is required:
  • Use an alternative CDS view that does not depend on AMDP.
  • Redesign the source data model so that a delta-enabled CDS view can be consumed in Datasphere.

• 2511210 - Access to ABAP-Managed Database Objects
• 3541755 - Delta Initialization: CDS views that use ABAP Managed Database Procedures are not supported

AMDP, Replication Flow, Datasphere, initial & delta , KBA , DS-DI-RF , Replication Flow Runtime , BW-WHM-DBA-ODA , Operational Data Provider for ABAP CDS, HANA & BW , BC-DB-CDC , ABAP CDC Engine (Change Data Capture) , Problem