3746275 - Replication Flow: 0HR_PT_2 missing records with Initial+Delta mode due to insufficient primary key - SAP Datasphere

• Initial load completes successfully using a PSA-like primary key.
• When running Initial + Delta in Replication Flow from an ABAP ODP_SAPI source, some rows are missing in the target.
• Comparison with the source shows multiple distinct rows (for example differing by cost center) are combined into one because the proposed key (for example employee, day, reporting time type) is insufficient.
• Guidance is needed on the correct primary key for Initial + Delta.

Read more...

• SAP Datasphere as the subscriber
• ECC or S/4HANA as the provider

SAP Datasphere all versions ; SAP ERP Central Component all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

initial+delta, replication flow, odp_sapi, missing rows, primary key, additive processing, upsert, overwrite, cost center, unit as key, 0HR_PT_2, abap extractor, rsa3 comparison, datasphere, delta load , KBA , DS-DI-RF , Replication Flow Runtime , BW-BCT-PT , BW only - Personnel Time Management , Problem