Choose output parameters for an ERP model

  • Release version: Xanadu
  • Updated August 1, 2024
  • 2 minutes to read
  • Specify output parameters for an ERP (Enterprise Resource Planning) system read or update operation in ERP Data Hub to define how fields and parameters are mapped from the ERP system to the ServiceNow AI Platform. Output parameters also define how returned data is stored on the ServiceNow AI Platform.

    Before you begin

    Role required: sn_erp_integration.erp_admin, sn_erp_integration.erp_user

    About this task

    If you're already in the process of managing a model and ready to specify outputs, you can skip to step 5.

    Procedure

    1. Navigate to All > ERP Data Hub > ERP Data Hub Home.
    2. Open the ERP model page by selecting the ERP model icon (ERP model icon) in the side panel.
    3. Select the model that you want to add a read operation to.
    4. Select the Manage model button.
    5. Select the Choose outputs tab.
    6. Review the existing outputs to see if you must add any additional parameters.
      Figure 1. Choose outputs
      Specify operation outputs
    7. Add a new output field or parameter.
      1. Select the added icon (+) next to the last-defined parameter.
        If you're adding a mapped field for a table read operation, make sure to add the field to the applicable table section.
      2. Search for and select the Field name for table reads or Parameter name for BAPI (Business Application Programming Interface) operations.
        The Data type field is automatically updated with the applicable values for your selection.
      3. Enter the corresponding value in the Mapped value field.
      If you're adding a complex, nested parameter, such as an address that includes several other parameters (one for street, one for city, one for country), ERP Data Hub automatically identifies that it needs additional related parameters and creates new, nested parameter rows that you must then populate with the related values. You can nest only parameters with Object or Array as the Data type.
    8. Optional: Add any nested output fields or parameters to choose what data to include from a complex parameter.
      For example, you may have a full billing address in the object parameters, but only need to include the city and postal code as output.
      1. Specify the parent output field or parameter.
      2. Select the settings (ERP settings icon) or add icon (+) for the parent row.
      3. In the modal that appears, select any additional, related fields or parameters to include.
      The parent automatically updates with the related, nested fields or parameters you selected.
    9. Select Save.

    Result

    When you add mapped fields or parameters as outputs and successfully read or update the ERP system, each parameter appears as a field that you can then add to a remote table or an extraction table. Manage the fields for the remote table or extraction table to add the retrieved parameters. For more information, see the following topics: