Symptom
Transport of SQL View (Table Function) from DWC Development is converting into Local table in DWC Test, import package
Environment
DWC Version 2023.4.66
Reproducing the Issue
A SQL view is created in a development system (e.g.) and it is transported to a test system (e.g.) and in the target system it is converted to a local table instead of the original SQL view.
Cause
Issue is under investigation by DWC Development team
Resolution
The development team is owrking to resolve to provide the final solution for the issue
Now you can try a workaround.
1> In Development tenant, open this SQL view (Table function), do "Export to CSN File"
2> In Test tenant, Data Builder-> <space>, do "Import Objects from CSN File", select the exported JSON file.
It should fix the issue now.
We will update you further as soon as this is clearer and the corresponding delivery wave for the fix.
Thank you for your patience.
Keywords
SQL view, Local table, DWC, transport, SQL script, table function, relational dataset , KBA , DS-MD , Modeling (Data Builder) , Problem