SAP - DDIC - Views

DDIC Views - DDIC views is used to define application-dependent view that combines this data. The data from several table can be viewed together. The table field which are not require can be hidden. The views are not physically stored but are derived from one or more table.

Steps to Define Views
- Select the base tables of the views.
- Define the join condition to link these tables.
- Select the fields of the base tables.
- Optionally, you can also restrict the records in the views by putting conditions.

There are total four types of views, based on the way in which the view is implemented and the methods that are permitted for accessing the view data. They are - Database Views, Projection Views, Maintenance Views, and Helps Views,.

Among these four types of database views, only 'Database Views' implements INNER JOIN, rest all implements an OUTER JOIN. The detail description of each views has been discussed further below.

Describe Database Views
This views are implemented with an equivalent view on the database. A database view is automatically created in the underlying database when it is activated. Database views implement an inner join.

  Important points to note about database views
    - At least one relationship is required.
    - No modification can be done. Read only.
    - Implements an inner joins.

Describe Projection Views
Projection views are used to hide fields of a table. This can minimize interfaces; for example when you access the database, you only read and write the field contents actually needed.

  Important points to note about projection views
    - It is used for only one table.
    - You cannot define selection conditions for projection views.
    - Modification (create, delete, insert, and update) can be done.
    - You can also access pooled tables & cluster tables with a projection view.

Describe Maintenance Views
With Maintenance Views you can also change/edit data. Thus, a maintenance view allows you to maintain the data of an application object together. All the tables in a maintenance view must be linked with foreign key. The join conditions for maintenance views are always derived from the foreign key. You cannot directly enter the join conditions as for database views.

  Important points to note about maintenance views
    - 'N' no. of relationship can support.
    - Modification can be done.
    - Implements an outer join.

>> DDIC Views Continued..     








                                                      Copyright © 2011 All rights reserved.