Delete runtime object

[Former Member]

Dear experts,

I would like to delete the runtime objects of a db table and db view.

I have created a db table and a db view and activated them. I have changed the field name of a table component in the db table and the corresponding data element and I have tried to activate it again using the database utility (se14).

Save data option did not work, nor the delete data option, it did not work with the delete database table and create again... that options delete only the database objects, but not the runtime objects.

Please advise how to delete the runtime objects of the db table and the db view, as SE14 doesn't work.

Thank you for your help!

Best regards,

Matei Muntean

[pranay570708]

After making changes to table, in SE14 select 'Activate and Adjust database' option. Why you are going for other options, what's your requirement.

[Former Member]

Hi Patel,

I had a flag FLGPLSCN in the database table, which I had to change to PLSCN (the parameter instead of the flag).

As a result, I had to adjust the database table. So I did go for SE14,  'Activate and Adjust database' option. I still could not do that because of the dependency with the view.

So I deleted the database objects of both the database table and the view. And I created both again as database objects. Still, did not help because the runtime objects were still there and the runtime objects still contained the old FLGPLSCN instead of the new PLSCN.

My only solution was to delete the view completely and save into an excel sheet which fields I had in the view.

I adjusted then the db table successfully.

Then I created the view again from scratch. Still, this takes time. Please advise me how to delete runtime objects in the future.

I have found the options to display them (yea... they are beautiful indeed ) and to check them (yeah, they are even more beautiful, as no error whatsoever appears! only at activation)... but no delete option!

Please advise if you know of any delete option of the runtime objects, as I wouldn't like to rebuild views from the scratch in the future.

BR,

Matei

[pranay570708]

Hi,

If there was dependency of that field in some view, did you try to make changes for that particular field in that view and activate. Was that causing any error? I guess that would be an easy approach.

[Former Member]

Yes, the field FLGPLSCN from the db tab was also present in the view FLGPLSCN.

I have renamed it in the db table and in the view also to PLSCN.

Still, that did not help, as the Activate and Adjust option or the Delete and Create again options only affect the database objects and not the runtime objects which had to be deleted or reconstructed...

[Sandra_Rossi]

To reconstruct the runtime object (I really wonder what happened, you didn't clearly explain, because it's very rare to need it), you must log in with user DDIC, then the menu entry "reconstruct" (the runtime object) is available. cf SAP Library.

[Former Member]

Hi Sandra,

The reconstruct option was grayed out for my user. I didn't know there is a DDIC user in SU01. I wasn't aware of that... But I found it out with this occasion. Maybe I should speak to some mates from the BASIS team for a pw in the future.

Thank you!!! Have a nice day!

Matei