Standard remote tables for ERP-CM
ERP Customization Mining (ERP-CM) accesses several standard remote tables for ERP (Enterprise Resource Planning) data.
The following remote tables are available through ERP Data Hub and ERP-CM.
For more details on working with remote tables, see Remote tables.
| 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 |
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');