3543361 - Replicating ABAP-based objects that do not have a primary key is only possible for load type "Initial Only" - SAP Datasphere

Replicating ABAP-based objects that do not have a primary key is only possible for load type "Initial Only"

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

• SAP Datasphere as the Target / Subscriber
• ERP / BW / S/4 as the Source / Provider

1. Create Replication Flow in Datasphere
2. Import the source object
3. Switch on 'Delta Capture'

The source object without the primary key is not supported by 'Initial and Delta' mode.

You can use Replication Flow to replicate data from the following source objects:

• CDS views (in ABAP-based SAP systems) that are enabled for extraction

• Objects from ODP providers, such as extractors or SAP BW artifacts (from any SAP system that is based on SAP NetWeaver and has a suitable version of the DMIS add-on, see SAP Note 3412110)

• Tables that have a primary key.

CDS views and ODP artifacts that do not have a primary key can be used as the source for a replication flow if certain prerequisites are met. For more information, see online below:
SAP S/4HANA and Other ABAP Sources for Replication Flows | SAP Help Portal 

"If certain conditions are met, you can use objects that do not have a primary key as the source for a replication flow.

This applies to the following types of source objects:

• CDS views

• ODP data sources (SAPI or BW context) "

Question: How to check key fields of ODP data sources?

Answer:

1. For ODP data sources with ODP_BW context, open the BW InfoProviders in Modeling Tools and check the key information in details tab.
   
   
   
2. For ODP data sources with ODP_SAPI context, open the extractor in T-Code RSA2 and check the key fields. Besides, function model RODPS_REPL_ODP_GET_DETAIL can also be used. See "Question 6" in KBA 3210655.  However, please be aware that:
   • For most of the ODP_SAPI data sources, no primary key is delivered.
   • In old BW world, keys can be manually defined after the they're replicated to BW side;
   • In Datasphere -> Replication Flow -> keys can be manually defined with function 'Configure Schema' as below:
     

• KBA 3210655 - For troubleshooting: usage of ODP program and function modules
• SAP Note 3412110 - SAP Datasphere - ABAP Integration - Improvements for the replication and initial load of ODP data sources

"Initial", Replication, ABAP, primary, key, "Initial Only", DWC , KBA , DS-DI-RF , Replication Flow Runtime , Problem