SAP Knowledge Base Article - Preview

3652574 - Structure not recognized in SQL views or transformation flows in SAP Datasphere

Symptom

  • When developing SQL views or Transformation Flows of type SQL Script in SAP Datasphere, the copied structure from a different is not correctly recognized, leading to error messages.
  • Warning: "We are unable to derive the return statement completely from the script. Please review the list of columns and their data types in the side panel."
  • Error: "sql syntax error: incorrect syntax near", SQL State: HY000.


Read more...

Environment

  • SAP Datasphere
  • SQL views
  • Transformation Flows

Product

SAP Datasphere all versions

Keywords

SQL views, transformation flows, return structure, SAP Datasphere, SQL script validation, error code 257, SQL State HY000, manual column editing, SQL script limitations, SAP Datasphere troubleshooting, Table functions, Warning: We are unable to derive the return statement completely from the script. Please review the list of columns and their data types in the side panel, Error: sql syntax error: incorrect syntax near , KBA , DS-MD-VIW , Views , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.