SAP Knowledge Base Article - Public

3807062 - Integrate ODP_SAPI CAR extractors using replication flow - SAP Datasphere Data Integration ABAP

Symptom

It is unclear how to extract CAR extractors in the replication flow.

  • 0RT_PA_TRAN_CONTROL         POS Analytics: Sales Transactions and Test Transactions
    0RT_PA_TRAN_GDS_MOV        POS Analytics: Goods Movements
    0RT_PA_TRAN_LOYALTY           POS Analytics: Loyalty Program
    0RT_PA_TRAN_MOV_FIN         POS Analytics: Financial Transactions
    0RT_PA_TRAN_TOTALS             POS Analytics: Totals Records
  • *RT_PA_TRAN*

Several errors occurred during the creation of the replication flow. 

  • The load type "Delta only" is not supported for target.
  • Replicating ABAP-based objects that do not have a primary key is not possible for this load type. 

Environment

  • SAP Datasphere
  • SAP S/4HANA 

Reproducing the Issue

  1. Attempt to create a replication flow in the Datasphere tenant.
  2. Select CAR extractor *RT_PA_TRAN* as the source replication object. 
  3. Observer the error message.

Cause

  • CAR extractors only support Init without Data Transfer and Delta mode.
  • The relevant data sources do not have primary keys defined on the ABAP system. 

Resolution

  1. Refer to the online document below and select a Connection Type that supports Delta Only as the target.   
    *Due to the limitations of CAR extractors, integration is not possible for targets that do not support Delta Only.
    Select Source and Target Connections for Replication Flows | SAP Help Portal 
  2. Use the program ROSOA_CHANGE_KEY mentioned in SAP Note 1677278 to define the primary key for the corresponding data sources on the source system.

See Also

Select Source and Target Connections for Replication Flows | SAP Help Portal 

1677278 - DataSource: Changing the key definition (A version)

Keywords

Replication flow, Datasphere, CAR extractor, RT_PA_TRAN_CONTROL, RT_PA_TRAN, Delta only, primary key , KBA , DS-DI-ABA , Datasphere - Data Flow / Replication Flow ABAP Integration , Problem

Product

SAP Datasphere all versions