SAP Knowledge Base Article - Public

3302911 - Transport of SQL View (Table Function) from DWC Development is converting into Local table in DWC Test

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

Product

SAP Datasphere all versions