One or more SAP tables or views can be selected under the tab Tables And Fields. The tab Tables and Fields consists of three main subsections:
To add a new table or remove an existing table, click [Add] or [Remove].
The following options are available on the right under Fields for the column selection:
The Table component imports and highlights the dedicated indices, such as primary key and/or sorting options, from SAP.
Note: using the indicated fields for filtering increases performance when applying WHERE-clause.
The column name and the column description can be filtered.
Aggregate Function (2)
The following aggregation functions are available for column contents:
- None: No aggregation
- MEAN: Average
- COUNT: Number
- MAX: Maximum
- MIN: Minimum
- SUM: Total
Tipp: The aggregate function is only available by numeric field data types (e.g., INT, FLOAT, DECIMAL).
Conv. - Use Conversion Routine (3)
Activating the tri-state checkbox defines whether the conversion routines stored in the Data Dictionary are used for the respective fields.
Note: activating the conversion routines in SAP leads to significant performance decrease. The extraction duration increases.
|(1)||no conversion routines selected|
|(2)||conversion routines enabled;
only avaiable with function module Z_XTRACT_IS_TABLE_COMPRESSION
|no data type safety|
|(3)||conversion routines enabled;
only avaiable with function module Z_THEO_READ_TABLE
|assured data type safety|
Typical examples for conversition routines are the language key (for example, D (4) in the database, but DE after conversion) or the project number (for example, T000012738GT in the database, T/12738/GT after conversion). After the conversion, the value is always displayed as it appears in the transaction SE16N in the SAP GUI.
The subsection Preview displays a real-time preview of the selected fields, when the button “[Load live preview] is clicked.
Note: Using non-indexed fields in the WHERE-clause can lead to timeouts during the preview of large tables.
[Load live preview]
Allows a real-time preview of the extraction data without executing the extraction.
You can also preview the data with aggregation functions.
Returns the number of rows/data records of an extraction, considering the WHERE and HAVING clauses stored.
A new lookup is performed on the selected table(s). Existing mappings and field selections are retained, which is not the case when the table is added again.
It may be necessary to renew the metadata, for example, if a table has been adjusted on the SAP side, another source system has been connected, or the source system has been updated. In such cases, data inconsistencies can occur that are resolved by this function.