SAPTable Extract

image_pdfimage_print

With this extract, data can be read from SAP Data Dictionary tables. You can access any Transparent Table as well as Database View and Projection View table types. Not supported are Maintenance View and Help View.

The name of the SAP Data Dictionary table has to be specified.

Filter

The table can be filtered on any component field of the SAP table.

Field Field name
Filter Type Options are accept or deny. With deny, the condition is negated.
Filter Operators See table below.
Value Filter value
Filter Operators
bt Between. A filter range has to be specified in the field value. Example: [2006,2010]
eq Equal (=)
ge Greater than or equal to (>=)
gt Greater (>)
in Checks if the column data is contained in a list of values. The list is specified in the field value. Example: 2006,2008,2010
le Lower than or equal to (<=)
like

String comparison. The filter value is a pattern in this case. The condition is true if the column data matches the pattern. You can use the following wildcard characters in the pattern:

%: for a sequence of any characters (including spaces).
_: for a single character

Example: KS1000%

lt Lower (<)
ne Not equal to (<>)

Note that the length of the filter value must not exceed the doubled length of the SAP field.

Export data fields

The output structure consists of fields of the SAP Data Dictionary table, which have to be specified in the extract definition. An alias name of the field and a default value in case of empty or null values can be optionally assigned. Note: the total length of all specified fields must not exceed 4000.

Advanced settings

Bulk size

Size of blocks for OLAP Server write requests.

Use caching

Memory, disk, or none (default). See Caching in Extracts.

Sorting of output rows

For SAP Netweaver release 7.31 or higher, it is possible to specify columns on which the resulting rows of the extract are ordered. Therefore, the column name in the export data fields table needs a suffix “$ASC”. You can specify several columns for sorting, in which case the sequence of the sort columns respects the order of the data fields.
For some SAP views, the order of output rows differs between several executions, in which case it is suitable to define sorting on the logical keys of the view.

Example:

Sort the rows on column BELNR.
Export data field: BELNR$ASC

image_pdfimage_print
Was this post helpful?
NoYes (0 rating, 2 votes)
Loading...