topic Re: remove fields from table key in Application Development and Automation Discussions

remove fields from table key

Former Member — Tue, 06 May 2008 04:41:46 GMT

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?

Re: remove fields from table key

Former Member — Tue, 06 May 2008 04:47:40 GMT

Hi Davidi,

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

you create new table without that 2 fields.

Regards,

Narasimha

Re: remove fields from table key

Former Member — Tue, 06 May 2008 04:49:31 GMT

Are u changing the tables name this only ZT7IL60?

Regards

sas

Re: remove fields from table key

Former Member — Tue, 06 May 2008 04:50:03 GMT

Go to Table utilities .

there you have option for activating the table after modifying.

Try it it will work.

Regards,

Madan Mohan.

Re: remove fields from table key

Former Member — Tue, 06 May 2008 04:58:02 GMT

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./

Re: remove fields from table key

Former Member — Tue, 06 May 2008 05:00:45 GMT

You have provision from SAP like database utility.

SE14.

Try this.

Regards,

Madan Mohan.

Re: remove fields from table key

Former Member — Tue, 06 May 2008 05:24:13 GMT

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

Re: remove fields from table key

Former Member — Tue, 06 May 2008 05:28:48 GMT

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

Re: remove fields from table key

Former Member — Tue, 06 May 2008 05:34:46 GMT

Hi,

Check whether u have already made entries to the table,

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

Re: remove fields from table key

Former Member — Tue, 06 May 2008 06:00:39 GMT

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 ].

Re: remove fields from table key

Former Member — Tue, 06 May 2008 06:02:41 GMT

The final trail is

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

regards

sas