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).

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



  • 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 for Me (Login required).

Search for additional results

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