View and edit ERP remote table details with ERP Data Hub

View and edit details for ERP (Enterprise Resource Planning) remote tables in ERP Data Hub, such as their attachment settings and short descriptions.

Before you begin

Role required:

• To modify remote tables: sn_erp_integration.erp_admin
• To read remote tables: sn_erp_integration.erp_user

About this task

To ensure data integrity, you can't create new remote tables in ERP Data Hub, 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 Data Hub.

For information on adding and removing fields to and from remote tables, see Customize fields for an ERP remote table in ERP Data Hub.

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 Data Hub.

Procedure

1. Navigate to All > ERP Data Hub > ERP Data Hub Home.
2. Open the Remote tables page by selecting the remote tables icon () in the side panel.

   Figure 1. ERP Data Hub remote tables page

   

3. View the details for a remote table by selecting the remote table Name.
4. Optional: Refresh the data stored in the remote table attachment outside of the scheduled cycle by selecting the Refresh attachment data button.
   The remote table attachment is the cached response from the ERP system. If the remote table Attachment setting field is set to Use attachment, ERP Data Hub doesn't call the ERP system when someone fetches data from the remote table.
5. Edit the remote table details as needed.
   For a description of the field values, see ERP Data Hub remote table form field descriptions.
6. View the fields in the remote table by selecting the Remote table fields tab.
7. Optional: View the ERP remote table as a list on the ServiceNow AI Platform by selecting the Open remote table list button.
8. Select Save.