Add table joins and join conditions to an ERP model
-
- UpdatedAug 3, 2023
- 2 minutes to read
- Vancouver
- Building applications
Link multiple ERP (Enterprise Resource Planning) tables from the system of record to build an ERP model in ERP Canvas using joins.
Before you begin
Role required: sn_erp_integration.erp_admin, sn_erp_integration.erp_user
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.
Join fields defines the common attribute or key used to connect records in a child table with their corresponding parent records.
Procedure
Result
After you build an ERP model, work with remote tables to customize which fields to include. For more information, see Using ERP remote tables in ERP Canvas.