Creating SCV Database View

To create a SCV Database View:

  1. Select Configuration > SCV > Database Views.
  2. Click New. The Database View Detail window is displayed.
  3. Specify this information:
    Name
    A unique name of the SCV Database View. The name must contain a prefix SU_V_* or SUx_V_* (where x = B, C, D, E, F, H, I, L, O, P or S). Else this error message is displayed during validation:

    Cannot save View, name must prefixed with SU_V_* or SUx_V_* where x is one of (B, C, D, E, F, H, I, L, O, P, S). Please refer to Naming conventions in 'SCV Implementation Guide'

    Note: You cannot modify the name after the Database View is created.
    Description
    The description of the SCV Database View.
    System Definition
    The system defined query definition (SQL expression) for the Database View.
    Note: This field is displayed only for the system defined Database view.
    User Definition
    The user defined query definition (SQL expression) for the Database View.
    Note: 
    • The SQL expression for the definition must start with SELECT or WITH statements. The SELECT clause in a view definition cannot include these elements:
      • An ORDER BY clause unless there is a TOP clause in the list of the SELECT statement. The ORDER BY clause is used only to determine the rows that are returned by the TOP or OFFSET clause in the definition. The ORDER BY clause does not guarantee ordered results when the view is queried unless ORDER BY is also specified in the query itself.
      • The INTO keyword.
      • The OPTION clause.
      • A reference to a temporary table or a table variable.
    • You must verify the SQL expression else this error message is displayed:
      Expression validation failed. Expression is not in the correct format: {0
    Override
    Enable the override of the System Definition by the User Definition.
    Note: This field is displayed only for the system defined Database view.
    Enabled
    Indicates the status of the view. Possible values:
    • On (Enabled)
    • Off (Disabled)
    Note: By default, the field is set to On.
    System
    Indicates if the SCV Database View is system defined or user defined.
    Note: This option is enabled for the Database View defined by the system.
  4. Click Save. The Database View is created after the successful validation of the specified information.
    Note: You can use this page to:
    • Create a duplicate of the existing view and modify the parameters as required using the Duplicate option.
    • • Delete only the user defined view using the Delete option. You cannot delete a Database View that is associated with a mapping definition.