05-13-2011 1:45 PM
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.
05-13-2011 1:55 PM
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
05-13-2011 2:15 PM
Step 1 is OK
Step2 - Dropping of indexes, renaming of original table (fail)
....
Adjustment terminated in step 2
05-13-2011 2:25 PM
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
05-13-2011 2:31 PM
Thank you, and yes, there is more information, I need to see OSS note 97220 . I hope it helps.
Have a nice weekend!
05-16-2011 7:48 AM
Hi.,
You can delete the custom structure appended., then it will automatically be removed from standard table..!!
Regards
Kiran
05-16-2011 8:43 AM
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
08-22-2011 11:46 AM
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
08-22-2011 4:01 PM
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!
08-30-2011 4:05 PM
Hi Papler,
Can you try like this. Keep the structure and remove the fields.
Regards,
Madhu.
08-31-2011 10:29 PM
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
09-06-2011 8:31 AM
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.
09-14-2011 7:23 PM
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
09-21-2011 8:15 AM
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
09-30-2011 10:14 AM
10-01-2011 6:42 AM
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
11-06-2011 7:11 AM
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
12-22-2011 6:46 AM
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'
01-17-2012 10:28 AM
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
10-21-2019 8:51 AM
10-22-2019 10:45 PM
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.