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 used defined query definition (SQL expression) for the Database View. 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.