topic Re: Remove append structure from standard table in Application Development and Automation Discussions

Remove append structure from standard table

Former Member — Fri, 13 May 2011 12:45:07 GMT

Dear All,

I Have Important and interesting (for me) question, In our development environment accidently we create Append structure in standard SAP table VBKPF. We try to remove it with Tcode SE11 (remove Append structure) but after that table VBKPF is only Partly active. Then we try solve the problem with transaction SE14 - with no success.

Is there any standard way to recover this kind of issue, even in accidently some times this can be happen

I hope in SAP there should be way to remove appned structure of standard SAP table.

We have original table in test and production environment, could we transport this table from test?

Since this Standard SAP table what is the solution for this,All your expertise ideas/ suggestions highly appreciated.

Thanks & Regards.

Re: Remove append structure from standard table

ThomasZloch — Fri, 13 May 2011 12:55:15 GMT

Please clarify "SE14 - with no success". Table adjustment consists of several steps, which one failed, which message was issued in the processing log?

Consider handing this over to a system administrator or database expert.

Thomas

Re: Remove append structure from standard table

Former Member — Fri, 13 May 2011 13:15:57 GMT

Step 1 is OK

Step2 - Dropping of indexes, renaming of original table (fail)

....

Adjustment terminated in step 2

Re: Remove append structure from standard table

ThomasZloch — Fri, 13 May 2011 13:25:24 GMT

I don't have logs here to double check. Isn't there more information, like a long text after double clicking the error message?

Once again, this should not be in the ABAPers hands. Have a look also in the "Netweaver Adminstrator" or "SAP on <your DB>" forums.

Thomas

Re: Remove append structure from standard table

Former Member — Fri, 13 May 2011 13:31:56 GMT

Thank you, and yes, there is more information, I need to see OSS note 97220 . I hope it helps.

Have a nice weekend!

Re: Remove append structure from standard table

Kiran_Valluru — Mon, 16 May 2011 06:48:57 GMT

Hi.,

You can delete the custom structure appended., then it will automatically be removed from standard table..!!

Regards

Kiran

Re: Remove append structure from standard table

Former Member — Mon, 16 May 2011 07:43:22 GMT

Hi,

I try to delete custum structure with Tcode SE11, but after deleting structure Zxxx some transaction don't work. So I re-create it.

Regards Romana

Re: Remove append structure from standard table

Former Member — Mon, 22 Aug 2011 10:46:44 GMT

Hi Romana,

Please goto the table in SE11 and provide the table name as VBKPF.

Click on APPEND Structure, once you click on Append Structure then you can able to see your Zstructure.

Choose that Zstructure (what you want to delete) and click on Delete button in the same screen.

it will show the message as Dependent tables which are using your Zstructure will effect. Delete the Zstructure once again.

Check the Status of your table (VBKPF) if it is partially activated goto SE14 and and choose ACTIVATE and READJUST the date base table. it will work surely. try once and let me know.

If your problem is resolved please change the status or if you know the process how you resolved please mention, so that some one will use the same procedure.

Regards

valluru kishore

Edited by: vallurukishore on Aug 22, 2011 12:51 PM

Re: Remove append structure from standard table

Former Member — Mon, 22 Aug 2011 15:01:56 GMT

If you have the fields in this append named/used in ABAP objects, why do you want to remove the structure? You need to remove all those references to the fields in the Append from the ABAP objects, or you're going to have abends all over the place, including in production!!

You can't even think about deleting this append from the table until you have modified all the ABAP objects that refer to the fields in the append!

Re: Remove append structure from standard table

madhu_vadlamani — Tue, 30 Aug 2011 15:05:27 GMT

Hi Papler,

Can you try like this. Keep the structure and remove the fields.

Regards,

Madhu.

Re: Remove append structure from standard table

Former Member — Wed, 31 Aug 2011 21:29:10 GMT

Papler:

Try this,

GO TCODE SE80

Dictionary Objects / Structures

Rigth clic mouse over ZZ_your_append and select Delete from context menu.

Automatically when you delete the append structure your standar table is performance.

Regards,

Jose Aguirre

Re: Remove append structure from standard table

Former Member — Tue, 06 Sep 2011 07:31:03 GMT

By se14 you can delete and adjust the data of table. To Delete Append Structure you must Delete Struct in SE11 then Save and Activate Data .

Thanks

Dnyaneshwar.

Re: Remove append structure from standard table

former_member193284 — Wed, 14 Sep 2011 18:23:41 GMT

A quick suggestion i would suggest is try adding the append structure again and run SE14.

if this gets activated delete the structure in SE11 and dont remove it through the standard table.

Thanks

Re: Remove append structure from standard table

Former Member — Wed, 21 Sep 2011 07:15:29 GMT

Go to SE80

select Dictionary Objects / Structures

Rigth click your append structure and Delete.

Now activate your table. this will solve it.

Regards,

Rahul

Re: Remove append structure from standard table

Former Member — Fri, 30 Sep 2011 09:14:11 GMT

Hi,

Go to se11.give your append structure name and delete it.

Re: Remove append structure from standard table

Former Member — Sat, 01 Oct 2011 05:42:55 GMT

Hi,

goto SE11

give the table name

select the append structure and click on APPEND STRUCTURE tab

then you can delete the strucure u want

Re: Remove append structure from standard table

Former Member — Sun, 06 Nov 2011 07:11:56 GMT

Hi,

if you want change the Standard table you need access key. after that select the append structure delete it, then adjust the table.

Thanks & Regards,

Chinni

Re: Remove append structure from standard table

Former Member — Thu, 22 Dec 2011 06:46:07 GMT

Hiii....

Click on " Append Structure" its shows the list of object name, select the object name which you want to delete

and click delete button. after deleting that object go to 'se14' transaction code and 'Active and

Adjust Database'

Re: Remove append structure from standard table

Former Member — Tue, 17 Jan 2012 10:28:36 GMT

go to se11 give the name of your append structure and delete it and

give ur tran table name and then save , check and activate .

append stru u will seen will be deleted

Re: Remove append structure from standard table

former_member612080 — Mon, 21 Oct 2019 07:51:50 GMT

HE wants TO DELETE APPEND STRUCTURE NOT STRUCTURE !!!