Columns
Columns appear in tables and views with a Semantic Usage of Relational Dataset.
|
Property |
Description |
|---|---|
|
Key |
Select the checkbox to specify that the column is a primary key column, which uniquely identifies the record. Key columns cannot contain null values and each value (or set of combined values for multi-column compound keys) must be unique.
See also Set Key Columns to Uniquely Identify Records. To validate the data in your key columns, see "Key Validation Rules" in Validating View Data.
|
|
Business Name |
Enter a descriptive name to help users identify the object. This name can be changed at any time. |
|
Technical Name |
Displays the name used in scripts and code, synchronized by default with the Business Name.
To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores.
|
|
Data Type |
Select the type of data that the column will contain. You can change the data type of a column. For more information, see Modifying Objects That Have Dependent Objects For a list of available data types and their supported data type conversions, see Column Data Types. |
|
Default Value |
Enter an appropriate default value for the column. |
|
Not Null |
Select this option to indicate that the column must contain a value. |
|
Change Type |
This column will track the type of last change made to a record. When a record is inserted or updated corresponding change types are used: "I" for insert (a new record is added), "U" for update (an existing record gets an updated value), or "A" for upsert (insert records if they do not exist yet in the target table, or update them by primary key if they do exist). When an existing record is deleted other specific change types are used (for example "D"). Note that deleting a record will not physically delete it, so that the changes can be propagated to the different objects that consume it in delta mode. It is however filtered out when accessing the Local Table (using the Active Records Table). Also, note that the change types provided by the different SAP Datasphere apps vary and may depend on the actual source that is connected. The handling of the different change types is implemented internally by SAP Datasphere apps that consume the Delta Capture Table with no need for consideration in modeling. For more information on records deletion, see Load or Delete Local Table Data When a record is inserted or updated corresponding change types are used: "I" for insert (a new record is added), "U" for update (an existing record gets an updated value). When an existing record is deleted other specific change types are used (for example "D"). Note that deleting a record will not physically delete it, so that the changes can be propagated to the different objects that consume it in delta mode. It is however filtered out when accessing the Local Table (using the Active Records Table). For more information on records deletion, see Deleting Local Table (File) Records . |
|
Change Date |
The column will track the last date and time of the last change to an individual record. Current UTC timestamp. |
|
Index Type |
An index is an auxiliary data structure built on a database table column (or multiple columns) to enable faster lookups.
The possible values differ depending on the primary keys you have defined for your table:
|
