Opening the Destination Settings #
- Create or select an existing extraction (see also Getting Started with Table).
- Click [Destinations]. The window “Destination Settings” opens.
The following settings can be defined for the destination:
Destination Settings #
File Name #
determines the name of the target table. You have the following options:
- Same as name of SAP object: Copy the name of the SAP object
- Same as name of extraction: Adopt name of extraction
Custom: Here you can define your own name.
- Append timestamp: adds the current timestamp in the format [_YYYY_MM_DD_hh_mm_ss_fff] to the file name of the extraction.
Column name style #
Defines the style of the column name. Following options are available:
- Code: The SAP technical column name is used as column name in the destination e.g., MAKTX.
- PrefixedCode: The SAP technical column name is prefixed by SAP object name and the tilde character e.g., MAKT~MAKTX
- CodeAndText: The SAP technical column name and the SAP description separated by an underscore are used as column name in the destination e.g., MAKTX_Material Description (Short Text).
- TextAndCode: The SAP description and the SAP technical column name description separated by an underscore are used as column name in the destination e.g., Material Description (Short Text)_MAKTX.
Date conversion #
Convert date strings
Converts the character-type SAP date (YYYYMMDD, e.g., 19900101) to a special date format (YYYY-MM-DD, e.g., 1990-01-01). Target data uses a real date data-type and not the string data-type to store dates.
Convert invalid dates to
If an SAP date cannot be converted to a valid date format, the invalid date is converted to the entered value. NULL is supported as a value.
When converting the SAP date the two special cases 00000000 and 9999XXXX are checked at first.
Convert 00000000 to
Converts the SAP date 00000000 to the entered value.
Convert 9999XXXX to
Converts the SAP date 9999XXXX to the entered value.
The data is transferred uncompressed and stored as a csv file.
The data is transferred compressed and stored as a gz file.
Blob Type #
Creates an Append Blob.
Creates a Block Blob.
Note: For both file types an MD5 hash is created upon upload to Azure storage.
Folder path #
To write extraction data to a location within a specific folder in an Azure Blob container, enter a folder name without slashes.
Subfolders are supported and can be defined using the following syntax:
CSV File Splitting #
Writes extraction data of a single extraction to a single file in Azure storage.
Writes extraction data of a single extraction to multiple files in Azure storage. Each filename is appended by _part[nnn]. In case of .csv files, the file size is determined by the value set in Max. CSV file size.
Max. CSV file size
Maximum size of a .csv file stored in an Azure storage account.
Note: The option Max. CSV file size does not apply to gzip files. The size of a gzipped file cannot be determined in advance.