topic Re: customized table in Application Development and Automation Discussions

customized table

Former Member — Wed, 22 Nov 2006 02:47:04 GMT

I have a question.

Currently in production there's a Z table with data.

Now we want to add new fields to thise table without affecting the existing data.

In other words, the new field will be empty for existing records...

Question: Will the existing data remain intact when we transport the new field?

Its seems ok in Dev.

Re: customized table

suresh_datti — Wed, 22 Nov 2006 02:50:19 GMT

You have to run the database Utility in Production after transporting the change,using Tcode SE14 with the option 'save the entries'.. this will keep the existing data in tact..

~Suresh

Re: customized table

former_member69765 — Wed, 22 Nov 2006 02:50:25 GMT

yes it will... we have tried it once.. and it worked fine...

Re: customized table

Former Member — Wed, 22 Nov 2006 02:52:35 GMT

yes is sap we can add a new field in se11 without affect the old data.

Regards

Usman

Re: customized table

raja_thangamani — Wed, 22 Nov 2006 02:53:05 GMT

Yes you can add a new fields without affecting the data.(I believe you are not changing the Key fields). After adding the new fields you need to adjust the database using menu Utilities->Database utility-> Activate And Adjust the Database in SE11. Here there will be 2 option, 1 is save data 2. delete data. Choose the save data option. You will be ok.

Raja T

Re: customized table

Former Member — Wed, 22 Nov 2006 04:07:07 GMT

I dont need to do the SE14 again in Prd right?

Re: customized table

Former Member — Wed, 22 Nov 2006 04:15:24 GMT

Hi,

Thats rite adding fields does not drop the existing data. Only if you make changes to the underlying data definition of any field where there is already data the table is dropped and data is lost.

You dont have to use SE14 again on prd. Guess you dont even have to use SE14 for adding new fields. Its only when you make adjustments in the field definition or trying to insert fields inbetween already exisitng fields.

Cheers

Re: customized table

abdul_hakim — Wed, 22 Nov 2006 04:20:51 GMT

yep u can do it very well.

but you need to use the database utility tool in production to keep the database content in place.

Cheers,

Abdul Hakim

Re: customized table

Former Member — Wed, 22 Nov 2006 06:00:55 GMT

Hi duxton,

1. I dont need to do the SE14 again in Prd right?

Yes, u are right, we don't need se14 again in PRD.

2. Adding new fields to the end of the field list,

does not delete the old data.

regards,

amit m.