Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Activate Table

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi

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

SAVE and activate.

then second time try to delete .

8 REPLIES 8

Former Member
0 Kudos

hi

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

SAVE and activate.

then second time try to delete .

Former Member
0 Kudos

Did you define foreign key for that field?

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

Former Member
0 Kudos

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.

0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi

It is just an assumption

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

Regards

MD

matt
Active Contributor
0 Kudos

>

> Can anyone help in this regards.

> Points for sure.

How sad. He was so young.

former_member15255
Active Participant
0 Kudos

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