Show TOC

Background documentationAdditional Input/Output Files

 

For fields with binary data (field type R) and for long character fields (field type M), additional input/output files are required for the ASCII Adapter to be able to process such fields. For fields of this type, such an additional file must exist. If an additional file does not exist, one is generated. The data contained in such a field is then stored in this additional file by the ASCII Adapter.

Note Note

In SAP ERP, there is only one LONG column allowed per table.

End of the note.
Name and Structure

The name and structure of such additional files is as follows:

<DBFNAME>_<FIELDNAME>.DAT

<DBFNAME> corresponds to the value of DBFNAME in table SMO7ASCAD.

<DBFNAMEFIELDNAME> corresponds to the value of FIELDNAME in table SMO7ASCSTR.

For field type R or M, FIELDLEN in table SMO7ASCSTR should be set to 10 in the case of a fixed record length.

In the ASCII file itself, the numeric offset (not more than 10 digits) is used in such cases. It specifies where the data can be found in the additional file. The offset is zero-based, counted from the beginning of the file. The first four bytes of the additional file contain the length of the data portion for the current row (binary value in Intel format).

Example

The example shows an export definition for the table ABCD that is converted into an ASCII file ABCD.asc. The table contains 3 columns, including one column with comprehensive text data and one column with binary data.

Both columns are exported to the export files ABCD_col_a.asc and ABCD_col_B.asc. The ASCII files should be created with a fixed column length. Set a comma (,) as the decimal delimiter. The target files are emptied before the processing is started. After processing, the source file is also emptied. In the example, only the relevant columns of the control tables SMO7ASCAD and SMO7ASCSTR are shown.

  1. The arrows point to the description entries of the column for the table.

  2. The arrows point to the start position of the relevant column in the file.

  3. The first four bytes of the data area contain the total length of the following data area. (Intel format)

  4. Entries for large text or binary files can contain up to 10 digits and point to the zero-based offset within the additional file.