| # Ranges (daxch0112m000) Use this session to limit the export procedure to a range of records. You can, for example, define ranges to export only Items belonging to a particular item group, or employees belonging to a specific department. This session allows you to use relational and logical operators to create range-limitation logic expressions that control the export process. Only active records that match the condition are exported. This enables you to transfer a smaller file between systems. The range is made active in the Table Relations (Export) (daxch0531m000) or Table Relations (Export) (daxch0131s000) session. Note If you have started this session by zooming, you can only find and select a record. Restrictions per data type of the LN table field Data type date The entered date field must be of the Default Date Format The plus or minus signs can be used to change the current date. For example, +2 adds two days to the current date. The character # can be used for the current date. Data type string/multibyte The domain of the LN table field determines if a field is justified to the left, right or center or converted to upper or lower case. Data type numeric Only numeric values can be entered For the operators In or Not In, the value must be entered as follows: The set of values must be placed between parentheses. For data type string, each item in the set of values must be placed between double quotes. Example For a numeric field (1,2,5,7). For a string or multibyte string, then double quotes should be added ("a","b"). Exchange Scheme Specifies the exchange scheme code. Batch Specifies the batch code. Table Specifies the code LN table that contains the data that will be exported into an ASCII file during an export procedure. Ser. No. The serial number that makes the range unique in the table relation. The serial number is only used as an identifier and it forces the correct sorting sequence. Note Use an interval so that ranges can be added later. Table Field The code of the LN table field on which the range-limitation logic expression is based. Related topics Relation between logical ASCII files and physical ASCII files Operator Specifies the relational operator that is used for creating an expression. Allowed values See Operator Value (From) Enter the value the operator will apply to. Only if the operator type is Between or Not Between, the entered value is the start value of a range. Value (To) Enter the end value of the range. Note This field can only be entered if the operator is Between or Not Between. And/or/end Enter the operator that is used to combine several relational expressions into one range condition. If the range rules need more than one line to be expressed properly, enter an and or an or to join the multiple lines. The last line in an expression must end with end of expression. When a range expression goes over one line, the sequence number is the only determination of which line is to be read next. Allowed values See Expression Operator |