Standard remote tables for ERP Semantic Mining

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.

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 ERP system 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');

Parent Topic:ERP Semantic Mining standard tables and fields