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

Deleting append structure from standard table issue

nandakumar_sasidharan — Fri, 01 Aug 2014 04:12:38 GMT

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

Re: Deleting append structure from standard table issue

Former Member — Fri, 01 Aug 2014 04:32:38 GMT

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

Regards

Re: Deleting append structure from standard table issue

nandakumar_sasidharan — Fri, 01 Aug 2014 04:42:54 GMT

Hi Abhijit,

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

Regards,

Nandakumar

Re: Deleting append structure from standard table issue

mayur_priyan — Fri, 01 Aug 2014 04:46:12 GMT

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

Re: Deleting append structure from standard table issue

Former Member — Fri, 01 Aug 2014 04:47:49 GMT

Hi Nandakumar,

please try the folowing:

Recreate your APPEND with a dummy field.
Activate APPEND and TFK033C
Remove The APPEND from TFK033C
Activate TFK033C,
Delete teh APPEND

Regards,

Klaus

Re: Deleting append structure from standard table issue

nandakumar_sasidharan — Fri, 01 Aug 2014 04:57:33 GMT

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

Re: Deleting append structure from standard table issue

nandakumar_sasidharan — Fri, 01 Aug 2014 05:01:02 GMT

Hi Klaus,

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

Regards,

Nandakumar

Re: Deleting append structure from standard table issue

vasanthappam — Fri, 01 Aug 2014 05:02:24 GMT

Hi Nandakumar,

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

Ragards,

vasanth

Re: Deleting append structure from standard table issue

nandakumar_sasidharan — Fri, 01 Aug 2014 05:07:43 GMT

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

Re: Deleting append structure from standard table issue

Former Member — Fri, 01 Aug 2014 05:35:48 GMT

Hi Nandakumar,

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

Thanks & Regards,

Arun

Re: Deleting append structure from standard table issue

nandakumar_sasidharan — Fri, 01 Aug 2014 05:42:12 GMT

Hi Aruna,

Yes through SE11 deleted structure.

Regards,

Nandakumar

Re: Deleting append structure from standard table issue

Former Member — Fri, 01 Aug 2014 05:52:31 GMT

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

Re: Deleting append structure from standard table issue

nandakumar_sasidharan — Fri, 01 Aug 2014 06:00:31 GMT

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

Regards,

Nandakumar

Re: Deleting append structure from standard table issue

vamsilakshman_pendurti — Fri, 01 Aug 2014 06:12:24 GMT

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

Re: Deleting append structure from standard table issue

mayur_priyan — Fri, 01 Aug 2014 06:23:36 GMT

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.

Re: Deleting append structure from standard table issue

Former Member — Fri, 01 Aug 2014 06:34:16 GMT

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