Can we change key field values in table maintenance

[Former Member]

Hi,

I have created Z-table and table maintenance for the same...

In table maintenance..Can we change key field values??

Is there any posibility????

Rayudu

[former_member181962]

Hi Rayudu,

As far as my knowledge is concerned, we cannot modify the key values manually in a table maintanence directly.

We can only modify non key field's values only.

If you still want to modify the key field values, then you need to do that using a program by the Update statement.

Thanks,

Ravi

[Former Member]

you can do it in this way.

open sm30->tablname->edit

snow select the row(s)->copy->change the keyfield values-back->save.

no in that sm30, select records with old primary key and delete->save.

so you got all field similar for those record under modification, only the key field changed.

[Former Member]

Yes i also thought like that only.. But End user wont make many steps and he will modify some key fields and some non key fields at a time and press save...

Thanks for suggestion and confirmations..

Rayudu

[Former Member]

I'm afraid that table maintenance really isn't suitable if users need to change key fields. A custom program would be better.

Another alternative is to change the table so that the original keys are changed to non-key fields and create a pseudo key instead using events.

Rob