System Types Models H

System Types Models V

Use this page to:

To access this page, select Configuration > System Type Models in the Navigation pane.

System Types Models V

System Types Models H

Use this page to Add a System Type Model Table.

Field

Description

Model Tables

Click to open the System Types Model Tables page to add tables to a System Type model.

Model Groups

Click to open the System Types Model Groups page to add tables to a System Type model group.

Build Views

Click to open the System Types Model Build Views page to build the views based on the System Type model.

System Type Model

Displays the name of the database where the data is located for the selected System Type model.

Data Source ID

Displays the data source ID.

Connection Type

Displays the source connection type for the System Type Model.

NOTE: The available source connection types are configured in Collect and provide a mapping from the data type supplied in the Table Field Model View to a valid SQL Server data type.

NOTE: If a mapping does not exist in the connection type, DSP will directly pass the data type from the Table Field Model View into the System Type on import.

Catalog Options

Include Z Column

If enabled, during the catalog export (on the Catalog Phrases page), an additional phrase entry with a “z”? appended is added to the catalog. This is so source reports will translate correctly. For example, zMATNR has a phrase out of Material Number.

If disabled, an additional “z”? phrase is not added to the catalog.

Include Legacy Column

If enabled, during the catalog export (on the Catalog Phrases page), an additional phrase entry with a “zLegacy”? appended to it is added to the catalog. This is so source and target reports translate correctly. For example, zLegacyMATNR has a phrase out of Legacy Material Number.

If disabled, an additional ”zLegacy”? phrase is not added to the catalog.

Model View: Table

Displays a view containing the list of tables with descriptions of the selected System Type.

Model View: Table Field

Displays a view containing the table fields with descriptions and column properties of the selected System Type.

Model View: Table Lookup Field

Displays a view containing the list lookup tables assigned to table fields of the selected System Type.

Model View: Lookup Table Value Description

Displays a list of tables which contain descriptions of the associated lookup table’s values of the selected System Type.

Model View: Table Join

Displays a view containing the list of table joins by field of the selected System Type.

Model View: Table Join Field

Displays a view containing the list of table and field joins by field of the selected System Type.

Model View: Table Field Static Value List

Displays a view containing the list of values assigned to table fields of the selected System Type.

NOTE: In SAP, these would be the domain values assigned at the data dictionary level.