09-16-2008 12:19 PM
If I added a new field to a standard table in development environment appending a structure and I transport it to production it will erase the data content in production environment ??
09-16-2008 12:21 PM
09-16-2008 12:21 PM
09-16-2008 12:24 PM
If you transport the table with the option
Transport with entries then the data in Production will be overriden by the data in development but in normal tranport it will create one more field with empty entry it will not delete the data avilable in the production.
Hope this helps
Bikas
09-16-2008 12:28 PM
09-16-2008 12:35 PM
Don't worry about it. If you transport an APPEND structure, it does not affect the contents of the table.
Anyway, that's why you have three systems - so you can see what happens when you transport from Dev to Test, before it destroys your Prod system.
09-16-2008 12:39 PM
Hi,
You have to be careful while appending fields to a standard table through structure. Once you add fields to a standard table you have to adjust these fields in standard table through database utility. Execute transaction SE14 and adjust the fields of standard database table. Otherwise may be in some situations you may get transportation error that table is not active or it may lead to short dump when you are trying to display contents of the table in higher clients.
Regards,
Venkat
09-16-2008 12:42 PM
> Once you add fields to a standard table you have to adjust these fields in standard table through database utility.
Not quite so. Only when fields are being deleted or changed in its definition, then an adjustment via SE14 is necessary (if not automatically done at time of import), not when new fields are being added. This is at least true for Oracle, probably for other DBs as well.
Thomas
P.S. I even had to learn recently that when deleting fields in reverse order of the time they had been added, then there is no adjustment necessary (Last in, first out, if you will...)