Creating SCV Hierarchy Table links

Hierarchy table link definitions are used to create links between planning data tables and hierarchy data at the base level. Each core table has one hierarchy link table in SCV.

In application views, hierarchy table links are used to link transactional data with hierarchy base levels. For example, the Demand Planning View for sales history links the sales history records with the Item and Location hierarchies.

The hierarchy table links are used to apply profile selections on the base hierarchy level during the Prepare Profile data process. For example, if items at warehouse WH1 in SC_ITEM_LOCATION are selected for Profile 1, the item hierarchy using SC_ITEM_LOCATON select only the base hierarchy values with items at warehouse WH1 for Profile 1.

To create SCV hierarchy table links:

  1. Select Configuration > SCV > Hierarchies > Hierarchy Table Links. The Hierarchy Table Links page is displayed.
  2. Click New.
  3. Specify this information:
    Table Link Name
    A unique name of the table link.
    Note: You cannot modify this value after the table link is created.
    Table Name
    The name of the SCV core table to be linked to the hierarchy.
    Hierarchy
    The SCV defined hierarchy to which the table is linked.
    Link Type
    Indicates the type of Link. Possible values:
    • Column
    • Constant
    • Expression
    • Query
    Link Value

    The value for the Link Type. Possible scenarios:

    • Column: The source table column name that stores the link value.
    • Constant: The value that represents the link value as a constant.
    • Expression: A valid SQL expression for the Table Name that represents a valid value in the base level of the specified hierarchy.
    • Query: A valid SQL expression that selects the ID of the record in the source table and a valid value in the base level of the specified hierarchy.
      Note: You can verify the Query using the Verify option.
    System
    Indicates if the hierarchy table link definition is a standard configuration.
    Note: This option is set to Off and disabled for user-defined hierarchy table links.
    Enabled
    Indicates the current status of the hierarchy table link.
    Note: The enabled hierarchy-table links are used by the Prepare Hierarchy Data process.
  4. Click Add. A new hierarchy table link is created after successful validation of the specified information.
    Note: You can use this page to:
    • Create a duplicate of the existing hierarchy table links and modify the parameters as required using the Duplicate option.
    • Delete hierarchy table links using the Delete option.