SAP Knowledge Base Article - Preview

3063955 - Issue on reversing engineer SQL SERVER CTE view -SAP PD


When reverse engineer SQL code which creates CTE view, several issues has been observed:

  • It displays CTE columns as the view's columns in view diagram.
  • It doesn't handle comment in the CTE correctly. It replace the comment with

                           someting like ##1##, ##2## etc.

  • If it has comment at the end of the code, an extra slash / is added.



  • SAP PowerDesigner (PD) 16.6
  • Microsoft SQL Server


SAP PowerDesigner 16.7


MSS, 2017, 2016, 2014, 824183 , CR824183 , CR#824183 , 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.