View deletion

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[MarcinPciak]

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

[Former Member]

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.

[Former Member]

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