Adding new Fields

[Former Member]

Hi Gurus,

I have a ztable with 20 fields with huge data (6.7 million records) in it.

Now I have a requirement to add one more field in between the table.

My question is, if I add that new field to the table and transport to production will it cause any problem to the existing data...?

please give me an adivice in this regard.

Thanks in advance...

Best Regards

Venki

[Former Member]

Use an Append structure to add the field to your table and transport it. Then it will have no problems.

[Former Member]

Hi Venki,

It will not cause any problem. But check the reports or programs where that ztable is used and check the select queries used in the program and the internal table declerations. As they will go to dump it the internal table is defiend other that the table type.

Regards

Thabitha.

[Former Member]

Hi Venkatesh,

You can add a new field in the table. It will not create any problem but after adding the field you have to go to SE14 and give your table name and then in next screen you have to press "Activate and Adjust Database" button.

You have to do the same because you already have data in your table so this button adjusts the data at the database level in your table.

Cheers!

Sidharth

[Former Member]

This is done.

Thanks to all who answered to this question.