customized table

[Former Member]

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.

[suresh_datti]

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

[former_member69765]

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

[Former Member]

hi

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

Regards

Usman

[raja_thangamani]

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

[Former Member]

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

[Former Member]

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

VJ

[Former Member]

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.

[abdul_hakim]

hi

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