SAP Knowledge Base Article - Preview

2218311 - Column name and data type are concatenated - SAP PowerDesigner

Symptom

After reverse engineering against MS SQL 2012, column name and data type have been concatenated.

This only appears to be a problem if there is one column in the table and the column name is embraced with square brackets.


CREATE TABLE [dbo].[CPC_SELLER_BUDGET_WORK] (
[GROUP_NO] bigint NOT NULL
) WITH (DATA_COMPRESSION=PAGE)
GO

PD shows "GROUP_NObigint" as a column name in the diagram.

Concatenated_ColumnName_and_Datatype.PNG

If the create table statement has multiple columns it is reverse engineered correctly.
For example, if you reverse the following, both columns are created in PD.

CREATE TABLE [dbo].[CPC_SELLER_BUDGET_WORK] (
[GROUP_NO] bigint NOT NULL,
[GROUP2_NO2] bigint NOT NULL
) WITH (DATA_COMPRESSION=PAGE)
GO

MultiColumn.PNG


Read more...

Environment

SAP PowerDesigner 16.5 SP05 PL02 and earlier.

Product

SAP PowerDesigner 16.5

Keywords

Powerdesigner, reverse engineer, MSSQL, MS SQL, bracket , 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.