Creating a View Table 

Use

You can use SQL Studio to create view tables.

Prerequisites

The database query that you want to base the view table on has been stored as an SQL Studio object. You have the necessary user authorizations and have user attribute NOT EXCLUSIVE*.

Procedure

...

Choose Catalog Manager ® New ® View.
A window for defining the view table is opened.

Use the Drag&Drop function to copy the stored database query from the Catalog Manager to the definition window. By doing this, you copy the structure of the results of this database query.

Enter a name for the view table.

If you want to rename the columns of your view table, enter the new column names in Alias in View.

Select the required options:

Replace existing view	Replace the existing view table
Check on insert or update	Check the view conditions when changing values
Identifiers upper case	Automatic conversion of table names and column headers into upper case.

Choose View Definition ® Create View.

To export the SQL statement for creating the view table to the SQL dialog, choose View Definition ® Export to SQL Dialog.

*For an explanation of user authorizations and user attributes, see the User Concept section of the documentation The SAP DB Database System and the Authorization section of the Reference Manual: SAP DB.

For information on the syntax of CREATE VIEW statements, see the CREATE VIEW Statement section of the Reference Manual: SAP DB.