Show TOC

Procedure documentationExtending Reuse Views

 

You can extend the reuse views with the SAP HANA Live Extension Assistant. The extended views are created as a new reuse view in the package that is selected by the user. The tool lists all the unused columns from the underlying tables of reuse views. You can select the column that needs to be updated as an output and a new extended reuse view is added.

You can select the type of newly added view column only as Attribute.

Prerequisites

  1. You have installed the following:

    • HCO_HBA_T_EXTN.tgz

    • SAP HANA Appliance Software Support Package Stack 08 revision 82 or higher

  2. You are assigned the role sap.hba.tools.extn.roles:ExtensibilityDeveloper and required package privileges.

  3. REPO.READ, REPO.EDIT NATIVE OBJECTS, and REPO.ACTIVATE NATIVE OBJECTS permissions on the package in which new extended view is created.

Procedure

  1. Right-click the view you want to extend.

    Note Note

    If the view is already extended using this tool, two options display Create new extension view and Edit existing extended view. To edit, click the Edit existing extended view radio button and select the view from the Extend View dropdown. Proceed as mentioned from step 3.

    End of the note.

  2. Select the required option.

  3. Click Next.

  4. On the left side, you can view a list of all the underlying tables of a reuse view.

  5. Expand the table to view or select columns that needs to be added to output of new extended reuse view.

    Note Note

    Both used and reused columns are displayed with the used columns disabled. On the right side, all the SAP delivered columns are displayed.

    End of the note.

  6. Click the Add button to add the required columns that is part of view's table. Click the plus sign on the left side to add a table, which is in the system and not part of any view. This is optional.

  7. Click Next to maintain joint conditions for each of table in which a new column is added.

    Note Note

    Joint type is Left Outer and you cannot change this.

    End of the note.

  8. Click Validate or Activate.

    If you click Validate, the validation results are displayed. Click Activate to activate the new extended view. Once activation is complete, a new extended view is created in the package you selected.