Table field type change (need a faster process)

[chaiphon]

In the process of changing table field type

1) copy all data out from system

2) delete data in the table

3) change field type

4) upload data back to the table , Finished.

It is very fast,

but in the case of changing characteristic attribute in batch(022) classification, it is very slow. I have to

1) Copy all characteristic value of batch and material (by creating customized program)

2) Download assigning material and assigning batch (by creating customized program)

3) Delete class in all material and batch (by using SAP standard program)

4) Delete class (by using SAP transaction)

5) Change characteristic attribute (by using SAP transaction)

6) Recreate class with same characteristic (by using SAP transaction)

7) Assign class to material (by using CATT)

😎 Assign class to batch (by using CATT (Very slow))

9) Upload characteristic value back to material and batch (by creating customized program).

Does anyone ever change characteristic attribute in go-lived system? Do you use the same process as me? If not please suggest the better process or any techniques that can faster the work?

Best Regards,

Chaiphon (To)

[christian_wohlfahrt]

Hi Chaiphon!

1..9 that's really a terrible long way to a new type.

At least for the first part I can give you a shorter way:

Prerequisite: the field content can be converted into the new field type by a 'move'. E.g. change char18 to char20.

Then you can change the table (/field) definition in SE11 and choose Utilities->Database Utility, Button 'Activate and adjust database' with option 'save data'.

That's not possible for characteristics. But maybe it's possible to perform your steps faster. Perhaps there are BAPIs / Idocs for some of your steps, have a look. They will be faster than CATT, but don't bother searching for fast steps.

There are also some OSS-notes with hints to improve performance of class system -> your transactions will react faster. That's of course also good for daily life.

It's also important to update database statistics (DB20). Especially if you just filled a table completely new, you should update the statistics immediately (before / parallel to the next step).

Regards,

Christian