Append views are used for enhancements of database views of the SAP standard. This includes special developments, country-specific enhancements and customer modifications.
With an append view, fields of the base tables of the view can be included in the view without modifications. This is analogous to enhancing a table with an append structure.
Append views are a new type of view that can only be used to enhance new fields to existing database views. An append view is assigned to exactly one database view. More than one append view can be created for a database view.
When a database view is activated, the system looks for all the append views for this view and their fields are appended to the database view. When an append view is created or changed, the assigned database view is automatically adjusted to this change when the append view is activated.
A database view V is defined for tables A and B. Table A contains fields 1, 2 and 3. Table B contains fields 4, 5, 6 and 7. Database view V contains fields 1 and 2 of table A and field 5 of table B.
Database view V is used in an application to select data from tables A and B. For a special development, the contents of fields 6 and 7 of table B are also required in addition to the fields contained in the view. These two fields of table B can only be inserted in view V with an append view D.
The append technique described can only be used for database views. With an append view, only new fields from the base tables contained in the view can be inserted in the view. You cannot insert new tables in the view or modify the join conditions or selection conditions of the view.
See also:
Creating Append Views