SAP Knowledge Base Article - Preview

3623560 - How to generate SQL code using column data types instead of domains - SAP PD

Symptom

  • A table column is associated with a domain in a Physical Data Model (PDM).
  • By default, the SQL preview displays the user data type, i.e. the domain code.
  • How to have the column's data type generated instead of having the domain.
  • As an example, how to move from
       create table TABLE_1 (
          COLUMN_1   DOMAIN_1  -- where the data type of DOMAIN_1 is INTEGER
       );
    to
       create table TABLE_1 (
          COLUMN_1   INTEGER
       );


Read more...

Environment

SAP PowerDesigner (PD) 16.7

Product

SAP PowerDesigner 16.7

Keywords

powerdesigner, domain, sql, preview, ddl, dtype, data type, generation, show , KBA , BC-SYB-PD , PowerDesigner , How To

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.