| Table Relations (Export) (daxch0131s000) |  |
| Use this session to create table relations between logical ASCII files and ERP LN tables per batch in an exchange scheme. Define in the table relation the ERP LN table that contains the data that must be transferred to the logical ASCII files, and assign a name to the physical ASCII file. To create a table relation, do as follows: Enter the sequence number, logical ASCII file code, ERP LN table, and the physical ASCII file name. Select the Use bdbpre check box if you want to use the standard bdbpre program. Enter the number of the index you want to use to export data from the ERP LN table. The ASCII file field is based on increment. Select the Range Active check box if the table relation should use the range for the ERP LN table, as specified in the Field Relations (Import) (daxch0122s000) session. If necessary, select the Active check box to make the relation active and define an execute condition. Note The relations on field level are created in the Field Relations (Export) (daxch0532m000) session. Related topics Introduction to the import module To use conditions in the exchange module To use multilevel exchange schemes Relation between logical ASCII files and physical ASCII files
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.
Table Rel. (Exp.) | The identification number of the table relation in the batch during an exchange process. The number is increased automatically: when you define a new table relation, ERP LN enters a number of value ten greater than the table relation with the highest value.
Table | Enter the code of the table in ERP LN that contains the data that will be exported into an ASCII file during an export procedure. Use multiple table relations to write data from one ERP LN table to more than one physical ASCII file. The ERP LN table is defined by the package code, a module code and a table number. For example, tiitm001. Related topics Relation between logical ASCII files and physical ASCII files
ASCII File | Enter 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 code of the ASCII file 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 Introduction to the Exchange module
ASCII File Name | Enter the name of the physical ASCII file. The file name is an extension on the default relative path. The default relative path is defined in the ASCII Files field under Paths on the General tab in the Exchange Schemes (daxch0101s000) session. Note This path can also be an absolute path. The maximum length of the file name is 11 characters. You do not have to generate the exchange program again if this field is changed. Related topics Relation between logical ASCII files and physical ASCII files
Active | If this check box is selected, the table relation is active and it can be used for data processing in an export process. If this check box is cleared, the table relation are kept for reference purposes. They are not used during the export process. This check box can also be selected if you want to test the exchange scheme, a single table relation, or only a few table relations. Note You do not have to generate the exchange program again if this field is changed.
Use bdbpre | If this check box is selected, the layout of the ASCII file is ignored and the ASCII file is created by the standard bdbpre program. The range, sort index and the ASCII file fields are not considered. If this check box is cleared, the sequential ASCII file is created using the ASCII file fields that are created in the ASCII File Fields (daxch0103s000) session. Note You have to generate the exchange program again if this field is changed. This option is not applicable for an exchange based on audit. Related topics To use audits in the exchange module
Condition | Enter a condition code. The condition must be of the type Boolean. The export of data depends on the return value of this condition. If the return value of the condition is true, the data of the ERP LN table is written to the ASCII file. Note Conditions are also used during an exchange based on audit. Related topics To use conditions in the exchange module To use audits in the exchange module
Range Active | If this check box is selected, the table relation is processed with the limitations that are defined in the Ranges (daxch0112m000) session. If this check box is cleared, the range specified for the ERP LN table is not used in this table relation. Note The range is not active if the export is part of an audit procedure or if the Use bdbpre check box is selected.
Sort on Index | Enter the index number of the ASCII file that will contain data from the ERP LN table. This index will be used if the table is read and the ASCII file is sorted according to this index.
Table Relations Text | If this check box is selected, additional information is added to the table relation. The text is maintained in the text editor. Click Text to start the text editor.