| Field Relations (Export) (daxch0132s000) |  |
| Use this session to create relations between ASCII Field fields and ERP LN table fields per batch in an exchange scheme. To create field relations, do as follows: Enter a serial number and the name of the ASCII Field field. Define under Based on how the ASCII Field field receives its value and select the appropriate ERP LN table field, condition or constant. Enter the element number of an array field, if the ERP LN field is defined as an array field in the data dictionary. Click Edit Text to create additional text for the field relation. Note The relation on table level is created in the Table Relations (Export) (daxch0531m000) session. Related topics To use a details session Introduction to the import module To use conditions in the exchange module
Fields | Description
Exchange Scheme | The exchange scheme code. The exchange scheme is created in the Exchange Schemes (daxch0501m000) session.
Batch | The batch code in an exchange scheme. A batch is created in the Batches (daxch0104m000) session.
Exp. Table Rel. | A sequential number that identifies the table relation. It makes the table relation unique in the batch.
Table | The code of the table in ERP LN that contains the data that will be exported into an ASCII file during an export. The ERP LN table is specified in the Table Relations (Export) (daxch0531m000) session.
ASCII File | The code of the ASCII file that contains data from the ERP LN table during an export procedure. To copy fields of an ASCII file table automatically the ASCII file code must be the same as the code of the ERP LN table. This is an option if you do not have a data definition file of the ASCII file. Note The ASCII file code represents the logical ASCII file and it is created in the ASCII Files (daxch0102m000) session. Related topics Relation between logical ASCII files and physical ASCII files
Serial No. | Enter a serial number to make the field relation unique in the table relation. The serial number is only used as an identifier and does not have to be sequential. Note The number is increased automatically: when you define a new field relation, ERP LN enters a number of value ten greater than the field relation with the highest value. Because numbers like 10, 20, 30, and so on are used, it is easy to insert field relations at a later stage.
Text | If this check box is selected, additional information is added to the field relation. The text is maintained in the text editor. Click Text to start the text editor.
ASCII Field | Enter the code of the ASCII file field that will contain data that is to be transferred from a field in the ERP LN table during an export procedure. Note The ASCII file code represents the logical ASCII file. It is created in the ASCII Files (daxch0102m000) session.
Table Field | If this check box is selected, the data transfer is based on the data in a ERP LN field. Note Select the ERP LN field in the following field.
Table Field | To export data into an ASCII file field, enter the code of the field in a ERP LN table. Related topics Relation between logical ASCII files and physical ASCII files
Array Element | The element number of an array field. This field is only applicable if the Table Field field is defined as an array field in the data dictionary. The elements in an array can be filled individually. Note The element number cannot exceed the array depth.
Condition | If this check box is selected, the export process can be manipulated by using conditions. Note The conditions are created in the Conditions (daxch0114m000) session. Related topics To use conditions in the exchange module
Condition | Enter the condition that is used in the transfer of data from the ASCII file field to the ERP LN table field. The return value of the condition will be used to fill the ERP LN table field. Note Condition are defined in the Conditions (daxch0114m000) session. Related topics To use conditions in the exchange module
Constant | If this check box is selected, a constant value is loaded into the ERP LN table field.
Constant | Enter the value that will be assigned to the ERP LN table field during export. Note A constant can only be used if the ERP LN table field is left blank and no condition is used.