Table types are required to determine the data source of the tables in the entity. Entities can only include one source for the Insert into Archive Tables step. Some SAP tables store data in both the database and in an external file system. A table is included in two separate entities if the table has data in the database and archived data in ADK files in an external file system. One entity includes the database as the source. The other entity includes the external file system as the source for the archived data.

The Import Metadata job adds one of the following table types to the imported metadata in the ILM repository:

Converted Transparent Table with Archived Data

Logical tables that store archived data in ADK files in an external file system. This table type is for archived data from transparent HR PCL1-PCL5 cluster tables and the STXL text table.

Pool Cluster

Pool and cluster logical tables that store data in the database in an SAP proprietary format.

Pool Cluster with Archived Data

Pool and cluster logical tables that store archived data in ADK files in an external file system.

Transparent Table

Physical tables that store data in the database.

Transparent Table with Archived Data

Physical tables that store archived data in ADK files in an external file system.

The pre-packaged entities for SAP include tables with the

Converted Transparent Tables

and

Attachments

table types. The job does not add these table types as the table types are already included in the pre-packaged entities.