Adjusting Table Structures 

Purpose

The table structure for the Drag&Relate metadata has changed between Workplace Plug-In 2.11 and the SAP Enterprise Portal plug-in. The SAP delivery version of the Drag&Relate metadata still has the old table structure. You therefore must adjust the table structures after importing the metadata.

Process Flow

Start transaction SPO0. You are asked in a dialog box whether you want to migrate the data. This transfers the table entries from the obsolete tables to the new tables.

Once you have performed the migration, the objects exist solely in the SAP delivery version. Then choose Activate SAP Version. This creates a copy of all of these objects in the customer tables and updates certain runtime tables.

Once you have completed the activation step, you can use your existing Drag&Relate data in production operations.

Protecting Modified Drag&Relate Metadata before Overwriting

If you want to protect the existing data against being overwritten by a subsequent (SAP) import, you must choose the option No automatic activation in your system (Settings function in the maintenance transaction). If you subsequently import Drag&Relate data, the system does not activate the data automatically, and you can activate the objects individually manually or using the mass activator. In addition, you can compare the delivery version or the imported version with the active version before activating it. You must set the import switch, since the objects from the SAP delivery version have the status not modified once they have been activated.

If you want to protect only individual objects against being overwritten, for example, because you have actually modified only a few objects, you can also do this by saving the data for these objects and activating them again. This process means that these objects are flagged as modified and are then not automatically overwritten during an import, unless, the import switch has been set accordingly.

Transport of Drag&Relate Metadata to Other Component Systems

If you want to use Drag&Relate metadata in more than one component system, it is sufficient to adjust the table structures in one system and to transport this data. Only obsolete tables are then deleted in the target system. Production data is not affected.

In the maintenance transaction choose Transport Metadata and select the objects to be transported. In the next step, these are written to a transport request, which you can then distribute using the regular transport tools.

Instead of transporting the data, you can, of course, perform the migration manually in all systems.