Question:
hi,
please help me...i just update table YARG using transcode SE11.
set YCDAIRT (Aircraft type) as key field.
and after changed some program i just found it no need to set the field as a key. So i do untick the key option at field YCDAIRT but it cannot be activated. Please tell me how to remove key at this table (back to normal).
2nd step try
I try used se14 but the table cannot be adjust because it's error on activate process.(because of removed key)
I also try using SE11 and version management and pull back the previous version but it still error because the table still need to be activated. Activate process still error because of the key.
I try remove all data on YARG table....but activate process still error.
anyone please give me some advise.
Answer:
Are you saying that this table originally had a key eg on MANDT and FIELD1; you added YCDAIRT to the key; you then decided you didn't need the extra key field and unchecked YCDAIRT; you tried to activate it and got a 'Structure change at key level, activate table' error. If so, and if there is data in the table the Activate and adjust database option on the Database Utilities menu will fix and activate the table for you; it there is no data this step is not necessary.
Every SAP table must have a unique key. By removing this key field, you are not, by any chance, leaving the table without a key?
_________________
Using SAP R/3 version 4.7 BASIS 6.20 under SunOS on an Oracle 10.2.0.2.0 database
Answer:
The table still have their original keys, as to YCDAIRT, we need to set it back as normal field. This key is also not a reference key in any other table
Answer:
hi,
Thanks for the feedback. Some information for you.
Previously table YARG had 2 key field which is MANDT and YCDAREG. Then i add YCDAIRT to the key field and after done some testing decided didnt need the extra key field and unchecked YCDAIRT. This table still have MANDT and YCDAREG as key field. when come to activate it the error came out ' Primary key change not permitted for value table YARG. old key field YCDAIRT is now non-keyfield'.
i tried adjust and activate on Database Utility(SE14) but it still error on activate process.
Answer:
I've not seen that error message before, but it sounds as if you have the same problem as this one (found by searching on the error message). Are you using this table somewhere as a check table? If so, I guess you will have to remove all references to it, regenerate it, and recreate the references.
_________________
Using SAP R/3 version 4.7 BASIS 6.20 under SunOS on an Oracle 10.2.0.2.0 database
Answer:
did U try using se14 and adjusting the table.?