topic Re: View deletion in Application Development and Automation Discussions

View deletion

Former Member — Wed, 13 May 2009 12:11:47 GMT

Hi Experts,

I have deleted a view using the 'SE14' transaction.

But when I open in in the 'SE11' transaction, it throws a message 'View Deleted in the Database' and shows me the view back again.

I want to delete the view completely, even in 'SE11'.

Any idea how to do this?

Any pointers/suggestions are highly appreciated.

Thanks,

Kris.

Re: View deletion

Former Member — Wed, 13 May 2009 12:48:57 GMT

Delete the table from both the transaction SE14 and SE11 also,

Re: View deletion

Former Member — Wed, 13 May 2009 15:17:05 GMT

Hi,

Try to delete it from SE11 ..if u delete for sure..u will not find an entry in DD02L AND DD02T tables.

Thanks and Regards,

Krishna Chaitanya G

Re: View deletion

MarcinPciak — Wed, 13 May 2009 17:16:02 GMT

Hi,

When creating (activating) a view, a physical corresponding object is created in underlying DB. The same applies to its deletion. Using se14 you simpy deleted DB view, but Dictionary object remained alive. All you need is to delete it using se11 now.

For future use only se11 to create/delete objects, all these changes will be visible straigh away in DB.

SE14 use only when altering object can't be perfomed and it need to be converted (i.e. when some data are in table and you want to change key fields of that table. It may be necessary then to use DB utility (se14)).

Regards

Marcin

Re: View deletion

Former Member — Thu, 14 May 2009 13:49:09 GMT

You can go to se11 and from menu select database utility, first delete it there and then in se11.

Pls check also table TADIR, rows should disappear from there also.

Re: View deletion

Former Member — Fri, 15 May 2009 05:24:51 GMT

Dear Kris,

When you create a database view it is automatically created in underlying database as well as in dictionary level so always delete the view or a table only from SE11 so that all the changes which you do can directly reflect in database , after doing so dont forget to use database utility.

Cheers

fareed