append views

[Former Member]

Hi,

I have two queries please help me with answers:

1. When do we use append views. Do we attach an append to a view when a corresponding append structure is appended to one of the tables of the view.

2. How are the views buffered, they do not contain any data.

[Former Member]

Tushar,

1. we will not append structure to View, we just append to table and it will visible in View as well.

2. Don't think views can be buffered.

Reward points if this info is useful

Satish

[Former Member]

Thanks for your reply, in case we have a new field added to the table using an include then how it will be updated in the view.

[Former Member]

Tushar,

After including the field in the table you need to go to utilities -> data base utilities and have to update the table where ever it has been used, then all the dictionary object which has used the table will get updated.

<b>Reward points for helpful answers</b>

Satish

[Former Member]

Hi

<b>Append Views </b>

Append views are used for enhancements of database views of the SAP standard.

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.

An append view is assigned to exactly one database view. More than one append view can be created for a database view.

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.

<b>Includes in Database Views </b>

An entire table can be included in a database view. In this case all the fields of the included table will become fields of the view (whereby you can explicitly exclude certain fields).

To include one of the tables in the view, enter character * in field View field, the name of the table to be included in field Table and character * again in field Field name on the View fields tab page of the maintenance screen of the view.

You can also exclude individual fields of an included table. If you do not want to include a field of the included table in the view, enter - in field View field, the name of the included table in field Table and the name of the field to be excluded in field Field name.

<b>Inserts with Database Views </b>

If a database view contains only one single table, data can be inserted in this table with the view .

You have the following options for the contents of the table fields not contained in the view:

If the field is defined on the database with NOT NULL as initial value, the field is filled with the corresponding initial value.

If the field is defined on the database as NOT NULL without initial value, an insert is not possible. This results in a database error.

If the field is not defined on the database as NOT NULL, there will be a NULL value in this field.

<b>Reward if usefull</b>