topic Re: Regarding Table Adjustment in Application Development and Automation Discussions

Regarding Table Adjustment

Former Member — Mon, 08 Dec 2008 12:39:16 GMT

Hi All,

In EKPO table there is one include structure with name CI_EKPODB, In that i have added one field . But now i don't want thet field ..i have deleted that field.so structure is in Inactive mode because there is no field. But there is no field in Structure even it showing that field in table EKPO.

How to solve my Problem.

thanks & regards,

laxmi

Re: Regarding Table Adjustment

Former Member — Mon, 08 Dec 2008 12:49:18 GMT

Hi,

Use this path to adjust the database...

SE11...give the table name and press change button..follow the below path

Utilites->Database object-> Database utility...Press the Avtivate and Adjust Database

Re: Regarding Table Adjustment

Former Member — Mon, 08 Dec 2008 13:05:53 GMT

Hi,

As told by Avinash, try to do that.

Thanks.

Re: Regarding Table Adjustment

Former Member — Mon, 08 Dec 2008 14:10:43 GMT

Hello,

Try to adjust the table by database utility, always select the option for keeping the data while adjusting.

Thanks,

Jayant

Re: Regarding Table Adjustment

tarangini_katta — Mon, 08 Dec 2008 14:51:54 GMT

Hi lakshmi,

It is howing beacuse in ur stcture there is no field in that but u can't activate u r include beavuse there were no fields in the include.

Ur include is not activated taht's y value will come in the EKPO table laso.

Go to SE 14 give u rtable name 'Activate and adjust database table.

thanks,

Re: Regarding Table Adjustment

Former Member — Mon, 08 Dec 2008 21:34:08 GMT

Why are you so hasty to write a reply to the post. Do review your reply before posting.

Regards

Raj

Edited by: Rajasekhar Dinavahi on Dec 9, 2008 3:05 AM

Re: Regarding Table Adjustment

Former Member — Tue, 09 Dec 2008 06:13:21 GMT

Hi..Avinash ,

Thank you for your reply.

But thing is I am working on EKPO Table , that is not a customized table..

Thanks & Regards,

Lakshmi

Re: Regarding Table Adjustment

Former Member — Tue, 09 Dec 2008 06:22:57 GMT

Hi,

Either it is stanard table or Custimizing table you need to adjust the database using Database utiltiy only. Or you can ask the basis person to activate the table.

Re: Regarding Table Adjustment

Former Member — Tue, 09 Dec 2008 08:59:40 GMT

Hi Avinash,

Even I am getting same Problem. In SE14 i have given table name and activated..But even the field is existed in Tables even i deleted the field in Structure..Here my problem is i am unable to activate the structure by using SE14.

so let me know how to activate the structure...if there are no fields.

Thanks & Regards,

Laxmi.

Re: Regarding Table Adjustment

Former Member — Tue, 09 Dec 2008 09:22:29 GMT

Hi Lakshmi,

There is a delete row button in SE11 tcode you need to use this rather simply removing it manually and then activate your structure first and then come back to the table and activate it again then go to SE14 activate and adjust by selecting the SAVE radio button

This might help you

Regards

Ramchander Rao.K

Re: Regarding Table Adjustment

Former Member — Wed, 10 Dec 2008 07:18:36 GMT

thank you for your replies....