In the ERP Canvas model manager, the mapped value names for inputs and outputs are system-generated by default. While this is convenient, there are times when you might want to specify a unique value that better suits your needs or complies with your existing naming conventions. The good news is, you can manually edit these names any time and even revert to the system-generated ones if needed.
Step-by-Step Example
Let's walk through an example to see how this works.
- Create a Model: Start by creating a new model in ERP Canvas. If you need help with this, see Add a new ERP model.
- Manage Your Model: Once your model is created, select Manage Model and add a read operation. For detailed instructions, see Add an operation to a model in ERP Canvas.
- Add a Read Table Entity: On the read operation, add a read table entity, such as the T005 Countries table. More information can be found in Adding a read, update, or create entity to a model in ERP Canvas.
- Specify Inputs: After retrieving data, select Specify inputs and then Select mandatory fields. The system-generated mapped value appears, for example, as countries_country_region_key.
- Edit the Mapped Value: Change the mapped value to, for example, country_region_key, and select Save. The updated value is displayed, and the operation parameter value changes automatically to match.
Additional Tips
- Adding New Inputs: If you add a new input, the mapped value is system-generated but editable. For instance, you can change countries_nationality to country_nationality for consistency.
- Child Inputs: When adding nested inputs, the system-generated name won't include the parent name. You can edit these names to better reflect their hierarchy.
- Joins: If you're using joins, ensure that the changed name is available on the join fields as well. For more on joins, see Add joins between ERP tables.
- Reverting Changes: If you ever want to revert to the system-generated name, simply remove the field and add it again, or change the mapping type and then revert it.
