SAP Knowledge Base Article - Public

3531244 - Cannot add filters on source objects with column names containing "/" for Projection mapping in Replication Flows

Symptom

An error is encountered while applying filters for Projections in a Replication flow on SAP Datasphere. This is seen when the source system is BW4HANA and source object is an ADSO.

Invalid column name. The target column name must consist of only alphanumeric (A-Z, a-z, 0-9) and underscore (_) characters.

 
The offending columns/fields are standard BW object names which contain the "/" character.
 

Environment

SAP Datasphere

Reproducing the Issue

  1. Open Replication Flow where the target table has at least one field with the character "/" in its name
  2. Edit existing Projection or add a new one if none exist
  3. Go to Mapping
  4. Save

Cause

Currently a projection cannot be created if there are columns containing special characters in their name and the target is not an existing one.

Resolution

Feature Request ID: 334344 is open and submitted to the Datasphere Development team, in order for this limitation with special characters to be lifted.

As a workaround to create the projection, rename the target column names to remove the special characters.

Keywords

invalid column name, BW, ADSO, ODP BW, replication, filter, projection, special characters , KBA , DS-DI-RF , Replication Flows , Product Enhancement

Product

SAP Datasphere all versions