ERP (Enterprise Resource Planning) remote tables in ERP Canvas enable you to view and query data from the ERP system of record on the ServiceNow AI Platform.

Note: ERP Canvas doesn't replicate data into the ServiceNow AI Platform. It mirrors data that lives in the ERP system of record, and remains protected there.

Remote tables are linked to ERP models

Each ERP remote table is connected to one ERP model, which links the remote table to the ERP system and other related values. When you build a remote table, you can add any of the fields that ERP Canvas finds when scanning the ERP system of record, which is connected through the ERP model. Scanning for and adding fields ensures that all necessary fields are available, such as when using the table as a data source when building an app.

The connected ERP model, which is defined on the remote table Details tab, controls the available fields on the remote table. If you change the ERP model for a remote table, the available fields change as well.

Limitations of remote tables

To ensure data integrity, you can't create new remote tables in ERP Canvas, but you can clone existing ERP models and extend standard ERP remote tables to customize them. For more information, see Clone an ERP model in ERP Canvas.

ERP remote tables have a limit of 1,000 records. If you need a larger amount of data, use an ERP extraction table. For more information, see Extracting and transforming data in ERP Canvas.