Extraction Settings
This page contains an overview of the extraction settings in the Xtract ODP component.
To open the extraction settings, click [Extraction Settings] in the main window of the component.
Extraction Settings
Package Size
The extracted data is be split into packages of the defined size. The default value is 50000 lines.
A package size between 20000 and 50000 is advisable for large amounts of data. 0 means no packaging. Not using packaging can lead to an RFC timeout for large data extracts.
Warning
RFC_ERROR_SYSTEM_FAILURE - No more storage space available for extending an internal table
To avoid a memory overflow on the SAP source system and to avoid huge overheads, choose a package size that suits your memory capacity.
Make sure that your SAP version includes the necessary notes, see Prerequisites.
Adjust Currency Decimals
The default number of decimal places for a currency in the SAP database is 2 decimals. Currencies that do not have decimals are also stored in this format, e.g. JPY, VND, KRW, etc.
Example:
| Currency | Actual Amount | Amount stored in SAP database |
|---|---|---|
| JPY | 100 | 1.00 |
| KRW | 10000 | 100.00 |
When extracting currencies with no decimals, the amount stored in SAP is returned e.g., 100 JPY are extracted as 1.00. To correct the decimal placement of the extracted data, activate Adjust Currency Decimals. If Adjust Currency Decimals is active, currencies without decimals are multiplied by a factor that balances out the decimals.
Adjust Currency Decimals also requires the extraction of the corresponding CURRENCY field that can be used as a reference for the multiplication factor. Use the [Load live preview] function to find the correct currency field/s.
- If the currency field is part of the table, add it to the output.
- If the currency field is in another table, join the tables.
- If the reference is not part of a table, Adjust Currency Decimals cannot be used.
Note
The multiplication factor used in Adjust Currency Decimals is determined by the SAP currency table TCURX. To access the table, the following SAP Authority objects must be set in SAP: S_TABU_NAM ACTVT=03; TABLE=TCURX.