Show TOC

Constants (CDS)Locate this document in the navigation structure

You can define constants for use in view definitions when working with HANA CDS HDI. PowerDesigner models CDS constants as columns in a special Constants table.

Procedure

  1. Open a context diagram, select Start of the navigation path Model Next navigation step Constants End of the navigation path to open the List of Constants, click the Add a Row tool, and click OK to create the Constants table.
  2. Double-click the Constants table to open its property sheet and click the Columns tab.
  3. Click the Add a Row tool to create a constant and then click the Properties tool to open its property sheet.
  4. Enter the following properties on the General tab:

    Property

    Description

    Name/Code/Comment

    Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

    Data type

    Specifies the data type of the constant. Depending on the type, you may also need to enter a Length and Precision.

  5. Click the Standard Checks tab and enter the value of the constant in the Values groupbox Default field.
  6. Click OK to complete the creation of the constant, which is now available for selection as a data type for other objects.