Detail Section
Updated 1 week ago
by
Stephanie Krenz
In the details panel (located to the left of the element list in version 1.16 and later) you can adjust the settings for each element. Depending on which element you have selected, different options are available.
If you have not selected or created anything on the left side, up to version 1.14 you will see Nothing selected yet. From version 1.16 you will find helpful keyboard shortcuts in this area.
Details for Tables
Once you have selected a table in the left section, the following options are available in the details section:
General
- Table-Name: SAP table name - cannot be changed
- Alias: can be changed at will and controls the subsequent table name in the database
- Strategy (up to version 1.14 in a Dropdown List - from version 1.16 as tiles)
- Merge: attempts to link new results with existing results
- Overwrite: deletes existing results and saves the new ones
- Append: appends the new results to the existing ones
- Layout: Specially designed for tables where the user does not have permissions per se
Fields
- Select
- All (up to 1.14 - from 1.16 a square with a tick): select all fields in the table
- None (up to 1.14 - from 1.16 click again on the square with the tick): uncheck all fields except the mandatory fields
- Magnifier: search for a specific field
- A to Z (up to 1.14): sort the fields alphabetically or back to the initial sort order
- three lines (from 1.16): sort fields alphabetically (including key fields), sort by selection, sort by field description or field length - clicking Default restores the SAP table's default sorting.
- Refresh Fields: refresh the view
- Fields
- Primary Keys: fields with a key at the beginning of the line are mandatory fields and cannot be deselected
- Hovern (up to 1.14): hover over a column name with your mouse pointer and the description of the field will be displayed
Filters
- Plus +: you can assign an existing filter using the + on the right
- Square with arrow (only useful if the filter assignment has been created): redirects you to the filter (as if you would click on this filter in the left area)
- Filtername: select an existing filter in the left drop-down menu (which was created in the left area)
- Field: select the field to be filtered in the right-hand drop-down menu
- Bucket: you can use the bucket to delete this filter assignment to the field (the original filter is retained)
Dependency
- Plus +: you can add a dependency to an existing repository using the + on the right
- Square with arrow (only useful if the repository has been created): redirects you to the repository (as if you were to click on this repository in the left pane)
- Repository: select an existing repository from the drop-down menu (which was created in the left-hand area)
- Submenu: opens as soon as you have selected a repository, can also be opened via the icon to the left of the bucket icon (up to version 1.14: C or A - from version 1.16 a gear)
- Edit Dependency: *Repositoryname*
- Dependency Type
- In: Query with IN-Statement, e.g. BELNR IN (1,2,3,4,...)
- Between: Query with Between-Statement, e.g. BELNR Between 1 and 10
- Optimized: Combination of IN- and Between-Statements, e.g. BELNR between 1 and 5 AND BELNR NOT IN (1,2,3,5)
- Custom Mapping: if active, the link between the elements themselves can be selected. Works if the fields here have the same name as in the table (case-sensitive).
- Identity: mapping to the filter and the filter field
- Bucket: you can use the bucket to delete this dependency for the repository (the original repository is retained)
Target Repositories
- Plus +: you can add new target repositories via the + on the right
- Square with arrow (only makes sense once the assignment has been created): redirects you to the repository (as if you were to click on this repository in the left pane)
- Repository: select an existing repository from the drop-down menu (which was created in the left-hand area)
- Submenu: opens as soon as you have selected a repository, can also be opened via the icon to the left of the bucket icon (up to version 1.14: C or A - from version 1.16 a gear)
- Edit Target Source: *Repositoryname*
- Custom Mapping: if active, the link between the elements themselves can be selected. Works if the fields here have the same name as in the table (case-sensitive).
- Identity: assignment between field and filter
- Bucket: you can delete this assignment via the bucket (the original repository is retained)
Details for virtual Tables
With one exception, the structure here is the same as in the tables.
In this view, only the Strategy is absent in the General section.
Details for Filters
General
- Filtername: freely selected filter name
- Required: active (Filter is required), inactive (Filter is optional)
- Offline: filter is only applied in dab Nexus, not directly in the SAP tables (ensures better extraction performance for very large SAP tables or for searches on table fields without indexing)
- Type
- Input: user enters the value
- Fixed Value: value is set in the Package
- Well Known: provides the user with input help / search help. e.g. for company code, language, etc.
- Fiscal Year
- Data Type
- String: character string, e.g. for flags with X or for texts
- Date
- Numeric: number
- Condition
Condition | Description | Example |
Equal | Both values are equal | 100 = 100 |
Not Equal | Both values are not equal | 100 <> 99 |
Greater | One value is greater than the other | 100 > 99 |
Greater Equal | One value is greater than or equal to the other | 100 >= 99/100 |
Less | One value is less (smaller) than the other | 99 < 100 |
Less Equal | One value is less than or equal to the other | 99/100 <= 100 |
Like | One value contains parts of the other | %est is contained in Test |
Not Like | One value doesn't contain parts of the other | %ame is not contained in Test |
Between | A value in a certain range | 5 is between 3 and 7 |
In | One value exists in a series of other values | DE exists in the series 'DE, EN, IT, FR' |
Not In | A value doesn't exist in a series of other values | DE doesn't exist in the series 'EN, IT, FR' |
Empty | A value (Character String) must be emtpy | Value = ''. |
Not Empty | A value (Character String) must be filled | Value = 'Here is a text'. |
Values / Ranged Values
The next sub-area changes depending on what you have selected under General > Condition.
Between: Ranged Values > enter range for value, e.g. Company Code from 1000 to 2000
Empty and Not Empty: no value range available
All other Conditions: Values > enter a value, e.g. Company Code is 1000
It can happen that already entered values in Values are not adopted when switching to another condition.
This happens in the following constellation:
You have already entered a value in a condition (e.g. Equal) and now switch to the Between condition.
The value is not adopted. The same happens in the reverse order.
Values
- Plus +: you can add a new value using the + on the right
- Value: enter the value to be filtered (depending on the condition)
- Bucket: you can delete the value via the bucket
Ranged Values
- Plus +: you can add a new value using the + on the right
- Value from - to: enter the values to be filtered between here (only for Condition Between)
- Bucket: you can delete the value via the bucket
Table Relations
The links between (virtual) tables and this filter are displayed here.
- Plus +: you can add a new link using the + on the right
- Square with arrow: redirects you to the (virtual) table
- Bucket: you can delete the link to the (virtual) table via the bucket
Details for Repositories
General
- Name of the Repository
Fields
- Enter an SAP column name to enable auto-mapping: if you enter a name here that does not reflect a column in one of the selected tables, you must link the fields manually
- Plus +: you can add a new filter using the + on the right
- Bucket: you can delete the link to the column via the bucket
Source-Tables
- Reflects the table for the entry at Fields
- Plus +: you can add a new filter using the + on the right
- Square with arrow: redirects you to the (virtual) table
- Gear (from version 1.16): mapping of the Table- & Repository-fields can be adjusted
- Custom Mapping: if enabled, the fields below can be mapped manually
- Identity, Substring, Concat: indicates how exactly specified values must match in order to be accepted (Identity = exact match, Substring = a part must match, Concat = the contents of one or more fields must match)
- Bucket: you can delete the link to the column via the bucket
Target-Tables
- Repository collects values and then uses them to limit the values in the other tables accordingly
- Plus +: you can add a new filter using the + on the right
- Square with arrow: redirects you to the (virtual) table
- C (up to version 1.14): clicking on this opens a submenu in which you can choose between Dependency Types (In, Between, Optimized), see the custom mapping and specify which field is to be used for the mapping under Identity
- A (up to version 1.14): is displayed instead of C if the field could be linked automatically due to the matching filter name
- Gear (from version 1.16)
- Dependency Type
- In: Query with IN-statement, e.g. BELNR IN (1,2,3,4,...)
- Between: query with Between-statement, e.g. BELNR Between 1 and 10
- Optimized: combination from IN- and Between-statements, e.g. BELNR between 1 and 5 AND BELNR NOT IN (1,2,3,5)
- Custom Mapping: indicates whether fields must be linked manually or not
- Feldauswahl: link between filter and field of the selected table
- Dependency Type
- Bucket: you can delete the link to the column via the bucket
The package element Reports is added with version 1.12.
Details for Reports
Only reports that have a tabular output can be used.
You have various options in the detail area for your reports. These are explained below:
General
- Report Name: name of the added report from your selected SAP system, cannot be changed
- Alias: can be changed as required and controls the later table name in the database
Filters
This area changes depending on whether the report could be found or not.
- No Filter configured: Report could be found, but no filter has been created yet
- No Parameters available: Report could not be found, therefore no fields for filtering are available here
In our example, we create the Comments filter (General: Fixed Value, String, Like / Values: Z_Kommentar: Test % / Report Relations: Report -> RS_ABAP_SOURCE_SCAN and Field -> Comment):
In the detail area of the report, the whole thing looks like this:
This setting causes the entire ABAP code of the SAP system to be scanned and all comment lines beginning with Z_Kommentar: Test are found.
