topic Re: append views in Application Development and Automation Discussions

append views

Former Member — Tue, 05 Feb 2008 04:25:22 GMT

plz explain how to append views

explain with example plz

Re: append views

Former Member — Tue, 05 Feb 2008 04:30:56 GMT

Hai.

check the links.

http://help.sap.com/saphelp_nw70/helpdata/en/85/0138d39f3b11d3969400a0c929b3c3/content.htm

http://www.eispl.com/Course%20Outline/BC430%20ABAP%20Dictionary.htm

http://www.knowledgetransferinc.com/training/classes/MN/overviewKT-4032.htm

regards.

sowjanya.b.

Re: append views

Former Member — Tue, 05 Feb 2008 04:36:10 GMT

Bhaskar,

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.

Append Views

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.

Don't forget to reward if useful...

Re: append views

Former Member — Tue, 05 Feb 2008 04:38:03 GMT

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.

plz reward if useful

vivek