Table field Change/Delete

[Former Member]

Hi Experts,

     Need some input. We have a scenario were 9 columns have been deleted from table - these columns had data but they are no longer required or were incorrectly imported. In this scenario if we send a new TR of Table definition with all of these 9 columns removed then how would the system behave?

I understand its not a right practice, but I would like to understand the impact at table level.

Thanks,

Chirantan

[ThomasZloch]

Why not right practice? It can happen that columns are no longer required.

The table will be adjusted in the target system, all data in the removed columns will be lost, the content of the remaining columns will be saved (provided the column names did not change).

This should happen automatically during import, nevertheless check SE14 after import and adjust manually, if required.

I never hurts to download the table contents before import as a backup.

Thomas

[Former Member]

Just to add to Thomas' points...

Be careful about when you do this, depending on what table you are talking about.  The database can take a LONG time to complete the adjustment to a table when fields are removed - it may take only seconds to adjust when adding fields but hours to adjust when removing.  This isn't always the case but it can happen.

A long time ago, I got into a bit of bother with extensions to VBAP and learned that you should also schedule transports of this nature to occur when the specific table isn't being used by any transactions or functionality, as otherwise your users could be in for a bit of frustration!

Good luck...

G.