Adding a derived table
Derived tables are not physical ERP tables although they can be used in the same way. Derived tables use an SQL script to aggregate data from multiple ERP tables and are designed to make it easier for you to obtain information from multiple tables. Several tables with specific columns selected from those tables may be joined to create a new table that combines the required data into a derived table.
You would use derived tables for the following reasons:
-
They are time savers and aid in mapping as all the required fields are available in a single table
- They allow you to aggregate data from different ERP tables
- You can use the same derived table to map multiple destination columns
When you click on a derived table from the left panel, the right panel displays the columns of the derived table and the SQL statement that directs which table the column should come from.
To add a derived table, click Add and provide the following details: