Common

System Types Models H

System Types Models V

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

Field

Description

Model Tables

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

NOTE: These tables must exist in the target System Type data source to allow importing from a model.

Model Groups

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

SYSTEM TYPE MODEL

Displays the name of the database where the data is located. An SAP System Type model is delivered with the product.

DATA SOURCE ID

Displays the data source of the configured model views.

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, Stewardship Tier will directly pass the data type from the Table Field Model View into the System Type on import.

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: 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.

Model Required For Tables

Click to open the System Types Model Required Fields page to view fields required for the table model view.

Model Required For Tables Fields

Click to open the System Types Model Required Fields page to view fields required for the table fields model view.

Model Required For Table Lookup Fields

Click to open the System Types Model Required Fields page to view fields required for the lookup table model view.

Model Required For Table Field Domains

Click to open the the System Types Model Required Fields page to view fields required for the lookup table value description model view.

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: 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 Required For Table Joins

Click to open the System Types Model Required Fields page to view fields required for the table joins model view.

Model Required For Table Join Fields

Click to open the System Types Model Required Fields page to view fields required for the table field joins model view.

Model Required For Descr Table

Click to open thethe System Types Model Required Fields page to view fields required for the description table model view.

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, Stewardship Tier 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.