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

Search for additional results

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