SAP Knowledge Base Article - Preview

2326265 - Generation order is wrong for views with a CTE query - SAP PD


View is created before database, table space and table in the SQL script generated by SAP PowerDesigner if:

  • the table involved in the view query has a table space defined,
  • and this table space has a database assigned,
  • and the view query uses a common table expression (CTE).



  • SAP PowerDesigner (PD) 16.6 PL01
  • IBM DB2 for z/OS


SAP PowerDesigner all versions


db2mvs, associated, 799422, CR799422 , 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.