Updating a database view

[Former Member]

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.

[Jelena_Perfiljeva]

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.

[Former Member]

Problem has been resolved by creating maintenance view.

Amit.