SAP Knowledge Base Article - Public

3618663 - The usage of alias in SQL view is changing the column's data type

Symptom

In case "alias" is used in a SAP Datasphere SQL view, the column's datatype is changed.
For example from Integer to String.

Environment

SAP Datasphere

Reproducing the Issue

  1. Open Data Builder
  2. Edit the SQL View
  3. Add "Alias" to the definition
  4. Check the columns' data type

Resolution

A fix for this issue was created and it will be available to you via SAP Datasphere Wave 2025.13. Please see SAP Note 2984828 - SAP Datasphere Release & Delivery Schedule regarding the planned availability of the fix. 

As global deployment usually takes 24 hours, you may plan to test the fix one day later. 

See Also

SAP Help Portal Documentation: Creating an SQL View

Keywords

KBA , DS-MD-VIW , Views , Problem

Product

SAP Datasphere all versions