Standard remote tables for ERP Semantic Mining

  • Release version: Zurich
  • Updated July 31, 2025
  • 1 minute to read

    • ERP Semantic Mining accesses several standard remote tables for ERP (Enterprise Resource Planning) data.

    Important:
    Starting with the Zurich release, ERP Semantic Mining is being prepared for future deprecation. It will be hidden and no longer activated on new instances but will continue to be supported.
    The following remote tables are available through Zero Copy Connector for ERP and ERP Semantic Mining.
    Table 1. Remote tables for Zero Copy Connector for ERP and ERP Semantic Mining
    Label Name ERP module
    SAP Company Code sn_erp_integration_st_sap_company_code Basis
    SAP Country sn_erp_integration_st_sap_country Basis
    SAP Currency sn_erp_integration_st_sap_currency Basis
    SAP Language sn_erp_integration_st_sap_language Basis
    SAP Material Stock sn_erp_integration_st_sap_material_stock Procurement
    SAP Purchase Document sn_erp_integration_st_sap_purchase_document Procurement
    SAP Purchasing Organization sn_erp_integration_st_sap_purchasing_organization Procurement
    SAP Customer Invoice sn_erp_integration_st_sap_customer_invoice Sales
    SAP Distribution Channel sn_erp_integration_st_sap_distribution_channel Sales
    SAP Division sn_erp_integration_st_sap_division Sales
    SAP Sales Customer sn_erp_integration_st_sap_sales_customer Sales
    SAP Sales Delivery sn_erp_integration_st_sap_sales_delivery Sales
    SAP Sales Document sn_erp_integration_st_sap_sales_document Sales
    SAP Sales Organization sn_erp_integration_st_sap_sales_organization Sales
    SAP Sales Revenue Recognition sn_erp_integration_st_sap_sales_revenue_recognition Sales
    SAP Vendor sn_erp_integration_st_sap_vendor Sales
    SAP Vendor Invoice sn_erp_integration_st_sap_vendor_invoice Sales
    SAP Transport sn_erp_integration_st_sap_transport Transport
    For more details on working with remote tables, see Remote tables.
    You can use any of the standard remote tables as data sources when building apps in ServiceNow products, such as:

    You can also access data from the system of record through the Glide API.

    The following is an example of a Glide query that fetches a customer name.
    
var sap_customer_gr = new GlideRecord('sn_erp_integration_st_sap_sales_customer');
sap_customer_gr.get('customer_number', '100032');
sap_customer_gr.getValue('name');