---
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


---

# View ERP extraction tables

# View ERP extraction tables {#ariaid-title1}

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

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.

## Before you begin

Role required: sn_erp_integration.erp_user

## About this task

ERP extraction tables extract and save data to a 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.

## Procedure

1. Navigate to AllERP CanvasERP Canvas Home.
2. Open the ERP extraction tables page by selecting the ERP extraction tables icon (![ERP extraction tables navigation icon]()) in the side panel.  
3. View the list of ERP extraction tables and note the tables that you can use to build your ERP model.  
   {#view-etl-data-sources__table_gd5_xfz_wxb__entry__2}

   | Column | Description |
   |-|-|
   | Name | Name of the ETL process. |
   | Short description | Brief description of the purpose of the ETL process. |
   | Tables transform map link | Table that the extracted data is cached and stored in. Select the table name to view the table on the ServiceNow AI Platform in a new browser tab. 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). |
   | ERP model | ERP model used in the ETL extraction. Select the ERP model name to view the details. For more information, see [View and edit the foundation of ERP models](https://servicenow-prod.fluidtopics.net/sy8MBvDgp7_g6O~XG79gMA "Create a holistic data set by building ERP (Enterprise Resource Planning) models in ERP Canvas, which encompasses remote tables and extraction tables from the ERP system, as well as read and update operations."). |
   [Table 1. ETL source columns]

   {#view-etl-data-sources__table_gd5_xfz_wxb}
4. **Optional:** View the details for an extraction table by selecting the table name.

## What to do next

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).

*[\>]: and then