SAP Knowledge Base Article - Preview

2366065 - List of columns is incomplete when Listagg is called in View SQL query - SAP PD


  • The LISTAGG function was introduced in Oracle 11g Release 2.
  • If this analytic function is used more than once in SQL Query, the list of view columns is incomplete.
  • PD should use the column alias to list the columns in the view, if applicable.



  • SAP PowerDesigner (PD) 16.6 SP01 PL01
  • Oracle 11 and later


SAP PowerDesigner 16.6


interpretation, misinterpreted, recognized, recognised, 801910, CR801910, CR#801910 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

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.