Building and managing ERP models to work with ERP data
ERP (Enterprise Resource Planning) models function as templates for sets of tables that give you access to ERP data. Use model management to create read and update operations that access the ERP system with specified inputs and outputs to map fields for use on the ServiceNow AI Platform.
ERP models represent data sets and create a staging area
An ERP model represents the logical structure and organization of data coming from the Enterprise Resource Planning system. ERP models define the entities, attributes, read/update operations, and table join relationships that capture and represent business processes and data elements in the ERP system. When you first open ERP Data Hub, you view a list of the ERP models for your instance.
ERP Data Hub provides a standard set of ERP models, such as SAP Material Stock and SAP Purchase Document. You can also build new models. For a list of standard ERP models, which you must clone to modify, see Standard ERP models and extraction tables for ERP Data Hub.
The ERP model serves as a blueprint for configuring, customizing, and integrating the ERP system to meet your business requirements. An ERP model functions as a staging area that contains all potential fields you can add to remote and extraction tables, and read and update operations. You can then use the tables and queried data as a data source on the ServiceNow AI Platform.
You can also build flows in Workflow Studio to use retrieved ERP data for processes or tasks outside of ERP Data Hub. For more information, see Building flows to read or update the ERP system.
You can view the list of existing ERP models or add a new one to create a custom data set. After you add a remote table, you can manage models to map input and output parameters, update the ERP system using BAPIs (Business Application Programming Interface), and create table joins. You can also create extraction tables that regularly pull large amounts of filtered data from the ERP system. Another option is to use a custom ERP action in Workflow Studio to use queried ERP data in other ServiceNow AI Platform processes.
You can create as many ERP models as needed, though you can't edit their field names.
How ERP models are structured
Each model is linked to ERP tables on the system of record, as well as remote tables and ERP extraction tables on the ServiceNow AI Platform. You can connect the same table to multiple, different ERP models.
- Enables access to field and table information.
- Helps coordinate data synchronization, sharing, and collaboration, enabling seamless integration and operation between the ERP model and the ERP system.
ERP models in ERP Data Hub encompass remote tables from the system of record, as well as APIs and ERP extraction tables and read/update operations, to create a holistic data set. For example, you can have one ERP model for sales orders and another for inventory.
After you install ERP Data Hub, you must enable the sn_erp_integration.enableModelModification property so users can customize ERP models. After you enable the sn_erp_integration.enableModelModification property, ERP Data Hub retrieves all tables and BAPIs (Business Application Programming Interface) to use when managing models. System properties are maintained in the System Property table [sys_properties], which you can access using the module navigator, or by directly typing sys_properties.list in the Navigator Filter.
Managing models to read and update ERP systems
After you create or clone an ERP model, you can specify how ERP Data Hub reads and writes to the ERP system using the ERP model manager page. When managing models, you have the option to use a BAPI, which is a remote procedure SAP function call that's similar to an API.
Each model can have only one read and one update operation defined.
For more information, see Managing how models read and update the ERP system.