Standard remote tables for Zero Copy Connector for ERP

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • Zero Copy Connector for ERP accesses several standard remote tables for ERP (Enterprise Resource Planning) models.

    The following remote tables are available through Zero Copy Connector for ERP and ERP-CM.
    Table 1. Remote tables for Zero Copy Connector for ERP and ERP-CM
    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');