3587890 - Replication Flow: 0UC_SALES_STATS_03 is only possible for initial only

• The Datasource 0UC_SALES_STATS_03, which is ODP enabled datasource. It is not possible to initialize a Delta from DataSphere.
• The issue arises when changing load type to Initial:
  • Replicating ABAP-based objects that do not have a primary key is only possible for load type "Initial Only".

• IS-U as a source system
• SAP DataSphere as a target / subscriber

1. Attempt to initialize a Delta for Datasource 0UC_SALES_STATS_03 in SAP Datasphere.
2. Observe that the initialization fails due to the lack of a primary key.

The issue arises due to the lack of a primary key in the ABAP-based objects that are being replicated. This prevents the initialization of a Delta.

Use the new datasource 0UC_SALES_SIMU_04 which's delivered in SAP Note 3473213 - "SAP Datasphere integration of IS-U sales statistics and mass simulation for IS-U unbilled revenue reporting".

In this datasource, a new field PRIMARYKEY is defined as its key field. This can be seen in table ROOSFIELD:

OLTPSOURCE    0UC_SALES_STATS_04
OBJVERS       A
FIELD         PRIMARYKEY

NOTEXREL      Y
KEYFLAG DS    X  <-----

In DDIC table DD03L,  this field PRIMARYKEY has a rollname PRIMARYKEY:

TABNAME        BIW_ISU_ESTA
FIELDNAME      PRIMARYKEY
KEYFLAG
MANDATORY
ROLLNAME       PRIMARYKEY  <----

With this property, ODP Function module RODPS_REPL_ODP_GET_DETAIL will return field PRIMARYKEY as as the primary key:

se37 -> RODPS_REPL_ODP_GET_DETAIL

I_SUBSCRIBER_TYPE        SAP_BW
I_CONTEXT                      SAPI
I_ODPNAME                     0UC_SALES_STATS_04

NAME                TYPE       LENGTH DECIMA OUTPUT K  DESCRIPTION
PRIMARYKEY      CHAR       000022 000000 000022  X  Primary Key  <-- 

• SAP Note 3527268 - "SAP Datasphere - ABAP Integration - Initial load of CDS Views without key fields fails"
• SAP Note 3473213 - "SAP Datasphere integration of IS-U sales statistics and mass simulation for IS-U unbilled revenue reporting"

SAP Datasphere, Datasource 0UC_SALES_STATS_03, ODP capable, Initialize Delta, ABAP-based objects, lack of primary key, Replication Flows, SAP Note 3527268, SAP Note 3473213. , KBA , DS-DI-RF , Replication Flows , Problem