Standard remote tables for Zero Copy Connector for ERP
Zero Copy Connector for ERP (Enterprise Resource Planning) accesses several standard remote tables for ERP models.
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 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');
Parent Topic:Zero Copy Connector for ERP standard tables, fields, and models