topic Re: Adding custom fields to DB table in Application Development and Automation Discussions

Adding custom fields to DB table

Former Member — Thu, 21 Aug 2008 04:24:11 GMT

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

Re: Adding custom fields to DB table

former_member196280 — Thu, 21 Aug 2008 04:29:30 GMT

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

Re: Adding custom fields to DB table

Former Member — Thu, 21 Aug 2008 04:34:04 GMT

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

Re: Adding custom fields to DB table

Former Member — Thu, 21 Aug 2008 05:45:53 GMT

Any suggestions please.

Thanks

Re: Adding custom fields to DB table

Former Member — Thu, 21 Aug 2008 05:59:10 GMT

Got it, Thanks

Re: Adding custom fields to DB table

anshumita_baksi — Thu, 21 Aug 2008 06:05:07 GMT

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.

Re: Adding custom fields to DB table

Former Member — Wed, 03 Mar 2010 12:53:00 GMT

Hi PC,

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

Best Regards,

Pradeep