Elements

A package contains various elements like Tables, Virtual Tables, Filters, Repositories, Real-Time Objects and Reports.

Tables

Add an SAP table using the corresponding button above. All tables specified here are later stored as result tables.

When you click on an added table you can set multiple settings:

Alias: enter another name for the table
Bucket: delete the selected table from the Package

Strategy - control the write behaviour in the destination
- Merge: extracted rows will be merged with existing data and will update them
- Overwrite: deletes the table at the beginning of the Extraction
- Append: appends the data to the existing data
- Layout: creates only the table structure in the target without extracting any data
Fields - fields to extract, Primary Keys must be always selected
- Fieldlist: contains all fields of the selected table - select or unselect them to extract the corresponding data
- Sorting of Fields: list all fields by Default (same sorting as in SAP), by Selection, by Name, by Description or by Field Length
- Refresh: reloads the fieldlist
- Toggle selection: selects or unselects all fields (except the Primary Keys)
- Search: search for specific fields
Filters - Apply filters on table fields
- Add: add an existing filter to the selected table
- Go to filter: open the settings of this filter in the Package
- Filter: choose an existing filter from the dropdown list
- Field: select the field where the filter should apply
- Bucket: delete the connection between the selected table and the filter
Dependency - Query the table in dependency of repository values
- Add: add a dependency to an existing repository
- Go to Repository: redirects you to the repository in the Package
- Repository: select an existing repository from the dropdown list
- Gear: change the type of dependency
  - 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).
- Bucket: delete the dependency between the selected table and the repository
Target Repositories - Write table values into a repository
- Add: add a new target repository
- Go to Repository: redirects you to the repository in the Package
- Gear: adjust the mapping of the fields
  - 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).
- Bucket: delete the link between the selected table and the Target Repository

Virtual Tables

Add a virtual table with the SAP table name using the corresponding button at the top. You can also assign an alias here. Virtual tables do not appear as result tables.

The elements for virtual tables are the same as for tables - only the Strategy section doesn't exist.

Filters

Use the corresponding button at the top to add a filter with which you can later restrict values. You can freely choose the name. Filters are applied to tables or virtual tables.

Hint

If you use one of the following names for your filter, the type is automatically set to Lookup: Fiscal Year, Companycode, Company Code, Time Period

Required: values must be set for this filter when creating a Task
Offline: apply filtering on client side
Filter Scope Determination:
- Automatic
- Per Task
- Per SAP System
- Per Variant
Filter Type:
- Input: enter values during Task creation
- Fixed Value: values are pre-set in the Package
- Lookup: select values from SAP during Task creation
- Fiscal Year: enter the fiscal year or set it according to the Task schedule
Condition - controls which filter clause is generated

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'`

Data Type - for the filter value
- String
- Date
- Numeric
Table Relations - apply this filter to the selected tables
- Add: add an existing table to the selected filter
- Go to table: redirects you to the table in the Package
- Select table: choose a table from the dropdown list
- Select field: select one of the fields of the table (you can only select fields that were selected in the field list of the table itself)
- Bucket: delete the link between the selected filter and the table
Report Relations - apply this filter to the selected reports
- Add: add an existing report to the selected filter
- Go to report: redirects you to the report in the Package
- Select report: choose a report from the dropdown list
- Select parameter: choose one of the parameters from the dropdown list
- Bucket: delete the link between the selected filter and the report
Real-Time Objects Relations - apply this filter to the selected Real-Time Objects
- Add: an an existing real-time object to the selected filter
- Go to real-time object: redirects you to the real-time object in the Package
- Select real-time object: choose a real-time object from the dropdown list
- Select field: choose one of the fields from the dropdown list
- Bucket: delete the link between the selected filter and the real-time object

Repositories

Add a repository using the corresponding button at the top - the name can be freely selected. A repository is used to save intermediate results for further processing.

Fields - fields of which the repository consists of
- Add: add one or more fields to the repository
- Bucket: delete fields from the repository
Source Table - tables which supply values to the repository
- Add: add a source table to the repository
- Open source table: redirects you to the table in the Package
- Select source table: choose a table from the dropdown list
- Gear: configure relation
  - Custom Mapping: if active, the link between the field of the source table and the field in the repository can be selected manually
  - Relation types:
    - Identity: inserts the field value of the table into the field of the repository
    - Substring: inserts a part of the field value of the table into the field of the repository
    - Concat: inserts multiple field values of the table into one field of the repository
- Bucket: delete the link between the selected table and the Repository
Target Table - tables which are queried dependend of repository values
- Add: add a target table to the repository
- Open target table: redirects you to the table in the Package
- Select target table: choose a table from the dropdown list
- Gear: configure dependency
  - Custom Mapping: if active, the link between the field of the source table and the field in the repository can be selected manually
  - Dependency types:
    - 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)
- Bucket: delete the link between the selected table and the Repository
Real-Time Objects - real-time Objects which supply values to the repository
- Add: add a real-time object to the repository
- Open real-time object: redirects you to the real-time object in the Package
- Select real-time object: choose a real-time object from the dropdown list
- Gear: configure dependency
  - Numbers: number in the Number Range
  - Subobject: subcategory (often the Company Code, optional depending on Number Range)
  - Fiscal Year: Fiscal year (optional, depending on Number Range)
  - Examples:
    - EINKBELEG: can only be Numbers
    - RF_BELEG: can be Numbers, Subobject or Fiscal Year

Real-Time Objects

Add a real-time object using the corresponding button at the top - the name can be freely selected. A real-time object is used to get numerous Number Range Objects from SAP.

Number Range Object
- Choose a Number Range Object from the dropdown list
Values - in SAP, number ranges define unique sequences of numbers assigned to objects or documents (e.g. invoices, orders, etc.), ensuring consistancy and avoiding duplicates
- Add new Number Range: select one or more available number ranges from SAP (they depend on the Number Range Object you've chosen above)
  - Available: lists all available Number Ranges in the SAP system
  - Selected: lists all Number Ranges you've already selected (you can also delete the selection)
- Add values: add new values manually
- Bucket: delete a value from the list
Filters - apply filters on real-time object values
- Add: add an existing filter to the selected real-time object
- Go to filter: open the settings of this filter in the Package
- Filter: choose an existing filter from the dropdown list
- Field: select the field where the filter should apply
- Bucket: delete the connection between the selected table and the filter
Target Repositories - write real-time object values into a repository
- Add: add a new target repository
- Go to Repository: redirects you to the repository in the Package
- Gear: configure dependency
  - Numbers: number in the Number Range
  - Subobject: subcategory (often the Company Code, optional depending on Number Range)
  - Fiscal Year: Fiscal year (optional, depending on Number Range)
  - Examples:
    - EINKBELEG: can only be Numbers
    - RF_BELEG: can be Numbers, Subobject or Fiscal Year
- Bucket: delete the link between the selected real-time object and the Target Repository

Reports

Note

Only reports that have a tabular output can be used.

Add a report using the corresponding button at the top. Then enter the name of the Report (SAP Transaction) in the popup and continue. dab Nexus will load the parameters available, if any exist.

Filters - apply filters to the Report

Add: add an existing filter to the selected report
Go to filter: open the settings of this filter in the Package
Filter: choose an existing filter from the dropdown list
Field: select the field where the filter should apply
Bucket: delete the connection between the selected table and the filter

Tables​

Virtual Tables​

Filters​

Repositories​

Real-Time Objects​

Reports​