How to change data element in table?

[Former Member]

Hello all:

I just need to change data element for a field in some Z table. I know I can do it through SE11 but I just want to make sure if there is anything I should be aware of? Are there any other steps I should perform apart from making changes through SE11? Any information you could provide would be great.

Thanks.

Mithun

[Former Member]

Hello all:

I just need to change data element for a field in some Z table. I know I can do it through SE11 but I just want to make sure if there is anything I should be aware of? Are there any other steps I should perform apart from making changes through SE11? Any information you could provide would be great.

Thanks.

Mithun

[Former Member]

It depends what you change. If you change the name, you will also have to change any programs that access the table. If you change the lenght of the DE, you may have to adjust the table.

Rob

[Former Member]

I just have to change the length of data element for a column from NUMC(5) to NUMC(3).

Thanks.

Mithun

[Former Member]

You should have no problem. When you activate it, if it tells you that you need to adjust the table, say 'yes' and 'keep data'.

Rob

[Former Member]

Hi,

deleting/changing a data element which is used in an active tables, will lead to a short dump next time the table/field will be used. Also it may lost the data as well.

Please do where is used the data element and see the impact prior to make changes.

Regards,

Ferry Lianto

[Former Member]

Hi Mithun,

Yes, you can change the table using SE11. After saving, check for errors and activate. Using Menu, Utilities

-> click on Database Utility and then click on 'activate and adjust database'.

Hope this helps.

Thanks,

Srinivasa

Message was edited by:

Srinivasa Bhanuprasad Moningi

[Former Member]

Thanks everyone. I went to SE11 and when I double clicked on my data element it opened up a window with a some domain name EX Zxxx. I want to change this domain to Zyyy but it is opening this window in DISPLAy mode only! How can I change the domain here? Is there any other way to do this?

Thanks.

Mithun

[Former Member]

Don't double click on it. Just change it on the first screen.

Rob

[Former Member]

Hi,

Go to SE11 -> Enter domain -> Change -> ...

Regards,

Ferry Lianto

[Former Member]

Thanks everyone. I rewarded full points.

Mithun