Data Request settings - Components
In the SmartExporter Windows client, in Home - Change application options - Data Requests - Components tab, various options concerning the components used are available.
Depending on whether you are using the SmartExporter SAP® components or the SAP® standard components to communicate with the SAP® system, you can define different settings here.
It is recommended to use the default settings. You should only modify these settings if you have detailed knowledge of the data.
The following settings are available:
- Filter calculation method using ordering the records
-
Filter calculation method without ordering the records regarding primary key fields
Use this method only when you are positive that the selected tables in the SAP® system are already sorted in the correct order of the primary key fields.
If this is not the case, the method might result in a wrong transfer.
-
Buffer table method
- Convert filter values on SAP® server automatically
The following settings are available:
- Use SAP® standard components without filter calculation method.
-
Use SAP® standard components with filter calculation method.
The runtime behavior of the RFC_READ_TABLE module, which is used for the SAP® standard components, is not ideal due to the implementation by SAP®. By default the filter calculation method is not set when SmartExporter is forced to use SAP® standard components. However, when extracting large data volumes using SAP® standard components without the filter calculation method now and then time outs might occur. Therefore you can select the Use SAP® standard components with filter calculation method option. This might improve the performance when SmartExporter is forced to use SAP® standard components.
Note:
The Use SAP® standard components with filter calculation method option requires that the database provides the records in a sorted order. Please refer to your SAP® administrator to get the necessary information.
So far limitations regarding the performance using the SAP® standard components with filter calculation method have only been observed for the database systems DB2® and Oracle version 10, where not all records have been extracted.
You can check the structure of your database by following the steps below:
- Create a Data Request in SmartExporter and select all key fields.
- Extract the data in a CSV or TXT file.
- Then check the file to see whether the data in the rows of the key fields are displayed in ascending order. If this is not the case, it is highly recommended to install and use the SmartExporter SAP® components.
-
Use SAP® standard components with or without filter calculation methods.
Select for each table which method should be applied.
- You can define how to proceed when problems occur during the Data Request run. The following options are available: Do nothing, display a warning, skip the table but continue running and stop running the Data Request.