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

You can use replication flows to copy 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 Using an Object Without Primary Key As the Source.

"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 artifacts

The objects must have load type Initial Only. (Delta loading is not supported.)"

Q: How to check key fields of ODP artifacts/extractor?

A: For ODP artifacts/extractors with ODP_BW context, open the BW InfoProviders in Modeling Tools and check the key information in details tab.

For ODP artifacts/extractors 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.

• 3210655 - For troubleshooting: usage of ODP program and function modules
• 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 Flows , Problem