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 ONE Support launchpad (Login required).

Search for additional results

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