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 #
Entity 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.
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.
- Delete & Create: Deletes the object with the specified name and creates a new one.
- Create if not exists: Creates a new object if no object with the specified name could be found.
- Insert: Inserts all records into the specified object.
- Merge: Inserts all records into the specified object and updates already existing entries.
- Parallel: Process batches in parallel mode. This is the default value.
- Serial: Process batches in serial mode. Processing in parallel can cause database contention. When this is severe, the job may fail. If you’re experiencing this issue, submit the job with serial concurrency mode. This guarantees that batches are processed one at a time. Note that using this option may significantly increase the processing time for a job.