Adding custom fields to DB table

[Former Member]

Hi,

I added custom fields in std DB table using CI_* , activated table using SE14. Now I want to remove the added custom fields , I deleted the CI_* using SE11. It still appears in DB table, I mean I dont expect to disappear from DB table, when I double click it still takes to structure screen. I deleted include from SE80 also selecting Package, activated and adjusted DB table from SE14 after deletion, but it still appears and when I check the attributes it shows the same package , how to reset the CI_* , bottom line ,I want to make DB table normal as before, because of that I am getting dumps when I execute std DB table related T codes.

It should be done in easy way but not able to get breakthrough.

Please let me know your suggestions.

Thanks

[former_member196280]

Create a new structure with all required custom fields that are to be added to standard table.

Now from menu, goto--> append structure.

It will add all the fields available in the structure to your table.

Similarly, you can delete the newly added structure.

Rgds,

SaiRam

[Former Member]

Thanks Sai for your reply, but I dont want to add custom fields anymore to DB table , I want to remove them from CI in which I added. Please let me know your suggestions.

Thanks

[Former Member]

Any suggestions please.

Thanks

[Former Member]

Got it, Thanks

[anshumita_baksi]

Hi Sai,

Try to assign the CI_* structure to $temp,i.e as local object and then activate it first.

After that, try deleting the local object and adjust the table using SE14.

If still it does not work, ask your BASIS consultant to do an "Alter table".

May be that works!

Thanks & Regards,

Anshumita.

[Former Member]

Hi PC,

I have got the similar issue. COuld you please tell how to reset that structure CI_*.

Best Regards,

Pradeep