3643699 - Table columns automatically prefixed by replication flows in SAP Datasphere

Symptom

When creating local tables via replication flows in SAP Datasphere, table columns with technical names starting with an underscore (_) or having the same name as columns used for CDC are automatically prefixed with AUTOPREFIX_.

Environment

SAP Datasphere

Cause

If a target column name conflicts with one of the CDC columns (for example, _timestamp), the system applies Auto-Projection, which automatically renames the target column by adding the prefix AUTOPREFIX_.

This avoids naming collisions during replication.

Resolution

Rename the target column in the replication mapping to a name that does not conflict with CDC columns.
Alternatively, keep the Auto-Projection

Keywords

Auto-Projection, AUTOPREFIX, Datasphere , KBA , DS-DI-RF , Replication Flows , Problem

Product

SAP Datasphere all versions