Creating SCV Mapping

This topic describes the process of creating Mapping definition between the tables in the SCV database.

To create a SCV mapping:

  1. Select Configuration > SCV > Mappings.
  2. Click New.
  3. Specify this information in the Details tab:
    Name
    A unique name of the Mapping.
    Description
    The description of the Mapping.
    Enabled
    Indicates if the Mapping is active (On) or inactive (Off). By default, the field is set to On.
    Note: 
    • Only active Mappings are used for transferring the planning data.
    • This field is enabled for system and user defined Mappings.
    System
    Indicates if the Mapping is system defined or is user defined.
    Note: This option is enabled only if the Mapping is defined by the system.
  4. Specify this information in the Table Mapping tab:
    Target Table
    The Target Table for which the mapping is applicable. This is SCV table name that is selected from the Table Registry.
    Source Object Type
    The type of source object. Possible values:
    • Table
    • View
    • Query
    Source Table
    The name of the SCV table (defined in the Table Registry) from which the mapping is applied based on the Source Type.
    Note: This field is displayed only if the Source Object Type is set to Table.
    Source View
    The name of the SCV view from which the mapping is applied.
    Note: This field is displayed only if the Source Object Type is set as View.
    Source Query
    The SQL query used to determine the source.
    Note: 
    • You must verify the Query using Verify option.
    • This filed is displayed only if the Source Object Type is set to View.
  5. Click the Elements Mapping tab. This tab contains the Mapping of Elements available in the Target Table.
  6. Click Generate Mappings. The existing mappings are cleared and the Mapping Elements list with all the Target Elements from the Target Table is displayed.
    Note: The list contains the target elements that may not have matching elements. If the target element:
    • Has a matching source element, the value for the Source Element and Type fields are displayed.
    • Does not have a matching element, the value for the Source Element and Type fields are left empty. You must either delete the target elements or assign a transformation type or value.
  7. Click Add (+).
  8. Specify this information:
    Target Element
    The target element to be mapped.
    Description
    The description of the Mapping Element.
    Transformation Type
    The transformation type to be mapped to the mapping. Possible values:
    • CONSTANT
    • DIRECT MAPPING
    • KEYWORD
    • EXPRESSION
    • HASHKEY
    Note: The default value is Direct Mapping.
    Source Element
    The source Table or View to be mapped.
    Note: This field is displayed if the Transformation Type is set to Direct Mapping.
    Default Value
    The target element with a default value when Source Element is not defined.
    Note: This field is applicable only if Transformation Type is set to Direct Mapping.
    Keyword
    The predefined keyword. Possible values:
    • CURRENT_DATE
    • CURRENT_TIME
    Note: This field is applicable only if Transformation Type is set to Keyword.
    Constant Value
    The constant value applied to the target element.
    Note: This field is applicable only if Transformation Type is set to Constant.
  9. Click Save. A new mapping is created after the successful validation of the specified information.
    Note: You can use this page to:
    • Create a duplicate of the existing mapping and modify the parameters as required using the Duplicate option.
    • Delete the user defined mappings only using the Delete option.