topic Re: Removing append structure in Application Development and Automation Discussions

Removing append structure

Former Member — Tue, 16 May 2006 15:21:06 GMT

Hello ABAPers,

We have appended a z structure to a sap standard structure. However we no longer need the append structure anymore. Can anyone tell me how to remove the z structure now?

Appreciate your help in advance.

Haseeb

Re: Removing append structure

nablan_umar — Tue, 16 May 2006 15:26:03 GMT

If you appended it thru user exit implementation, edit the structure thru that as well. Then, select the fields then click on delete button. Or you can go thru transaction SE11 and delete the fields.

Re: Removing append structure

Former Member — Tue, 16 May 2006 15:27:06 GMT

Delete the append structure (Z structure) itself in se11.

Re: Removing append structure

pradiptakumar_mishra — Tue, 16 May 2006 15:28:05 GMT

Dear Haseeb,

Go to SE11. In the tables field give your append structures name. Then click on the delete button on the status bar.

It'll prompt from re-activation of the standard table/structure. Just click on delete icon.

It'll solve your issue.

With Regards

Pradipta Kumar Mishra

Re: Removing append structure

Former Member — Tue, 16 May 2006 15:39:41 GMT

hi,

1) select the row and delete the append structure

2) activate the table

3) se11~~>(click on change table)~~>UTILITIES-->Database Utilities

click on activate and adjust database ( select radio button save data)

step 3 is very important since after deletion u need to adjust database table.

close the thread if the problem is solved.

Mark Helfull answers

regards

Re: Removing append structure

ferry_lianto — Tue, 16 May 2006 15:43:13 GMT

Hi Haseeb,

You can go to transaction code <b>SE11</b> (ABAP Dictionary). Enter database table with <z structure> and click on <b>Delete</b> button.

The system will prompt a message of deleting the append structure results in reactivation of and adjusment of table < ... > on the database then you need to click on delete button.

Hope this will help.

Regards,

Ferry Lianto

Re: Removing append structure

Former Member — Tue, 16 May 2006 17:22:34 GMT

Thank you everyone for you replies.

The problem I have is, I have removed the z structure from sap table. However, one there was an additional index on the sap table that was using one of the field from the z structure.

Now when I try to activate the sap structure after deleting the structure, it complains that the field in the index is not available anymore and cannot be activated.

Re: Removing append structure

RichHeilman — Tue, 16 May 2006 17:24:25 GMT

Please remove that field from the index. You may also have to activate/adjust from SE14.

Regards,

Rich Heilman

Re: Removing append structure

Former Member — Tue, 16 May 2006 17:49:03 GMT

Hi ,

Firstly go to /se11 and delete the z structure you created earlier .

Secondly, go to SE14 and save & adjust Database. This is very important .