topic Re: Adding new Fields in Application Development and Automation Discussions

Adding new Fields

Former Member — Mon, 17 Nov 2008 10:23:40 GMT

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

Re: Adding new Fields

Former Member — Mon, 17 Nov 2008 10:28:46 GMT

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

Re: Adding new Fields

Former Member — Mon, 17 Nov 2008 11:54:58 GMT

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.

Re: Adding new Fields

Former Member — Mon, 17 Nov 2008 12:14:58 GMT

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

Re: Adding new Fields

Former Member — Tue, 18 Nov 2008 02:52:38 GMT

This is done.

Thanks to all who answered to this question.