topic Re: Activate Table in Application Development and Automation Discussions

Activate Table

Former Member — Thu, 25 Sep 2008 09:02:51 GMT

Hi,

In table TGSB, we have included BUKRS(Company code) as a key field along with GSBER(Business area) and activated.

Now users dont want this field, so when we try to remove this field and activate it gives the following error.

"Primary key change not permitted for value table TGSB

Activation of Table TGSB not possible (please check)".

I've already tried SE14 (database utility->adjust&activate database.

Can anyone help in this regards.

Points for sure.

Re: Activate Table

Former Member — Thu, 25 Sep 2008 09:08:28 GMT

for hit & trial u can try by first making the field as Non- primary key .

SAVE and activate.

then second time try to delete .

Re: Activate Table

Former Member — Thu, 25 Sep 2008 09:09:47 GMT

Did you define foreign key for that field?

Delete the foriegn key first and then try to delete primary key.

Re: Activate Table

Former Member — Thu, 25 Sep 2008 09:12:38 GMT

Hi,

Try this.

Make the key as non-primary key, then also check whether it is a check table for any table if so remove the foreign key relationship with this field and try activating it.

Sharin.

Re: Activate Table

Former Member — Thu, 25 Sep 2008 09:13:40 GMT

first change enhancement category to can be enhanced.

then activate.

it will be activated

delete if any maintainance view exist

then delete whole table from se14

then go to se11 and open in change and activate it.

delete all data by taking backup of it.

Regards,

Purvesh.

Re: Activate Table

Former Member — Thu, 25 Sep 2008 09:13:48 GMT

It is just an assumption

If you remove all the entries from table TGSB and than delete and acitivate, it may work

Regards

Re: Activate Table

matt — Thu, 25 Sep 2008 09:17:04 GMT


> Can anyone help in this regards.
> Points for sure.

How sad. He was so young.

Re: Activate Table

Former Member — Thu, 25 Sep 2008 09:20:09 GMT

Hi ,

Thanks alot for all your replies.

This table acts as a check table in some other tables.But not for field BUKRS,only for the field GSBER.

If it happened automatically how to check for which table it has been defined as a check table(For field BUKRS and not for field GSBER).If we can find this then we remove the foreign key relationship with this field .

If we delete the whole table in SE14, will it be still available in SE11.is it sure?

Thanks,

Ponraj.s.

Re: Activate Table

former_member15255 — Thu, 25 Sep 2008 09:30:15 GMT

Hello,

As per RDMS concept any aleration to the key fields, first all the data in the transparent table has to be deleted make require changes to the table and then activate it. Now as it got key fields with data that the reason it not able to activate it

regards

suresh nair