---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Add joins between tables

# Add joins between ERP tables {#ariaid-title1}

Release version: Brazil  
Updated October 22, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read  
Link multiple ERP (Enterprise Resource Planning) tables to build an ERP model in Zero Copy Connector for ERP using table joins.

## Before you begin

Table joins require a read operation that uses table read entities. For more information, see [Add an operation to a model in Zero Copy Connector for ERP](https://www.servicenow.com/docs/aImlQVW8gdvPX~CTNzODkg "Add an operation to an ERP model in Zero Copy Connector for ERP to define how the model retrieves data, writes data, or creates a new instance of the business object.").  
When you add table joins, the parent table is the first table listed on the Manage entities tab of the ERP model manager page. Child tables pull information from the parent table.  
Note:  
* If you have more than one table for an operation, you must join the tables.
* You can create table joins only for table read operations, not for operations that use a BAPI (Business Application Programming Interface).
{#erp-canvas-add-join-data-model__ul_gr4_wdm_gbc}

Role required: sn_erp_integration.erp_admin

## About this task

Table joins link different tables through shared fields. Joins enable you to access data from multiple tables based on logical relationships between them. The relationship can be conditional, which you
specify using join conditions. Use inner joins or outer joins. An inner join returns records that have matching values in both tables. Outer joins combine left and right join results to return all rows with matches or null
values.

Join fields define the common attribute or key used to connect records in a child table with their corresponding parent records.

## Procedure

1. Navigate to AllZero Copy Connector for ERPZero Copy Connector for ERP Home.
2. Open the ERP model page by selecting the models icon ![]() in the side panel.
3. Select the model that you want to add a join to.
4. Select the Manage model button.
5. Select the Read operation that you're adding the table join to.
6. **Optional:** Add the tables to join as Table read operation entities if they haven't yet been added to the model.  
   For more information, see [Adding an entity to a Zero Copy Connector for ERP model](https://www.servicenow.com/docs/WCTGTfbJwQTpW78bEv2N5g "Add an entity to a model operation to specify the ERP data that Zero Copy Connector for ERP reads, creates, or updates when the model runs.").

7. Rearrange the tables on the Manage entities tab to place the parent table for the join as the first table listed on the ERP model manager page.  
   Important:  
   Reordering deletes any existing table joins for the reordered entities.
   1. Select the Rearrange order button.
   2. Drag the tables to the order that you want, with the parent table as the first table listed on the page.
   3. Select the Confirm reorder button.
   {#erp-canvas-add-join-data-model__substeps_af1_cc2_bbc}
8. Select the Specify inputs tab, which is where you update input parameters to specify table join as a parameter.  
   The input parameters for each table appear.
9. Create a table join parameter.
   1. In the Output parameter(s) section, identify the parameter that will be the parent join field and note its name.
   2. Add a new mapped field row in the table by selecting the add (+) icon.
   3. Enter or select the parent join Field name in the new field row.
   4. Select Join from the Type field.  
      The value in the child table Mapped value field updates automatically with the joined field name.

      For example, in the SAP Material Stock model, you can specify
      Material as the parent field in the Field name field and join it to the material ID. Enter <kbd class="ph userinput">mard_material_matnr</kbd> in the parent
      Mapped value field.
   5. Select Save.

   {#erp-canvas-add-join-data-model__substeps_vnx_md2_bbc}  
   Figure 1. Table join fields
10. **Optional:** Add or update any output parameters as needed in the Output parameters section.  
    The joined parameter that you added to as an input is automatically added to the Choose output tab.

    For more information, see [Choose output parameters for a model](https://www.servicenow.com/docs/O7jI9elC8QwfGvKGRNGetg "Specify output parameters for a model operation in Zero Copy Connector for ERP to define which ERP fields map to the ServiceNow AI Platform and how the returned data is stored.").

## Result

After you're done creating table joins, you can specify where the returned ERP data goes, and build flows that retrieve and output the data. For more information, see the following topics:

* [Specifying where ERP system data is saved](https://www.servicenow.com/docs/kEXuGLuvV6INmB8pMQZV4Q "Use the data that Zero Copy Connector for ERP (Enterprise Resource Planning) retrieves from ERP systems in remote tables and extraction tables, or add it to flows as data pills in Workflow Studio.")
* [Building flows with the Zero Copy Connector for ERP Use ERP Data action](https://www.servicenow.com/docs/sPMDa7zTkPJ4bGOcti1FyA "Use the Use ERP Data action in Workflow Studio to build flows that read or update ERP data through a Zero Copy Connector for ERP model. Filter each request with input parameters such as an order ID.")
{#erp-canvas-add-join-data-model__ul_iqy_f32_bbc}

*[\>]: and then