remove fields from table key

[Former Member]

I define a customize table (maintenance only by cust., not SAP import).

5 of the fields are the table keys.

When I remove 2 fields from the key and adjust the table I get the following errors

“Primary key change not permitted for value table ZT7IL60”

“Activation of Table ZT7IL60 not possible (please check)”

Any clue why and how to remove some fields from the key?

[Former Member]

Hi Davidi,

You can't delete fields having primary key in u r table.

you create new table without that 2 fields.

Regards,

Narasimha

[Former Member]

Are u changing the tables name this only ZT7IL60?

Regards

sas

[Former Member]

Go to Table utilities .

there you have option for activating the table after modifying.

Try it it will work.

Regards,

Madan Mohan.

[Former Member]

As I wrote I adjust the table (SE14 transaction or table utility) but I got the same error message

any other answers will be appreciate

[Former Member]

Could you please answer my question..or do one thing just see wherever the fields are availbale in table.do database adjustment ....hope it workks fine..

Reward if useful

regards

sas

[Former Member]

The final trail is

"Maintainance allowed' Check whether this option sis allowed or not..?

regards

sas

[Former Member]

hi there,

the reason for this error can be any....

may be you are using that field in the foreign key reference of another table. thats y it is not allowing the change option as it will affect other table's values.

another thing can be the one suggested in the above post.

do reply if any of the methods mentioned helps.

Do reward if helpful./

[Former Member]

You have provision from SAP like database utility.

SE14.

Try this.

Regards,

Madan Mohan.

[Former Member]

Hi,

Check whether u have already made entries to the table,

please remove those table entries and try to adjust and activate the table

[Former Member]

Hi,

Delete the key field(s). Save it. (Dont activate).

goto transaction se14.

Activate and adjust database [ you can save the existing data

or can delete all the records ].