System Types Models H
Use this page to:
- Add a System Type Model
- Add a System Type Model Table.
- View Fields Required for System Type Tables
- Add a System Type Model Group
To access this page, select Configuration > System Type Models in the Navigation pane.
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, 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.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.