The recommended approach for delta extraction from SAP S/4HANA Cloud to SAP BW/4HANA is using an ABAP CDS View with Change Data Capture (CDC). ABAP CDS Views are the standard technology for data extraction in S/4HANA. The CDC mechanism is the most robust delta method as it uses a logging-based approach to reliably track all data modifications, including inserts, updates, and, crucially, deletions. This overcomes the limitations of a simple timestamp-based delta, which cannot capture deleted records. For synchronizing critical data like a customer table, ensuring all changes are captured is paramount, making CDC the superior and officially recommended solution.

A. Transaction RSO2 is a legacy tool for creating generic DataSources and is not the recommended or standard method for custom extractions in SAP S/4HANA Cloud, which prioritizes the ABAP CDS View framework.

B. The delta mechanism for ABAP CDS Views is defined declaratively using specific annotations. Implementing a custom procedure to generate the delta is not the standard or recommended approach.

C. While a generic delta based on a timestamp is possible with CDS Views, it is a less robust method. It cannot capture record deletions and may miss rapid, subsequent updates within the same timestamp resolution.

1. SAP Help Portal

ABAP Platform on SAP BTP

"Enabling ABAP CDS Views for Data Extraction": This document outlines the different delta mechanisms for CDS Views. It describes Change Data Capture (CDC) as the mechanism that "records all data changes (inserts

updates

deletes) in a database table in the source system

" highlighting its ability to capture deletions

which a simple byElement (timestamp) delta cannot.

2. SAP Note 2830590 - ODP-CDS: Recommendations and Restrictions for Delta Extraction: This official SAP Note provides best practices. It explicitly states

"For transactional data

it is recommended to use the CDC delta mechanism because it can handle deleted records and ensures that no data changes are lost." A customer table

while master data

requires the same level of transactional integrity for changes.

3. SAP Help Portal

SAP BW/4HANA

"Transferring Data from ABAP CDS Views": This documentation details the integration between S/4HANA and BW/4HANA. It presents the ODP-CDS context and explains that for delta-enabled CDS views

the "Change Data Capture" (CDC) mechanism is a key feature for reliable data replication

reinforcing it as the strategic choice.