Deleting append structure from standard table issue

[nandakumar_sasidharan]

Hi All,

I have created an append structure in standard table TFK033C. Then I deleted the same and did save & adjust database.

The issue is after deleting the structure also I am able to see it in the table and also when I check the table getting following message.

Please provide a solution to solve this.

Thanks & Regards,

Nandakumar

[Former Member]

Try SE14 use Select ACTIVATE AND ADJUST. If you want to retain the data then check the "Save Data" box.

Regards

[nandakumar_sasidharan]

Hi Abhijit,

I tried the same but still deleted structure is appearing in the table and also the table is inconsistent.

Regards,

Nandakumar

[former_member195402]

Hi Nandakumar,

please try the folowing:

1. Recreate your APPEND with a dummy field.
2. Activate APPEND and TFK033C
3. Remove The APPEND from TFK033C
4. Activate TFK033C,
5. Delete teh APPEND

Regards,

Klaus

[nandakumar_sasidharan]

Hi Klaus,

I followed Step 1,2,3. But when activating the table I am getting the message "Table is inconsistent".

Regards,

Nandakumar

[mayur_priyan]

Use Where Used Option and find the objects using this structure. Delete the appended field if used. Then you can Activate and Adjust the Table.

[mayur_priyan]

Hi,

Try using function module DD_APPD_DEL to delete the append structures, which enables us to delete the Append structure whether it is in active or inactive status.

Regards,

Mayur

[nandakumar_sasidharan]

Hi Mayur,

I used this function module by passing DEL_STATE as 'N'. Append structure got deleted but still it is appearing in the table.

Regards,

Nandakumar

[vasanthappam]

Hi Nandakumar,

open your table go to Utilities(M) tab->Database Object->Database Utility->click on the tab ''Activate and Adjust database".

Ragards,

vasanth    

[nandakumar_sasidharan]

Hi Vasanth,

I followed all the steps mentioned above including ''Activate and Adjust database".

Issue is still deleted append structure is appearing in table and also I am not able to activate the table.

Regards,

Nandakumar

[Former Member]

Hi Nandakumar,

How you deleting the structure ? Table(SE11) -> Append structure(F5) - > Delete . Same way ?

Thanks & Regards,

Arun

[nandakumar_sasidharan]

Hi Aruna,

Yes through SE11 deleted structure.

Regards,

Nandakumar

[Former Member]

Got confused.

Are you following these steps - SE11 -> Database Table( TFK033C) -> Display - > Append structure(Shows list of append structures of table) - > Select the required one -> Delete

Or you tried to delete the structure directly in SE11

[nandakumar_sasidharan]

First method --> SE11 -> Database Table( TFK033C) -> Display - > Append structure(Shows list of append structures of table) - > Select the required one -> Delete

Regards,

Nandakumar

[vamsilakshman_pendurti]

Hi Nandakumar,

  Before deleting that Append Structure make sure that the fields which are in append structure are not used in any program or any where...if u find any first delete those ....then come to ur Table in  SE11 and delete that structure and adjust in the database level using SE14 Tcode.

Hope  u understand..........

Regards,

vamsilakshman.p

[Former Member]

Hi Nandakumar,

Seems like you followed the right steps....

Lets give a try by following

1.Tell your Basis person to log into system via DDIC username.

2.Perform Table >> Reconstruct..

Hope it helps.

Regards,

Kannan