---
sourceDocument: Yokohama Build or modify applications
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/application-development

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Build or modify applications

ft:clusterId :

    - cadev

bundleId :

    - cadev

workflow :

    - Development, Data, and Analytics


---

# Extracting and transforming data in ERP Canvas

# Extracting and transforming data in ERP Canvas {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

ERP (Enterprise Resource Planning) extraction tables enable you to create daily processes that extract large amounts of data. You can then include the extracted data in an ERP model in ERP Canvas.

## Hold large amounts of data in extraction tables {#erp-canvas-extraction-tables__section_vwd_2s4_cyb}

Use extraction tables, which are ETL (extract, transform, and load) data sources, to extract large amounts of data on a regular basis.

For example, you can extract all open purchase orders for the current month from an SAP system into a Glide table once a day at a set time. You can then access that data via ServiceNow AI Platform, such as Source-to-Pay Operations or a PO workspace created in App Engine Studio.

After the extraction process is run, use import sets to map imported data into ServiceNow AI Platform tables. For more information, see [Import sets](https://www.servicenow.com/docs/access?context=import-sets-landing-page&version=yokohama&pubname=yokohama-integrate-applications&ft:locale=en-US).

## Extraction tables use transform table maps {#erp-canvas-extraction-tables__section_ubh_5ml_gyb}

ERP extraction tables save data to a local transform table on the ServiceNow AI Platform. The transform table is a temporary table that holds data during the data integration or transformation process. Transform tables are an intermediary step before data is further processed, cleaned, or loaded into the target destination. For example, after import, the extraction table can run a Glide query on a transform table and save the output to several different target
tables.

If you use a custom transform table, you must first create the table on the ServiceNow AI Platform, and the table must be in the application scope. For more information on creating table transform maps, see [Create a transform map](https://www.servicenow.com/docs/access?context=t_CreateATransformMap&version=yokohama&pubname=yokohama-integrate-applications&ft:locale=en-US).

ETL processes in ERP Canvas are configured in the ServiceNow AI Platform app that needs the data, not ERP Canvas. For example, you can configure an extraction process in a flow in Workflow Studio.

## Automatically available standard extraction tables {#erp-canvas-extraction-tables__section_grc_hs4_cyb}

When you install ERP Canvas, the ServiceNow AI Platform automatically loads standard ERP extraction tables for you to work with. For example, sales, delivery, and procurement tables. For a list of standard extraction tables, see [Standard ERP models and extraction tables for ERP Canvas](https://servicenow-prod.fluidtopics.net/m4iLwFfSD3pDaP_a6l01oQ "ERP Canvas provides a number of standard extraction tables that you can link to ERP (Enterprise Resource Planning) models.").

If you installed ERP Customization Mining, that app populates some additional extraction tables, such as ERP application activity, Collector directory data, and Namespace data.
* **[View ERP extraction tables](https://servicenow-prod.fluidtopics.net/dvCmdlLrcOM6swDIcBgniA)**   
  Work with ETL (extract, transform, and load) processes in ERP Canvas to extract large amounts of ERP (Enterprise Resource Planning) data from the ERP system. Extracted data is stored in Glide tables in the ServiceNow AI Platform.
* **[Add a new ERP extraction table in ERP Canvas](https://servicenow-prod.fluidtopics.net/5Uc92op0q~_JeNgft8dlAg)**   
  Create an ERP (Enterprise Resource Planning) extraction table to capture large amounts of data from the system of record every day, and save the data to a transformation (staging) table. The data is then available on the ServiceNow AI Platform, and you can add the extracted data to an ERP model or remote table.
* **[Select fields for an extraction table in ERP Canvas](https://servicenow-prod.fluidtopics.net/rFHesgWk6HjmZxb5FZfP8w)**   
  Add or remove fields for an extraction table in ERP Canvas. For example, you may want to remove fields with sensitive information, such as birthdays.
* **[Create a table transform map from an extraction table](https://servicenow-prod.fluidtopics.net/t_vP48zRFlOYLORcwShcNg)**   
  In ERP Canvas, create a table transform map from an extraction table and map the source fields with target fields.
* **[Create a scheduled extraction in ERP Canvas](https://servicenow-prod.fluidtopics.net/0wHInDak5uLNIuT0HtHL0Q)**   
  Schedule extraction of information for an ERP (Enterprise Resource Planning) extraction table to capture large amounts of data from the system of record at a regular interval.
* **[Monitor ERP Canvas logged extraction and remote lookup transactions](https://servicenow-prod.fluidtopics.net/WDVd3FDmugmizgGNAIVq~w)**   
  Use the new monitoring feature to track each ERP transaction and its progress. Filter the ERP Canvas task information, such as successes, failures, and more, as needed.