The data, e.g. an invoice, a purchase order, a packing slip, or a sales order, is usually saved in different database tables.
It is advisable to have knowledge of the data model of the ERP system.
The Map primary key fields to the selected tables function provides you with an option to map the different fields of the database tables of the ERP system using primary key fields
If you define an process based on the line item data, you must use the function Map primary key fields to the selected tables. You use this function to specify which key field in the main table corresponds to which key field in the sub-table of the database.
The mapping of the fields is therefore unique.
Sample mapping in "Map primary key fields to the selected tables"
For example, enter the following syntax in the function: Field(1)=Field(4),Field(3)=Field(5)
This syntax means the following:
-
In the main table (header), the primary key is split between fields 1 and 3.
-
In the sub-table (items), the same content of the main table fields 1 and 3 is in fields 4 and 5.
Using the syntax Field(1)=Field(4),Field(3)=Field(5), the application searches the sub-table in fields 4 and 5 for data located in fields 1 and 3 in the main table.
Tip
You can also use a short form in Map primary key fields to the selected tables: Specify the fields separated by commas and the field pairs separated by semicolons. Example: 1,4;3,5;
You can add the short form to the long form at any time: Field(1)=Field(4),Field(3)=Field(5)2,6
The short form is always automatically resolved into the long form.