09-25-2008 10:02 AM
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.
09-25-2008 10:08 AM
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 .
09-25-2008 10:08 AM
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 .
09-25-2008 10:09 AM
Did you define foreign key for that field?
Delete the foriegn key first and then try to delete primary key.
09-25-2008 10:12 AM
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.
09-25-2008 10:20 AM
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.
09-25-2008 10:13 AM
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.
09-25-2008 10:13 AM
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
09-25-2008 10:17 AM
>
> Can anyone help in this regards.
> Points for sure.
How sad. He was so young.
09-25-2008 10:30 AM
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