SAP Knowledge Base Article - Preview

2325214 - View column data type not displayed if using common table expressions - SAP PD

Symptom

  • When viewing or editing a view's properties, the Data Type column is empty in the Columns tab.
  • The view query uses common table expressions (CTE) before a fullselect.
  • For example,

    WITH expression_name [ ( column_name, ... ) ] AS
    ( CTE_query_definition )
    SELECT column_name, ... FROM expression_name


Read more...

Environment

SAP PowerDesigner (PD) 16.6

Product

SAP PowerDesigner all versions

Keywords

DB2MVS, MSS, Server, 799335, CR799335 , KBA , BC-SYB-PD , PowerDesigner , 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.