Enhancing CDE Content in the Retention Warehouse System

You have used Content Data Extractor (CDE) to extract metadata from the legacy system to be decommissioned. You have copied the corresponding archive file SN_META, which was created by CDE, to the store in the Retention Warehouse system.

If you notice that enterprise-specific tables are missing in Retention Warehouse after the metadata has been transferred, you can complete it without having to go to the legacy system. For this purpose, SAP delivers a program with which you can complete archiving objects in Retention Warehouse in the following cases:

Target	Source of the table to be uploaded	Archiving object namespaces
Uploading metadata to an SN_META archiving object (as an enhanced copy of the original object)	DDIC	All
Since metadata is not available in DDIC: Uploading to DDIC and to an SN_META archiving object (as an enhanced copy of the original object)	XML file (DD03P Format for DDIC)	All
Uploading information to a new SN archiving object	TXT file (SE16 format)	SN_*

Target

Source of the table to be uploaded

Archiving object namespaces

Uploading metadata to an SN_META archiving object (as an enhanced copy of the original object)

DDIC

All

Since metadata is not available in DDIC: Uploading to DDIC and to an SN_META archiving object (as an enhanced copy of the original object)

XML file

(DD03P Format for DDIC)

All

Uploading information to a new SN archiving object

TXT file

(SE16 format)

SN_*

Procedure

Uploading metadata from DDIC to an SN_META archiving object

On the initial screen of the ABAP editor (transaction SE38), call up the S_ILM_SWISS_KNIFE program.
To identify the archiving object, enter the following data:
- SID (Name) and client of the legacy system
- Name of the archiving object to be enhanced
In the Table Name column, enter the tables that the system is to add to the SN_META archiving object together with the names of the archiving objects to be enhanced.
Choose Execute.

Uploading metadata as an XML file to an SN_META archiving object

To prepare the table content in an XML file, proceed as follows:
1. On the initial screen of the ABAP editor (transaction SE38), call up the S_ILM_SK_META_CREATE_DOWNLOAD program.
2. Enter a table that is available in DDIC and that has a structure similar to that of the file to be uploaded.
3. To define the file system on which the system is to create the XML file with the table data, select the Appl. Server File System checkbox as follows:
  - Activated: File system of the application server.
  - Deactivated: File system of your workstation PC
4. Enter the name of the XML file and choose the target directory.
5. Open the XML file with the XML editor and adjust the file content to that of the table to be uploaded (table name, structure, and so on).
To upload the table to the ILM store of the Retention Warehouse system, proceed as follows:
1. On the initial screen of the ABAP editor (transaction SE38), call up the S_ILM_SWISS_KNIFE program.
2. To identify the archiving object, enter the following data:
  - SID (Name) and client of the legacy system
  - Name of the archiving object to be enhanced
3. Enter the following data:
  - Metadata File Name column: Name of XML file
  - Table Name column: Name of the table that the system is to add to the SN_META archiving object together with the names of the archiving objects to be enhanced.
4. Choose Execute.

Uploading table contents to a new SN archiving object as a TXT file

To extract the table content to a TXT file, proceed as follows:
1. On the initial screen of the Data Browser (transaction SE16), enter the name of the table.
2. Choose Table Table Content (F7) .
3. If you want to extract only a part of the table content, enter the relevant selection criteria.
4. To ensure that the list of table lines is displayed so that the entire table can be extracted, set the Maximum Number of Hits relatively high.
5. Choose Execute.
6. Choose System List Save Local File Table Calculation .
7. Enter the target directory and the file names and select Create.
To upload the table to the store of the Retention Warehouse system, proceed as follows:
1. On the initial screen of the ABAP editor (transaction SE38), call up the S_ILM_SWISS_KNIFE program.
2. To identify the archiving object, enter the following data:
  - SID (Name) and client of the legacy system
  - Name of the archiving object to be created
3. Enter the following information:
  - File Name Column: Name of the TXT file
  - Table Name column: Name of the table for which the system is to add SN archiving object information
4. Choose Execute.