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
- Open Data Builder
- Edit the SQL View
- Add "Alias" to the definition
- 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