Table of Contents

Search

  1. Preface
  2. Introduction to Enterprise Data Manager
  3. Enterprise Data Manager
  4. ILM Repository Constraints
  5. Partition Exchange Purging
  6. APIs
  7. Salesforce Accelerator
  8. Appendix A: SAP Application Retirement Entities
  9. Appendix B: Import Formats for Constraints
  10. Appendix C: Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Creating a Virtual View

Creating a Virtual View

To create a virtual view, use the
Virtual View Wizard
.
  1. Go to
    View
    Constraints
    .
  2. Navigate to the application version.
  3. Right-click the application version and select
    Create Virtual View
    .
    The
    Virtual View Wizard
    appears.
  4. Enter a name and a description for the virtual view that you want to create.
  5. Click
    Next
    .
    A list of the available schemas for the home database appears.
  6. Select the schemas for the virtual view, and click the down arrow.
  7. Click
    Next
    .
  8. Click
    Add
    to insert a blank line. Enter a name for the column, select the data type, and specify the length.
  9. Click
    Next
    .
    The
    Virtual View's SQL Text
    page appears.
  10. Enter the SQL code that the ILM Engine uses to archive the virtual view. Prefix the SQL code with the schema name so that the row count report generates correctly.
    You must provide the correct number of columns in the SQL code for the job to run successfully.
  11. Click
    Finish
    .
    The virtual view appears under the application module of the application version that you selected.

0 COMMENTS

We’d like to hear from you!