Settings
This page contains an overview and description of all available SAP Table and View settings.
The SAP Table and View settings consist of the following subsections:
- Control Buttons to close, save or delete the service .
- Table or View displays the name and description of the selected SAP Table or View .
- Advanced Settings define how the data is extract from SAP .
- Output Columns define what columns to extract .
- WHERE Clause and WHERE Clause Editor define what rows to extract .
- Joins joins two or more tables and extracts the result of the join .
Control Buttons
[Delete]
Deletes the service.
[Cancel]
Closes the service and dismisses any changes.
[Run]
Opens the Run Menu to testrun the service directly in yunIO.
[Save]
Saves changes in the service.
Table or View
The Table or View section displays the name and description of the selected table or view.
| Icon | Description |
|---|---|
| Adds a table or view to the service. | |
| Removes a table or view from the service. |
Advanced Settings
Function Name
Specifies the name of the function module used for data extraction. This field is filled automatically depending on what function modules are installed on your SAP system. Custom function modules are supported.
The following function modules can be used to extract tables:
- RFC_READ_TABLE (TAB512)
- /BODS/RFC_READ_TABLE (TAB2048)
- /SAPDS/RFC_READ_TABLE (TAB2048)
- /BODS/RFC_READ_TABLE2
- /SAPDS/RFC_READ_TABLE2
- Z_THEO_READ_TABLE
- /THEO/READ_TABLE (recommended)
Warning
Duplicates in the target environment.
The SAP standard modules for table extraction do not have pointers for table fields. In larger tables this may cause low performance and duplicates in the target environment. Use the function module THEO/READ_TABLE from Theobald Software to ensure smooth extractions.
Note the necessary SAP Authority Objects:
Row Limit
Specifies the maximum number of extracted records. 0 extracts all data. You can use this option to perform tests with a small amount of data by entering a row limit of e.g., 1000.
Rows per package
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.
Run in background
If Background job timeout (seconds) checkbox is activated, the table extraction is executed as a background job in SAP. This setting is optional and is supported in combination with function module THEO/READ_TABLE or Z_THEO_READ_TABLE version 2.0. Activate the setting Background job timeout (seconds) for long-running extractions with a large amounts of data that may run into a timeout error (“Time limit exceeded”), when using the foreground mode.
Tip
The extraction jobs can be found in the SAP JobLog (SM37) under the JobName theo_read_table.
Warning
Shared Memory ran out of memory!
If this error message pops up when running an extraction in the background, adjust the size of the Shared Memory. SAP recommends a Shared Memory size of 800MB~1.5GB for a production/test system or 2GB~4GB for S/4 systems, see SAP Support: How to solve SYSTEM_NO_SHM_MEMORY runtime error.
Refresh metadata
A new lookup is performed on the selected table(s). Existing mappings and field selections are kept, which is not the case when the table is added again. Use this function to resolve data inconsistencies that can occur in the following situations:
- the structure of the source table has been changed in SAP
- another SAP source system has been connected
- the SAP source system has been updated
Output Columns
You can select either all or only individual columns for extraction.
Per default all columns are selected to be extracted. Deselect the columns you don’t want to extract.
WHERE Clause
You can use a WHERE clause to filter table records, see SAP ABAP Documentation: SELECT-WHERE. Enter WHERE clauses manually in Text mode or use the WHERE Clause Editor in Editor Mode.
Joins
You can join two or more SAP tables and extract the result of the join, see SAP Help: Inner Join and Outer Join. For information on how to join tables in yunIO, see Table Joins.