Create a holistic data set by building ERP (Enterprise Resource Planning) models in ERP Canvas, 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 Canvas 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 Canvas.

Role required: sn_erp_integration.erp_admin, sn_erp_integration.erp_user

About this task

ERP Canvas 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 Canvas.

An ERP model functions as a staging area that contains all potential fields that 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 Canvas > ERP Canvas Home.
  2. Open the ERP models page by selecting the ERP models icon (ERP model icon) in the side panel.
    Figure 1. ERP Canvas models
    ERP models page
  3. Review the list of ERP models.
    Table 1. ERP model columns
    ColumnDescription
    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.
  4. Select an ERP model to view and edit the details of the model.
    Table 2. ERP model Details tab
    FieldDescription
    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:
    • View and add any public comments and private work notes.
    • The Activity stream for the model.
    • View and add any file attachments.
  6. Select Save.
  7. View and confirm 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 Canvas 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.
  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 Canvas ERP model table field descriptions.

    Figure 2. ERP Canvas table entity fields
    Table entity fields for an ERP model

What to do next

After you've 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.