SAP Knowledge Base Article - Public

3427972 - Change Type values for Delta Changes in SAP Datasphere

Symptom

When capturing the delta changes in local table, two additional columns (Change Date and Change Type) will be created automatically.
Column "Change Type" will change values such I, A, D, etc.
In this article meaning of these values will be explained.

Environment

SAP Datasphere

Resolution

Row TypeDelta Table Value
InsertI
Update before imageB
Update after imageU
Delete with before image valuesD
Delete with OK values onlyX
Upsert / AutocorrectA
Initial LoadL
ReplaceR
TruncateT

See Also

Keywords

delta changes, delta, change type, upsert, insert, truncate, replace, delete, Replication Flow, Delta Table , KBA , DS-DI-RF , Replication Flows , DS-DI , Data Integration/Data Builder , DS-DI-TAB , Table Persistency , DS-DI-RT , Remote Tables , Bug Filed

Product

SAP Datasphere all versions