SAP Knowledge Base Article - Preview

2381480 - Views: change target DBMS - group by column alias changes to column code - SAP PowerDesigner

Symptom

  • When changing the target DBMS from a user defined Teradata 13 XDB to the default Teradata 13 XDB, two columns referenced in the GROUP BY statement change from the listed column alias to the name/code of the referenced view column.
  • When reviewing the PDM via an XML editor, the two columns in question have references to 'ViewColumn.Columns' attribute.
    These referenced columns represent the columns that are changed in the GROUP BY clause. Is this expected behavior?


Read more...

Environment

SAP PowerDesigner All Versions

Product

SAP PowerDesigner all versions

Keywords

CR802536, 802536, CR, PD, view , sql, query , 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.