Creating SCV Mapping

The Mapping definition is created between the tables in the SCV database.

  1. Select Configuration > SCV > Mappings. The list of mappings that are already defined is displayed.
  2. Click New.
  3. Specify this information in the Details tab:
    Name
    A unique name of the Mapping.
    Description
    The description of the Mapping.
    Source Override
    Indicates if the source mapping is overridden.
    Note: 
    • This option is enabled for system defined mappings.
    • This option is set to On, if the source is overridden.
    Element Override
    Indicates if the element is overridden.
    Note: 
    • This option is enabled for system defined mappings.
    • This option is set to On, if the source is overridden or the element is overridden.
    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.
    Default
    Indicates if the mapping is used as the default mapping between the source and target objects.
    Note: 
    • This option is used only if the target table has multiple mappings.
    • By default, this option is set to Off.
  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 Add (+).
  7. 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.
    SQL Expression
    The SQL expression for retrieving source data.
    Note: This field is displayed only when Transformation Type is set to Expression.
  8. Click Effective Mapping. The list of all fields created by the mapping process is displayed.
  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.