View and edit the foundation of ERP models

Create a holistic data set by building ERP (Enterprise Resource Planning) models in ERP Data Hub, which encompasses remote tables and extraction tables from the ERP system, as well as read and update operations.

Before you begin

Your administrator must enable the sn_erp_integration.enableModelModification property for you to edit, customize, and clone ERP models and tables. 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. The property must be configured for either a non-production or production state. System properties are maintained in the System Property table [sys_properties], which you can access using the module navigator, or directly typing sys_properties.list in the Navigator Filter.

Note:

You must enable the sn_erp_integration.enableModelModification property on the correct scope. Enabling the sn_erp_integration.enableModelModification on a production instance can create new metadata records when new models and fields are added in ERP Data Hub.

Role required: sn_erp_integration.erp_admin, sn_erp_integration.erp_user

About this task

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.

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.

Procedure

1. Navigate to All > ERP Data Hub > ERP Data Hub Home.
2. Open the ERP models page by selecting the ERP models icon () in the side panel.

   Figure 1. ERP Data Hub models

   

3. Review the list of ERP models.

   Table 1. ERP model columns

   Column	Description
   ERP model name	Name of the ERP model.
   Short description	Brief description of what the ERP model represents.
   ERP tables	Number of ERP tables on the system of record.
   Extraction tables	Number of extraction tables on the ServiceNow AI Platform that are linked to the ERP model.
   Remote tables	Number of remote tables on the ServiceNow AI Platform that are linked to the ERP model.
   Updated	Date and time the model was last updated.

4. Select an ERP model to view and edit the details of the model.

   Table 2. ERP model Details tab

   Field	Description
   ERP model name	Name of the ERP model.
   ERP module	Brief name of the ERP business area on the system of record.
   ERP system	ERP system that represents a connection to a business section of your ERP system of record.
   Application	Application scope the ERP model is linked to. For example, if you create a custom model, the model will be in that scope.
   Short description	Brief description of what the ERP model represents.
   Long text	Any longer description or information about the ERP data model.

5. Optional: View and work with the following on the Details tab of an ERP model:
   • Public comments and private work notes.
   • The Activity stream for the model.
   • File attachments.
6. Select Save.
7. View and confirm that the table entities included in the model by selecting the Model entities tab of the ERP model record.
   View details for an individual table by selecting the table name in the Model entities tab.

   ERP Data Hub automatically scans the linked ERP system to retrieve the latest entity data. However, you can select the refresh icon to update the data on demand.

   Table 3. ERP Model entities tab details

   Field	Description
   Name	Name of the model table on the system of record.
   Alias	Alias for the table. The alias refers to an alternative or substitute name for the table. An alias enables you to assign and customize a recognizable name for easier reference and identification. The alias can be a maximum of 40 characters, and contain a-z, A-Z, 0-9, and underscores.
   Status	Status of the data synchronization, such as Retrieved table data.
   Updated	Date and time the model entity was last updated.

8. Optional: Export the list of tables in the model by selecting the Export button.
   You can select the File type, such as JSON or Excel, and the Delivery type, such as Download.
9. View and confirm the table entity fields included in the ERP model by selecting the Entity fields tab of the ERP model record.

   For a description of the field values, see ERP Data Hub ERP model table field descriptions.

   Figure 2. ERP Data Hub table entity fields

   

What to do next

After you have noted the available fields and tables, you can add new table entities to a model by managing the model. When you manage the model, you can also create read and update operations using table reads and BAPIs (Business Application Programming Interface). For more information, see Managing how models read and update the ERP system.