System Types Models H

Description

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.

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

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

Displays the data source of the configured model views.

Displays the source connection type for the System Type Model.

NOTE: A Connection Type MUST be selected. The available 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. A new Source Connection Type can be created by following these steps Set up Connection Types.

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

Description

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

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

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

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

Displays the data source ID.

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

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.

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.

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

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

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

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

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

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