Common
System Types Models H
Use this page to:
To access
|
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
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. |
