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. Note that Maintenance View and Help View are not supported. The name of the SAP Data Dictionary table has to be specified.
The table can be filtered on any component field of the SAP table.
|Filter Type||Options are accept or deny. With deny, the condition is negated.|
|Filter Operators||See table below.|
|bt||Between. A filter range has to be specified in the field value. Example: [2006,2010]|
|ge||Greater than or equal to (>=)|
|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 (<=)|
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).
|ne||Not equal to (<>)|
Note that the length of the filter value must not exceed the doubled length of the SAP field.
Note: to extract a CDS View, you must specify its generated DDL SQL View, which can be displayed in SAP with the Dictionary View Editor (transaction SE11).
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 that the total length of all specified fields must not exceed 4000.
Size of blocks for OLAP Server write requests.
Memory, disk, or none (default). See Caching in Extracts.
Sorting of output rows
The output rows are automatically sorted on all primary keys of the table or view as defined in the SAP ABAP Dictionary.