You can import transparent, pool, and cluster table definitions as SAP ECC source definitions. You can also import database view definitions. Database views are based on views of transparent tables. PowerCenter does not differentiate between tables and views. You import definitions and extract data from views the same way you import and extract from tables.

You do not need to know the physical table structure on the underlying database server when you import the definition from the logical table on the application server.

When you import table definitions, the Designer displays the table name followed by the business name in the Import SAP Metadata dialog box. You can filter by table name or business name when you connect to the SAP system. Add source names to an import list before you import them. For table definitions, you can select to import all keys or a subset of all keys.

The Designer imports the following SAP table information: