Remove append structure from standard table

[Former Member]

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.

[ThomasZloch]

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

[Former Member]

Step 1 is OK

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

....

Adjustment terminated in step 2

[ThomasZloch]

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

[Former Member]

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

Have a nice weekend!

[former_member184578]

Hi.,

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

Regards

Kiran

[Former Member]

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

[Former Member]

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

[Former Member]

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!

[madhu_vadlamani]

Hi Papler,

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

Regards,

Madhu.

[Former Member]

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

[Former Member]

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.

[former_member193284]

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

[Former Member]

Hi

Go to SE80

select Dictionary Objects / Structures

Rigth click your append structure and Delete.

Now activate your table. this will solve it.

Regards,

Rahul

[Former Member]

Hi,

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

[Former Member]

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

[Former Member]

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

[Former Member]

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'

[Former Member]

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

[former_member612080]

HE wants TO DELETE APPEND STRUCTURE NOT STRUCTURE !!!

[Jelena]

I bet he/she already moved on, actually. This question is from 2011. 🙂

Please consider the question date when replying ("Former member" is a dead giveaway the OP is now waiting for an answer anymore). And, either way, please use Comment button when replying to someone else. Answer is meant to provide a solution to the original question, not to carry on a dialogue with someone else.

Thanks.