topic Updating a database view in Application Development and Automation Discussions

Updating a database view

Former Member — Tue, 01 Apr 2008 13:58:40 GMT

Hi,

can you please tell me how can i update database 'z' view.

can we update as the same ways as we fill the data in database table by insert update command..

if there is any way to fill data in data base view please describe the process if any code you have it would be appreciated.

Thanks.

Re: Updating a database view

Jelena_Perfiljeva — Tue, 01 Apr 2008 14:48:10 GMT

Database view does not have any data itself. It just sort of a build-up on the actual database table (or tables). For more on database views please see here:

http://en.wikipedia.org/wiki/View_(database)

If you are looking at a view in SE16, for example, and don't see the data that you'd expect, it means that data is not present in the database. Check the view definition in SE11 to see to which tables it is pointing. In ABAP programs you may use a view to select from the database, but I don't think you can use it to update database. I'm not 100% sure though - it just has never occurred to me to use a view for updates.

Re: Updating a database view

Former Member — Fri, 11 Apr 2008 08:21:36 GMT

Problem has been resolved by creating maintenance view.

Amit.