CSV Flat File
The destination is a CSV (comma-seperated values) flat file.

The following options can be defined for the CSV flat file destination.

CSV-Flat-Destination-Details

File

Directory
Defines the directory to save the destination flat files.

CSV Settings

Column seperator
Defines how two columns in CSV are separated.

Row separator
Defines how two rows in CSV are separated.

Quote symbol
Defines which character will be encased in the value of a table row, if the value contains the column separator.

Column names in first row
Defines if the first row contains the column names. This option is set per default.

Row separator after last row
Defines if the last row contains a row separator. This option is set per default.

Convert / Encoding

Decimal separator
Defines the decimal separator of decimal number for the output. Dot (.) is the default value.

Date format
Defines a customized date format (e.g. YYYY-MM-DD or MM/DD/YYYY) for converting valid SAP dates (YYYYMMDD). Default is YYYY-MM-DD.

Time format
Defines a customized time format (e.g. HH-MM-SS or HH:MM:SS) for converting valid SAP times (HHMMSS). Default is HH:MM:SS.

Text Encoding
Defines the text encoding.

Extraction-specific settings

Click on Destination to define extraction-specific settings.

XU_flatfile_csv_Destination

File Name

Specify the name of the target file here. You have the following options:
Same as name of SAP object
Same as name of extraction and
Custom to specify a custom name yourself.

Append timestamp: create a new target file and add timestamp to the file name.

Column Name Style:
Code, CodeAndText or TextAndCode. Defines, whether the column name displays the technical name or the technical name and description of the SAP column.

Date Conversion

Convert invalid dates to
Every invalid value will be converted into this value. NULL is supported as value.
You should set this value to be used in case of non convertible date values.
During the conversion of invalid SAP dates the two specific cases 00000000 and 9999XXXX will be checked at first.

Convert 00000000 to
Converts all SAP date 00000000 to the specified value.

Convert 9999XXXX to
Converts all SAP date 9999XXXX to the specified value.

Existing files

Replace file: The export process will overwrite existing files.
Append results: The export process will append new data to an already existing file.
Abort extraction: The process will be aborted if the file already exists.

Destination Settings